A fix is available
APAR status
Closed as new function.
Error description
DB2 new function
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All Db2 11 for z/OS data sharing users * * who use the GDPS Continuous Availability * * Zero Data Loss solution. * **************************************************************** * PROBLEM DESCRIPTION: This APAR provides new function to * * print the Compression Dictionary Data * * Set (CDDS). * **************************************************************** * RECOMMENDATION: * **************************************************************** The Compression Dictionary Data Set (CDDS) is a VSAM KSDS that contains the compression dictionaries for compressed table spaces in Db2. In the source Db2 data sharing group, the compression dictionaries are written to the CDDS. The CDDS is synchronously mirrored by Peer-to-Peer Remote Copy (PPRC) to the proxy Db2 data sharing group. On the proxy Db2 data sharing group, the compression dictionaries are read from the CDDS to decompress log record content before returning log records to IFI 306 callers. This APAR provides a new stand-alone utility called DSNJU008 to print the CDDS. ________________________________________________________________ DSNJU008 (Print CDDS) The DSNJU008 (Print CDDS) stand-alone utility prints the CDDS. --------------------------------------------------------------- Environment The DSNJU008 program runs as a batch job. This utility can be executed either when Db2 is running and when it is not running. It can be executed on the source Db2 data sharing group and the proxy Db2 data sharing group. --------------------------------------------------------------- Authorization required The user ID of the DSNJU008 job must have requisite RACF authorization. --------------------------------------------------------------- Required data sets DSNJU008 recognizes DD statements with the following DD names: SYSUT1 Specifies and allocates the Compression Dictionary Data Set. This statement is required. It allocates the CDDS. If the CDDS must be shared with a concurrently executing Db2 online subsystem, use DISP=SHR on the DD statement. If the CDDS must be shared on the proxy Db2 data sharing group, also specify ROACCESS=(ALLOW,TRKLOCK). SYSPRINT Specifies a data set or print spool class for print output. This statement is required. The logical record length (LRECL) is 132. SYSIN Contains the control statement for the print CDDS utility. --------------------------------------------------------------- Running the DSNJU008 utility Use the following EXEC statement to execute this utility: // EXEC PGM=DSNJU008 ________________________________________________________________ Syntax and options of the DSNJU008 control statement The DSNJU008 control statement specified in the SYSIN data set allows you to specify the records that are printed and how they are formatted. DSNJU008 (Print CDDS) syntax diagram >>--------------------------------------------------------> | | | | ---DBID(hex-constant)--- ---PSID(hex-constant)--- >---------------------------------------------------------> | | | | ---PART(hex-constant)--- ---VER(hex-constant)---- ---DUMP(NO)------ ---SYSTEM(NO)----- | | | | >---------------------------------------------------------> | | | | ---DUMP(YES)----- ---SYSTEM(YES)---- | | ---SYSTEM(ONLY)--- >-------------------------------------------------------->< | | ---LIMIT(integer-constant)---- Option descritions The following keywords can be used in the control statement: DBID(hex-constant) Specifies a hexadecimal database identifier (DBID). DSNJU008 prints only the compression dictionary records that are associated with that DBID. Specify this keyword only once in the job. hex-constant is a hexadecimal value that consist of one to 4 characters. Leading zeros are not required. You can find the DBID in any of the following ways: - The DBID is displayed in many DB2 messages. - You can find the DBID in the Db2 catalog for a specific objects (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 2 bytes of HPGOBID. PSID(hex-constant) Specifies a hexadecimal page set ID identifier (PSID) of a table space. If you specify PSID, you must also specify DBID. DSNJU008 prints only the compression dictionary records that are associated with the DBID and the PSID. Specify this keyword only once in the job. hex-constant is a hexadecimal value that consist of one to 4 characters. Leading zeros are not required. Whenever Db2 changes the data, the log record that describes the change identifies the database by DBID and the table space by page set ID (PSID). You can find the PSID column in the SYSIBM.SYSTABLESPACE catalog table. When you select the PSID from a catalog table, the value is displayed in decimal format. Use the SQL HEX function in your select statement to convert them to hexadecimal. Alternatively, you can use the DSN1PRNT utility to format the data sets for tables and find the PSID in the last 2 bytes of HPGOBID. If you specify PSID, you must also specify DBID. PART(hex-constant) Specifies a hexadecimal part 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 part number for that identifier. hex-constant is a hexadecimal value that consist of one to 4 characters. Leading zeros are not required. Specify this keyword only once in the job. You must also specify the DBID and the PSID keywords that correspond to those partitions. If this keyword is not specified, records for all partitions associated with the DBID and PSID will be printed. VER(integer-constant) Specify either 1, 2 or 3 for the CDDS version number. Up to 3 versions of the compression dictionary are kept in the CDDS for an object. Version 1 is the most recent compression dictionary. DSNJU008 prints only the records that are associated with the specified CDDS version number. Specify this keyword only once in the job. If this keyword is not specified, records for all CDDS version numbers will be printed. DUMP(YES|NO) Specify whether to generate a hexadecimal output of each compression dictionary record. Specify this keyword only once in the job. The default value is DUMP(NO) (YES) Generates a hexadecimal output of the compression dictionary record. (NO) Generates only a summary line of the compression dictionary record. SYSTEM(YES|NO|ONLY) Specify whether to generate a hexadecimal output of system records in the CDDS. Specify this keyword only once in the job. The default value is SYSTEM(NO) (YES) Generates a hexadecimal output of the system records in the CDDS. (NO) The system records in the CDDS are not printed. (ONLY) Generates only the hexadecimal output of the sytem records in the CDDS. No compression dictionary records will be printed. LIMIT(integer-constant) Specifies an integer-constant to limit the number of lines of output that is generated by DSNJU008. integer-constant is an integer value that consists of one to 10 characters. The maximum value that can be specified is 4294967295. Leading zeros are not required. The default value is LIMIT(4294967295). ________________________________________________________________ Sample DSNJU008 control statement Use the sample control statements as models for developing your own DSNJU008 control statements. //PLM8 EXEC PGM=DSNJU008 //STEPLIB DD DSN=USER.TESTLIB,DISP=SHR // DD DSN=DB2A.SDSNLOAD,DISP=SHR //SYSPRINT DD SYSOUT=* //SYSUT1 DD DSN=TEST.CDDS,DISP=SHR //SYSIN DD * DBID(011D) PSID(0002) VER(1) ________________________________________________________________
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PI94055
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-02-20
Closed date
2018-03-14
Last modified date
2018-04-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI54457
Modules/Macros
DSNFMNFM DSNFPMSG DSNFSAMG DSNJUMT0 DSNJU008 DSNJU08A DSNJU08E DSNRJTCV HDBBB10J
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RB10 PSY UI54457
UP18/03/15 P F803
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 April 2018