A fix is available
APAR status
Closed as new function.
Error description
Code to support future new function
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All Db2 13 for z/OS users. * **************************************************************** * PROBLEM DESCRIPTION: In preparation for the future * * capability of converting the remaining * * Db2 catalog and directory objects to * * Universal Table Spaces (UTS), the * * LISTDEF Utility has been updated to * * accept DSNDB01.SYSUTILX, * * SYSIBM.SYSUTILX, and SYSIBM.SYSUTIL * * along with catalog and directory * * object table names in LISTDEF INCLUDE * * and EXCLUDE clauses. * **************************************************************** The Db2 catalog and directory still contain table spaces that have not yet been converted to Universal Table Spaces (UTS). The 21 remaining non-UTS catalog and directory table spaces will be enabled for UTS conversion in the future. In preparation for that UTS conversion process, the LISTDEF utility is being enhanced to allow for the specification of DSNDB01.SYSUTILX, SYSIBM.SYSUTILX, and SYSIBM.SYSUTIL along with catalog and directory table names in LISTDEF INCLUDE and EXCLUDE clauses. The Db2 installation CLIST is also updated so that it uses the new LISTDEF capabilities in the tailoring of jobs that are used during the Db2 install, migration and function level activation processes.
Problem conclusion
Temporary fix
Comments
This APAR enhances the LISTDEF utility and the Db2 installation CLIST in preparation for the future UTS conversion of the 21 remaining catalog and directory table spaces that are not yet universal table spaces. The LISTDEF utility is enhanced to allow: - Catalog and directory table names to be specified in the INCLUDE and EXCLUDE clauses. - DSNDB01.SYSUTILX, SYSIBM.SYSUTILX, and SYSIBM.SYSUTIL to be specified in the INCLUDE and EXCLUDE clauses. This enhancement will be available after the code for this APAR is active in the utility batch address space and the Db2 DBM1 address space (Db2 stopped and started). Until then, these error messages could be received: - DSNU537I object IS NOT ALLOWED IN THE LIST - DSNU470I TABLESPACE DSNDB01.SYSUTILX, ITS TABLES AND INDEXES CANNOT BE INCLUDED IN A LIST OF OBJECTS Examples of what is allowed with this enhancement: - LISTDEF list-name INCLUDE TABLESPACES TABLESPACE DSNDB01.SYSUTILX - LISTDEF list-name INCLUDE TABLESPACES TABLE SYSIBM.SYSUTIL - LISTDEF list-name INCLUDE TABLESPACES TABLE SYSIBM.SYSUSERAUTH Additional keywords: MSGDSNU537I MSGDSNU470I The Db2 installation CLIST is also modified to change the following Db2 sample jobs to support the future conversion of non-UTS Db2 directory and catalog table spaces to UTS table spaces: - DSNTIJCX (Check Db2 directory and catalog indexes) - DSNTIJDE (Delete Db2 system data sets) - DSNTIJIC (Copy Db2 directory and catalog) Table 1 below describes the changes to the Db2 sample jobs. Table 2 and Table 3 below list the non-UTS catalog and directory table spaces whose names do not start with SYSTS. These non-UTS table spaces will be converted in the future to UTS table spaces with names starting with SYSTS. Non-UTS catalog table spaces with names that start with SYSTS and contain only one table will also be converted to UTS table spaces in the future but they will retain their current name. Table 2 and Table 3 also specify the corresponding UTS replacement table spaces and the tables currently residing in the non-UTS table space. For Table 2, the fourth column lists the Db2-defined indexes on each table in the non-UTS table space. Table 1. Db2-supplied sample jobs modified by this PTF +-----------------------------------------------------------+ |SAMPLE | Change Description | | JOB | | +--------|--------------------------------------------------+ |DSNTIJCX| Job step DSNCX1 (Check indexes for the | | | --------------- Db2 catalog (DSNDB06)) | | | | | | Each CHECK INDEX(ALL) TABLESPACE DSNDB06.<tsname>| | | statement, which specifies a non-UTS <tsname> | | | that is listed in column 1 of Table 2, is | | | modified to specify the Db2-defined indexes on | | | each table residing in the non-UTS table space | | | instead. The Db2-defined indexes are grouped by | | | table and there is one CHECK INDEX for all the | | | indexes of a table. | | | | | | The tables in each non-UTS table space and the | | | Db2-defined indexes on each table are listed in | | | columns 3 and 4 of Table 2. | | | | | | For example, consider the following CHECK INDEX | | | statement for a non-UTS table space: | | | | | | CHECK INDEX (ALL) TABLESPACE DSNDB06.SYSGRTNS | | | | | | This example statement is replaced with the | | | following CHECK INDEX statements with specific | | | indexes: | | | | | | CHECK INDEX(SYSIBM.DSNROX01) | | | CHECK INDEX(SYSIBM.DSNRSX01, SYSIBM.DSNRSX02) | | | | | | where: | | | - SYSIBM.DSNROX01 is the Db2-defined index on | | | table SYSIBM.SYSROUTINES_OPTS which resides | | | in the non-UTS table space DSNDB06.SYSGRTNS. | | | - SYSIBM.DSNRSX01, SYSIBM.DSNRSX02 are the | | | Db2-defined indexes on table | | | SYSIBM.SYSROUTINES_SRC which resides in the | | | non-UTS table space DSNDB06.SYSGRTNS. | | | | |--------|--------------------------------------------------| |DSNTIJDE| Job step DSNTIDC (Deletes directory and catalog | | | ---------------- data sets) | | | | | | Job step DSNTIDC is modified as follows: | | | o Instead of deleting the VSAM data set of a | | | non-UTS table space outright, this step now | | | verifies the existence of the VSAM data set | | | of every non-UTS table space, as listed in | | | column 1 of Table 2 and Table 3, before | | | deleting it. | | | o NEW: This step verifies the existence of the | | | VSAM data set of every new UTS table space | | | replacing a non-UTS table space, as listed in | | | column 2 of Table 2 and Table 3, before | | | deleting it. | | | | | | For example, consider the following DELETE | | | statement for a non-UTS table space: | | | | | | DELETE - | | | (DSNC!!0.DSNDBC.DSNDB06.SYSGRTNS.I0001.A001) - | | | CATALOG(DSNC!!0) | | | | | | This example statement is replaced with the | | | following LISTCAT-IF-ELSE statements for the | | | non-UTS table space and its replacement UTS | | | table spaces: | | | | | | LISTCAT ENT | | | ('DSNC!!0.DSNDBC.DSNDB06.SYSGRTNS.I0001.A001') | | | IF LASTCC = 0 THEN - | | | DELETE - | | | (DSNC!!0.DSNDBC.DSNDB06.SYSGRTNS.I0001.A001) - | | | CATALOG(DSNC!!0) | | | ELSE | | | SET MAXCC = 0 | | | LISTCAT ENT | | | ('DSNC!!0.DSNDBC.DSNDB06.SYSTSGRO.I0001.A001') | | | IF LASTCC = 0 THEN - | | | DELETE - | | | (DSNC!!0.DSNDBC.DSNDB06.SYSTSGRO.I0001.A001) - | | | CATALOG(DSNC!!0) | | | ELSE | | | SET MAXCC = 0 | | | LISTCAT ENT | | | ('DSNC!!0.DSNDBC.DSNDB06.SYSTSGRS.I0001.A001') | | | IF LASTCC = 0 THEN - | | | DELETE - | | | (DSNC!!0.DSNDBC.DSNDB06.SYSTSGRS.I0001.A001) - | | | CATALOG(DSNC!!0) | | | ELSE | | | SET MAXCC = 0 | | | | | | where DSNDB06.SYSTSGRO and DSNDB06.SYSTSGRS are | | | the new UTS table spaces replacing the non-UTS | | | table space DSNDB06.SYSGRTNS. | | | | |--------|--------------------------------------------------| |DSNTIJIC| Job step ICDUTILX (Disk image copy step for | | | ----------------- SYSUTILX table space) | | | | | | Changed to use LISTDEF INCLUDE TABLESPACES TABLE | | | to copy each table in DSNDB01.SYSUTILX. | | | | | | Job step ICDMAIN (Disk image copy step for Db2 | | | ---------------- catalog and directory objects) | | | | | | Each non-UTS table space, which is listed in | | | column 1 of Table 2 and Table 3 and also | | | specified in the LISTDEF list TSP_LIST, is now | | | copied using LISTDEF INCLUDE TABLESPACES TABLE | | | with the tables that reside in the non-UTS | | | table space. | | | | | | For example, consider the following INCLUDE | | | TABLESPACE statement for a non-UTS table space: | | | | | | INCLUDE TABLESPACE DSNDB06.SYSGRTNS | | | | | | This example statement is replaced with the | | | following INCLUDE TABLESPACES TABLE statements | | | with specific tables: | | | | | | INCLUDE TABLESPACES TABLE | | | SYSIBM.SYSROUTINES_OPTS | | | INCLUDE TABLESPACES TABLE | | | SYSIBM.SYSROUTINES_SRC | | | | | | where SYSIBM.SYSROUTINES_OPTS and | | | SYSIBM.SYSROUTINES_SRC are tables in | | | the non-UTS table space DSNDB06.SYSGRTNS. | | | | | | Job steps IC* for TAPE image copies | | | ----------------------------------- | | | | | | For every non-UTS table space listed in column 1 | | | of Table 4, a new doubly commented COPY step is | | | added for every UTS table space replacing it. | | | The new UTS table space COPY steps are listed in | | | column 4 of Table 4 and they are added after the | | | COPY step of the non-UTS table space they are | | | replacing. | +--------|--------------------------------------------------+ Table 2. Db2 Catalog Objects +-----------------------------------------------------+ | Non-UTS | UTS | Table | Db2- | | Table | Table | (SYSIBM.tbname) | Defined | | Space | Space | | Index | |(DSNDB06. |(DSNDB06. | | (SYSIBM. | | tsname) | tsnameU) | | ixname) | +----------|----------|--------------------|----------+ | SYSALTER | SYSTSOBD | SYSOBDS | DSNDOB01 | | | | | DSNDOB02 | |----------|----------|--------------------|----------| | SYSCONTX | SYSTSCTX | SYSCONTEXT | DSNCTX01 | | | | | DSNCTX02 | | | | | DSNCTX03 | | | | | DSNCTX04 | | | SYSTSCAH | SYSCONTEXTAUTHIDS | DSNCDX01 | | | | | DSNCDX02 | | | SYSTSTRA | SYSCTXTTRUSTATTRS | DSNCAX01 | |----------|----------|--------------------|----------| | SYSDDF | SYSTSIPL | IPLIST | DSNDUX01 | | | SYSTSIPN | IPNAMES | DSNFPX01 | | | SYSTSLOC | LOCATIONS | DSNFCX01 | | | SYSTSLUL | LULIST | DSNFLX01 | | | | | DSNFLX02 | | | SYSTSLUM | LUMODES | DSNFMX01 | | | SYSTSLUN | LUNAMES | DSNFNX01 | | | SYSTSMOD | MODESELECT | DSNFDX01 | | | SYSTSUSN | USERNAMES | DSNFEX01 | |----------|----------|--------------------|----------| | SYSEBCDC | SYSTSDME | SYSDUMMYE | | | | SYSTSDUM | SYSDUMMY1 | | |----------|----------|--------------------|----------| | SYSGPAUT | SYSTSRES | SYSRESAUTH | DSNAGH01 | | | | | DSNAGX01 | |----------|----------|--------------------|----------| | SYSGRTNS | SYSTSGRO | SYSROUTINES_OPTS | DSNROX01 | | | SYSTSGRS | SYSROUTINES_SRC | DSNRSX01 | | | | | DSNRSX02 | |----------|----------|--------------------|----------| | SYSHIST | SYSTSCDH | SYSCOLDIST_HIST | DSNHFX01 | | | SYSTSCLH | SYSCOLUMNS_HIST | DSNHEX01 | | | SYSTSIXH | SYSINDEXES_HIST | DSNHHX01 | | | | | DSNHHX02 | | | SYSTSIPH | SYSINDEXPART_HIST | DSNHGX01 | | | SYSTSINH | SYSINDEXSTATS_HIST | DSNHIX01 | | | SYSTSKTH | SYSKEYTARGETS_HIST | DSNHKX01 | | | SYSTSKDH | SYSKEYTGTDIST_HIST | DSNTDX02 | | | SYSTSLSH | SYSLOBSTATS_HIST | DSNHJX01 | | | SYSTSTPH | SYSTABLEPART_HIST | DSNHCX01 | | | SYSTSTHI | SYSTABLES_HIST | DSNHDX01 | | | SYSTSSTH | SYSTABSTATS_HIST | DSNHBX01 | |----------|----------|--------------------|----------| | SYSJAVA | SYSTSJRC | SYSJARCONTENTS | DSNJCX01 | | | SYSTSJRO | SYSJAROBJECTS | DSNJOX01 | | | SYSTSJVO | SYSJAVAOPTS | DSNJVX01 | | | SYSTSJPH | SYSJAVAPATHS | DSNJPX01 | | | | | DSNJPX02 | |----------|----------|--------------------|----------| | SYSROLES | SYSTSRDP | SYSOBJROLEDEP | DSNRDX01 | | | | | DSNRDX02 | | | SYSTSROL | SYSROLES | DSNRLX01 | |----------|----------|--------------------|----------| | SYSSEQ | SYSTSSEQ | SYSSEQUENCES | DSNSQX01 | | | | | DSNSQX02 | | | | | DSNSQX03 | |----------|----------|--------------------|----------| | SYSSEQ2 | SYSTSSQA | SYSSEQUENCEAUTH | DSNWCX01 | | | | | DSNWCX02 | | | | | DSNWCX03 | | | SYSTSSQD | SYSSEQUENCESDEP | DSNSRX01 | | | | | DSNSRX02 | |----------|----------|--------------------|----------| | SYSSTATS | SYSTSDIS | SYSCOLDIST | DSNTNX01 | | | SYSTSDST | SYSCOLDISTSTATS | DSNTPX01 | | | SYSTSCST | SYSCOLSTATS | DSNTCX01 | | | SYSTSXST | SYSINDEXSTATS | DSNTXX01 | | | SYSTSKTS | SYSKEYTARGETSTATS | DSNTKX01 | | | SYSTSKTD | SYSKEYTGTDIST | DSNTDX01 | | | SYSTSKDS | SYSKEYTGTDISTSTATS | DSNTSX01 | | | SYSTSLOB | SYSLOBSTATS | DSNLNX01 | | | SYSTSTST | SYSTABSTATS | DSNTTX01 | | | | | DSNTTX02 | |----------|----------|--------------------|----------| | SYSTARG | SYSTSKYT | SYSKEYTARGETS | DSNRKX01 | | | | | DSNRKX02 | |----------|----------|--------------------|----------| | SYSUSER | SYSTSUSR | SYSUSERAUTH | DSNAUH01 | | | | | DSNAUX02 | |----------|----------|--------------------|----------| | SYSXML | SYSTSXRL | SYSXMLRELS | DSNXRX01 | | | | | DSNXRX02 | | | SYSTSXSG | SYSXMLSTRINGS | DSNXSX01 | | | | | DSNXSX02 | +-----------------------------------------------------+ Table 3. Db2 Directory Objects +------------------------------------------+ | Non-UTS | UTS | Table | | Table | Table | (SYSIBM.tbname) | | Space | Space | | |(DSNDB01. |(DSNDB01. | | | tsname) | tsnameU) | | +----------|----------|--------------------+ | SYSUTILX | SYSTSUTM | SYSUTIL | | | SYSTSUTX | SYSUTILX | |----------|----------|--------------------| | SCT02 | SYSTSSCT | SYSIBM.SCTR | +------------------------------------------+ Table 4. UTS Table Space Tape COPY +-----------------------------------------+ | Non-UTS | Replacement UTS | | Table Space | Table Space | |--------------------|--------------------| | Name | COPY | Name | COPY | | | Step | | Step | |----------|---------|----------|---------| | SYSUTILX | ICUTILX | SYSTSUTM | ICTSUTM | | | | SYSTSUTX | ICTSUTX | |----------|---------|----------|---------| | SCT02 | ICSCT02 | SYSTSSCT | ICTSSCT | |----------|---------|----------|---------| | SYSGPAUT | ICGPAUT | SYSTSRES | ICTSRES | |----------|---------|----------|---------| | SYSUSER | ICUSER | SYSTSUSR | ICTSUSR | |----------|---------|----------|---------| | SYSSTATS | ICSTATS | SYSTSDIS | ICTSDIS | | | | SYSTSDST | ICTSDST | | | | SYSTSCST | ICTSCST | | | | SYSTSXST | ICTSXST | | | | SYSTSKTS | ICTSKTS | | | | SYSTSKTD | ICTSKTD | | | | SYSTSKDS | ICTSKDS | | | | SYSTSLOB | ICTSLOB | | | | SYSTSTST | ICTSTST | |----------|---------|----------|---------| | SYSDDF | ICDDF | SYSTSIPL | ICTSIPL | | | | SYSTSIPN | ICTSIPN | | | | SYSTSLOC | ICTSLOC | | | | SYSTSLUL | ICTSLUL | | | | SYSTSLUM | ICTSLUM | | | | SYSTSLUN | ICTSLUN | | | | SYSTSMOD | ICTSMOD | | | | SYSTSUSN | ICTSUSN | |----------|---------|----------|---------| | SYSSEQ | ICSEQ | SYSTSSEQ | ICTSSEQ | |----------|---------|----------|---------| | SYSSEQ2 | ICSEQ2 | SYSTSSQA | ICTSSQA | | | | SYSTSSQD | ICTSSQD | |----------|---------|----------|---------| | SYSHIST | ICHIST | SYSTSCDH | ICTSCDH | | | | SYSTSCLH | ICTSCLH | | | | SYSTSIXH | ICTSIXH | | | | SYSTSIPH | ICTSIPH | | | | SYSTSINH | ICTSINH | | | | SYSTSKTH | ICTSKTH | | | | SYSTSKDH | ICTSKDH | | | | SYSTSLSH | ICTSLSH | | | | SYSTSTPH | ICTSTPH | | | | SYSTSTHI | ICTSTHI | | | | SYSTSSTH | ICTSSTH | |----------|---------|----------|---------| | SYSGRTNS | ICGRTNS | SYSTSGRO | ICTSGRO | | | | SYSTSGRS | ICTSGRS | |----------|---------|----------|---------| | SYSJAVA | ICJAVA | SYSTSJRC | ICTSJRC | | | | SYSTSJRO | ICTSJRO | | | | SYSTSJVO | ICTSJVO | | | | SYSTSJPH | ICTSJPH | |----------|---------|----------|---------| | SYSALTER | ICALTER | SYSTSOBD | ICTSOBD | |----------|---------|----------|---------| | SYSEBCDC | ICEBCDC | SYSTSDME | ICTSDME | | | | SYSTSDUM | ICTSDUM | |----------|---------|----------|---------| | SYSXML | ICXML | SYSTSXRL | ICTSXRL | | | | SYSTSXSG | ICTSXSG | |----------|---------|----------|---------| | SYSTARG | ICTARG | SYSTSKYT | ICTSKYT | |----------|---------|----------|---------| | SYSROLES | ICROLES | SYSTSRDP | ICTSRDP | | | | SYSTSROL | ICTSROL | |----------|---------|----------|---------| | SYSCONTX | ICCONTX | SYSTSCTX | ICTSCTX | | | | SYSTSCAH | ICTSCAH | | | | SYSTSTRA | ICTSTRA | +-----------------------------------------+
APAR Information
APAR number
PH66270
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
D10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function / Xsystem
Submitted date
2025-04-23
Closed date
2025-06-23
Last modified date
2025-07-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UO03754
Modules/Macros
DSNDQW04 DSNTIJCX DSNTIJDE DSNTIJIC DSNTINM1 DSNTINS1 DSNUGDDA DSNUGDDE DSNUGMAP DSNUGUCA DSNUGUTC DSNUILDR DSNUILSA
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RD10 PSY UO03754
UP25/07/01 P F506
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":"BU048","label":"IBM Software"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Document Information
Modified date:
02 July 2025