Binds for few packages are failing with PLAN=(NOT APPLICABLE) DBRM=UTAGLSR8

Products

• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

Binds for some packages are failing after performing latest maintenance for CA DBMS R20.

Bind job is failing with PLAN=(NOT APPLICABLE) DBRM=UTAGLSR8 STATEMENT=5634 SYSIBM.TABLESPACESTATS IS NOT DEFINED.

Cause

From the Bind job Error message

    BIND PLAN (IDBSPLAN)                             PKLIST(                  
      )       VALIDATE   ( RUN     )       ISOLATION  ( CS      )       ACQUIRE
LEASE    ( COMMIT  )       DBPROTOCOL ( DRDA    )       EXPLAIN    ( NO      ) 
                OWNER(XXX1INST)       RETAIN;                                  
DSNT500I  - XXX1 DSNTBCM1 RESOURCE UNAVAILABLE                                  
           REASON 00E30083                                                     
           TYPE 00000800                                                       
           NAME IDBSPLAN                                                       
DSNT201I  - XXX1  BIND FOR PLAN IDBSPLAN NOT SUCCESSFUL      

The Sysview for Db2 Data Collector is active while the Bind Job is running.

Resolution

Stop the Sysview for DB2 Data Collector 

Run the Bind Job

Restart the Sysview for DB2 Data Collector