Information
The EXTBL_LOCATION database configuration parameter provides an allow list of paths that external tables may access for local files, for both reading and writing. It is recommended that this value be set to appropriate paths with the understanding that confidential data may reside in this directory. Specifying appropriate paths is part of an organizations standard operating procedures (SOP).
Rationale:
External tables can read and write data to the paths configured within the EXTBL_LOCATION configuration parameter. To avoid a loss of confidentiality of the data which may be reside in these paths, they should be examined to ensure they match the values specified by the SOP.
NOTE: Nessus has provided the target output to assist in reviewing the benchmark to ensure target compliance.
Solution
To specify an external table location, perform the following commands:
Connect to the Db2 database
db2 => connect to <dbname>
Run the following command:
db2 => update database configuration using extbl_location <paths>