CA DB2 tools Error doing product binds after applying latest maintenance Imbed file PPA@DB2O
search cancel

CA DB2 tools Error doing product binds after applying latest maintenance Imbed file [email protected]

book

Article ID: 204858

calendar_today

Updated On:

Products

Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - SQL Performance Suite Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

After applying the latest maintenance to our CA tools for Db2, the post implementation step of rebinding all plans and packages (option 0). fails with the following error:

INSFTBND is generating local bind commands for DB00 from SETUP00 using PLANS00 
                                                                               
                                                                               
**** ERROR in bind command tailoring                                           
zerrmsg= ISPF103                                                               
zerrsm= No imbed file                                                          
zerrlm= Imbed file '[email protected]' does not exist, ANLPACK record-39                
zerrhm=                                                                        
zerralrm= YES                                                                  

It looks like SO15690 might be the culprit. It updated the skeleton ANLPACK adding the )IM [email protected] statement. However no [email protected] skeleton was created by the PFT. It did create a [email protected] load module, but of course that cannot be imbedded with file tailoring. Is the skeleton [email protected] missing from the PTF?

 

Environment

Release : 20.0

Component : CA Plan Analyzer for DB2 for z/OS

Resolution

Permanent fix is now available. In the mean time, the problem can be resolved by creating the missing member in the ISPSLIB dataset OIRSYS.INSIGHT.V200.CDBASKL0 with these cards. 

BIND PACKAGE ( &ANLPLN01._ANL )
MEMBER ( [email protected] )
)IM BOPTS02K
)IM BOPTODRB
)IM BOWNER
)IM BREPLACE