extbl_strict_io - External table path type configuration parameter
When a CREATE EXTERNAL TABLE statement is processed, and when the REMOTESOURCE option of the statement is set to LOCAL, the extbl_strict_io parameter determines whether the path to the target directory is an absolute or relative path.
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]
- NO [YES, NO]
- YES
- The extbl_location configuration parameter can specify only one path. When
a CREATE EXTERNAL TABLE statement is issued, the path specified for 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/xyzand 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. When a CREATE EXTERNAL TABLE statement is issued, the path to the external table file must be one of those paths.