extbl_location - External table location configuration parameter
When a CREATE EXTERNAL TABLE statement is processed, and when the REMOTESOURCE option of the statement is set to LOCAL, the extbl_location parameter determines the path to the external table file.
When DB2_LOAD_RESTRICTED_IO_PATH registry variable is set to USE_EXTBL_LOCATION, the LOAD, ADMIN_CMD(IMPORT) and ADMIN_CMD(EXPORT) operations are restricted to only access files which are in paths specified by the extbl_location and extbl_strict_io parameters.
- Configuration type
- Database
- Parameter type
- Configurable online (requires a database connection)
- Default [range]
- instance install-path [<path-to-target-directory>]
When the extbl_strict_io configuration parameter is set to:
- YES
- The extbl_location configuration parameter can specify only a single path,
and the path to the external table file is relative to that path followed by the authorization ID of
the table definer. For example, if extbl_location is set to
/home/xyz
and the authorization ID of the table definer isuser1
, the path to the external table file is relative to/home/xyz/user1/
. - NO
- The extbl_location configuration parameter can specify multiple paths (separated by semicolons), and the path to the external table file must be one of the specified paths.