DB2_SELECTION

The parameter DB2_SELECTION defines the tables that should be processed when reading Db2 log files and Db2 image copy data.

Multiple tables can be specified, separated by semicolon or comma.

During the pre-processing (output stage 1) only the records from the data or image copies relevant to the specified tables are retrieved.

The format is:

creator1,+tname1,+tname2,...;creator2,+tname3;....

The first value is the creator of the table and the following values (separated by commas) are the desired table names of that creator. Tables can be selected or deselected with a + (plus) or (minus) sign. Multiple creators can be separated by a semicolon and multiple tables within a creator are separated by a comma. Table names can also be generically defined, e.g. +SYS*.

If this parameter is not specified, the script reads the Db2 tables that should be selected with the database name from Input_DatabaseName from the repository.

Example:


DB2_SELECTION = 'SYSTEM,+SYSCATALOG,+SYSCOLUMNS;'
DB2_SELECTION = 'SYSTEM,+SYS*,-SYSCATALOG;'