Post Install ssid0001 Create job failing with DSNU2902I message due to invalid mapping database during reorg
search cancel

Post Install ssid0001 Create job failing with DSNU2902I message due to invalid mapping database during reorg

book

Article ID: 262212

calendar_today

Updated On:

Products

DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS Database Management for DB2 for z/OS - Administration Suite Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - Recovery Suite Database Management for DB2 for z/OS - SQL Performance Suite Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

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     

Resolution

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.        

Additional Information

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.