ssidSTAT Determine Db2 Object Sizes task failed DSNT500I 00C90094

Products

• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

The ssidSTAT post installation task fails with the following error when executing RUNSTATS.

DSNT500I    269 03:07:58.98 DSNUGBAC - RESOURCE UNAVAILABLE 
                      REASON 00C90094                       
                      TYPE 00000201                         
                      NAME PTDB    .index-space-name

 

Cause

Reason code 00C90094

Explanation                                                                
A data set is in a different state than Db2 expects, which might occur as a
result of the following situations:                                        
                                                                           
   o A data set was deleted and redefined, but Db2 does not recognize the  
     redefined data set.                                                   
   o A previous Db2 failure damaged the data set in some way.              

Resolution

Use the following query to identify which Index this error relates to:

SELECT  NAME FROM SYSIBM.SYSINDEXES
WHERE CREATOR = 'PTI' AND INDEXSPACE = 'index-space-name'  

Once you have identified the name of the problem Index, Rebuild the Index and then rerun the ssidSTAT job.