DSNU2907I - Mapping Table Creation Failed during DB2 Tools Post Install Compare (ssid0000)

Products

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

Issue/Introduction

Executing Database Management Solutions Post Install ssid0000 Compare job and the TSREORG
step is failing with the following messages: 

DSNU1033I   150 14:16:14.05 DSNUGULM - PROCESSING LIST ITEM: TABLESPACE PTDB.PTITSBP2 
DSNU233I  +ssid 150 14:16:14.43 DSNURFUI - COMPRESSION DICTIONARY DOES NOT EXIST FOR TABLE SPACE PTDB.PTITSBP2
DSNU1188I   150 14:16:14.72 DSNUGSQL -  SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE
RESOURCE. REASON 00D70025, TYPE OF RESOURCE 00000220, AND RESOURCE NAME vcat.DSNDBC.DSN00nnn.xxxxxxxx.I0001.A001
DSNU1198I   150 14:16:14.72 DSNUGSQL -  SQLSTATE   = 57011 SQLSTATE RETURN CODE 
DSNU1195I   150 14:16:14.72 DSNUGSQL -  SQLERRP    = DSNXICTS SQL PROCEDURE DETECTING ERROR
DSNU1196I   150 14:16:14.72 DSNUGSQL -  SQLERRD    = 105  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION
DSNU1196I   150 14:16:14.72 DSNUGSQL -  SQLERRD    = X'00000069'  X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
DSNU2907I   150 14:16:14.72 DSNURMPC - MAPPING TABLE CREATION FAILED            
DSNU1188I   150 14:16:14.72 DSNUGSQL -  SQLCODE = -204, ERROR:  creator.xxxxxxxx_MAPTABLE_ssid0000.TSREORG_0000 IS AN UNDEFINED NAME
DSNU1198I   150 14:16:14.72 DSNUGSQL -  SQLSTATE   = 42704 SQLSTATE RETURN CODE 
DSNU1195I   150 14:16:14.72 DSNUGSQL -  SQLERRP    = DSNXISB1 SQL PROCEDURE DETECTING ERROR
DSNU1196I   150 14:16:14.72 DSNUGSQL -  SQLERRD    = 355  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION
DSNU1196I   150 14:16:14.72 DSNUGSQL -  SQLERRD    = X'00000163'  X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION 
DSNU2907I   150 14:16:14.72 DSNURMPC - MAPPING INDEX CREATION FAILED            
DSNU012I    150 14:16:14.74 DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8

 

From the Db2 address space:

DSNP009I  +ssid THE FOLLOWING ERROR MESSAGES WERE  923      
RECEIVED FOR DEFINE CLUSTER ON                              
vcat.DSNDBC.DSN00nnn.xxxxxxxx.I0001.A001                    
IGD17802I VOLUMES SPECIFIED BY THE CALLER ARE NOT IN THE SAME
STORAGE GROUP FOR A GUARANTEED SPACE                        
REQUEST, DATA SET IS vcat.DSNDBC.DSN00nnn.xxxxxxxx.I0001.A001
IGD17219I UNABLE TO CONTINUE DEFINE OF DATA SET             
vcat.DSNDBC.DSN00nnn.xxxxxxxx.I0001.A001  

During the TSREORG step the reorg relies on Db2 to create the Mapping Database and Tablespace.
The Mapping DB and TS are implicit objects and use the SYSDEFLT Stogroup.
With an implicit table, the DB and TS are not specified when it is defined.

Resolution

- The SYSDEFLT Storage Group was altered to have '*' for the volume and not actual volume numbers.
  This was the problem.
- In the generated name below, DSN00nnn is a sequential generated TS name.
  DATA SET IS vcat.DSNDBC.DSN00nnn.xxxxxxxx.I0001.A001