Syntax and options of the DSNJU008 control statement

Option descriptions

The following keywords can be used in a control statement in the SYSIN data set:

DBID(hex-constant)

Specifies a hexadecimal database identifier (DBID). DSNJU008 prints only the records in the compression dictionary data set (CDDS) that are associated with that DBID. Specify this keyword no more than once in the job.

hex-constant is a hexadecimal value that consists of one to four characters. Leading zeros are not required.

You can find the DBID in the following ways:

• The DBID is displayed in many Db2 messages.
• You can find the DBID in the Db2 catalog for a specific object (for example, in the column that is named DBID of the SYSIBM.SYSTABLESPACE catalog table).

  When you select a DBID from a catalog table, the value is displayed in decimal format. Use the SQL HEX function in a SELECT statement to convert a DBID to hexadecimal format. The following SQL statements show this use of the HEX function:

  SELECT NAME, DBNAME, HEX(DBID), HEX(PSID)
  FROM SYSIBM.SYSTABLESPACE
  WHERE NAME ='table-space-name'
  

• You can use the DSN1PRNT utility to format the data sets for tables or indexes, and find the DBID in the first two bytes of HPGOBID.

PSID(hex-constant)

Specifies a hexadecimal page set identifier (PSID) of a table space. If you specify the PSID keyword, you must also specify the DBID keyword. DSNJU008 prints only the expansion dictionary records that are associated with the DBID and the PSID. Specify this keyword no more than once in the job.

hex-constant is a hexadecimal value that consists of one to four characters. Leading zeros are not required.

You can find the PSID in the following ways:

• Whenever Db2 changes the data, the log record that describes the change identifies the database by the DBID and the table space by the PSID. You can find the PSID column in the SYSIBM.SYSTABLESPACE catalog table.

  When you select a PSID from a catalog table, the value is displayed in decimal format. Use the SQL HEX function in a SELECT statement to convert the PSID to hexadecimal format.

• You can use the DSN1PRNT utility to format the data sets for tables, and find the PSID in the last two bytes of HPGOBID.

PART(hex-constant)

Specifies a hexadecimal partition number identifier, which is associated with a database identifier (DBID) and a data page set identifier (PSID). DSNJU008 prints only the records that are associated with the specified partition number.

hex-constant is a hexadecimal value that consists of one to four characters. Leading zeros are not required.

Specify the PART keyword no more than once in the job. When you specify the PART keyword, you must also specify the DBID and the PSID keywords that correspond to the partitions that are identified by the PART keyword. If the PART keyword is not specified, records for all partitions that are associated with the DBID and PSID are printed.

VER(integer-constant)

Specifies the version of the expansion dictionary that is to be printed. This value must be 1, 2, or 3.

Up to three versions of the expansion dictionary are kept in the CDDS for an object. Version 1 is the most recent expansion dictionary. When you specify the VER keyword, DSNJU008 prints only the records for the specified expansion dictionary version.

Specify the VER keyword no more than once in the job. If you do not specify the VER keyword, DSNJU008 prints the records for all expansion dictionary versions.

DUMP(YES|NO)

Specifies whether hexadecimal output for each expansion dictionary record and the exclusion list are printed.

YES

Specifies that hexadecimal output of expansion dictionary records and the exclusion list are printed.

NO

Specifies that hexadecimal output of expansion dictionary records and the exclusion list are not printed. NO is the default.

Specify the DUMP keyword no more than once in the job.

SYSTEM(YES|NO|ONLY)

Specifies whether hexadecimal output of system records in the CDDS is printed. System records are used for managing the CDDS. The output of the system records is for use by IBM® Support.

YES

Specifies that hexadecimal output of system records in the CDDS is printed.

NO

Specifies that hexadecimal output of system records is not printed. NO is the default.

ONLY

Specifies that hexadecimal output of only the system records in the CDDS is printed. expansion dictionary records are not printed.

When SYSTEM(YES) or SYSTEM(ONLY) is specified, hexadecimal output of system records is printed, regardless of the DUMP setting.

Specify the SYSTEM keyword no more than once in the job.

LIMIT(integer-constant)

Specifies the maximum number of lines of output that the DSNJU008 utility prints.

integer-constant is an integer value of one to 10 characters. The maximum value is 4294967295, which is also the default.

DSNJU008 always prints complete expansion dictionary records, which can cause the number of lines that are printed to exceed integer-constant. If part of a record is not printed when integer-constant is reached, DSNJU008 prints the rest of that record.

Specify the LIMIT keyword no more than once in the job.

EXCLIST(YES|NO)

Specifies whether the exclusion list is printed. The exclusion list contains information about expansion dictionaries that could not be inserted into the CDDS.

YES

Specifies that the exclusion list is printed.

Tip: If you specify EXCLIST(YES), you can run REORG TABLESPACE INITCDDS YES on the table spaces in the exclusion list to insert the expansion dictionaries in the CDDS. Performing that action reduces the number of excluded table spaces.

NO

Specifies that the exclusion list is not printed. NO is the default.