Database Management Post Install job ssid1326 Load Automapping Mask table job receives a -904 on the dataset

Products

• 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
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

The Database Management for Db2 for z/OS Post Install job ssid1326 (Load the Automapping Mask Services Table), was regenerated and executed to bring in a new @DEFAULT mask.

The job failed with the following:

DSNT408I SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED BY AN         
         UNAVAILABLE RESOURCE. REASON 00D70024, TYPE OF RESOURCE             
         00000220, AND RESOURCE NAME vcat.DSNDBC.dbname.spacenam.I00-      
         01.A001                                                             
DSNT418I SQLSTATE   = 57011 SQLSTATE RETURN CODE                             
DSNT415I SQLERRP    = DSNXRSDL SQL PROCEDURE DETECTING ERROR                 
DSNT416I SQLERRD    = -190  13172746  0  13820889  -1041948669               
         12714048 SQL DIAGNOSTIC INFORMATION                                 
DSNT416I SQLERRD    = X'FFFFFF42'  X'00C9000A'  X'00000000'                  
         X'00D2E3D9'  X'C1E52003'  X'00C20040' SQL DIAGNOSTIC                
         INFORMATION

Resolution

For some reason the index objects had disappeared from the Db2 ssid.

The Mask table indexes were recreated, and then the job ran successfully.  The dataset referenced the index space name, where the 
last 4 characters are Db2 generated. The index space name would vary by subsystem.