SSID1326; Load Automapping Mask table job receives a -904 on the dataset

Products

• RC/Migrator for DB2 for z/OS

Issue/Introduction

 The 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 DB0T.DSNDBC.DB2TOOLS.PTMG1ZY7.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                                      

How can this be resolved?

Environment

Release : 20.0

Component : DB2 Common Components

Resolution

For some reason the index objects had disappeared from the 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: PTMG1ZY7.  The Index space name would vary by subsystem.

   T: PTMG9_MASK_0510

   I:  PTMG9_MASK_0510IX1
       PTMG9_MASK_0510IX2