Database Management for Db2 for z/OS Post Install job ssid0001 Create objects failing with the following:
DSNU2902I =xxx- 070 22:18:05.53 DSNURMAP - MAPPING DATABASE xxxxxxxx IS INVALID
DSNU012I 070 22:18:05.53 DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST
RETURN CODE=8
During the generation of the REORG syntax the Post Install ssid0000 Compare process does not generate the MAPPINGDATABASE keyword within the REORG syntax:
Per the DSNU2902I message it states:
DSNU2902I csect-name MAPPING DATABASE database-name IS INVALID
Explanation
The REORG utility statement has detected that the database that is specified for the REORG TABLESPACE utility MAPPINGDATABASE keyword or the REORG_MAPPING_DATABASE subsystem parameter does not exist or cannot be used to implicitly create a mapping table.
Specify a valid database name for the REORG TABLESPACE utility MAPPINGDATABASE keyword or specify a valid value for the REORG_MAPPING_DATABASE subsystem parameter.
As the MAPPINGDATABASE syntax is not specified in the reorg syntax it is taking the default name from Db2 DSNZPARM REORG_MAPPING_DATABASE parameter.
Details from the Db2 11 Technical Overview:
Following are the rules on creating mapping tables:
- If the mapping table is specified and it is in correct format, then honor the specification.
- Else if specified but in the incorrect format, then create a new mapping table in the same database as the original mapping table.
- Else if the mapping table is not specified and the DSNZPARM REORG_MAPPING_DATABASE value is specified, then create in the DSNZPARM database. The REORG utility fails with RC8 and a DSNU2902I message occurs, if the specified database name in the keyword or zParm is not found.
- Else create in the implicit database.
DROP at end of REORG or end of last REORG, if there are multiple REORGs in the job step.
The MAPPINGDATABASE option specifies the database in which REORG implicitly creates the mapping table and index objects. This keyword overrides the subsystem parameter value in REORG_MAPPING_DATABASE. The value cannot be DSNDB01, DSNDB06, or DSNDB07, implicit database, a work file or temporary database.