Error doing Database Management binds after applying latest maintenance ISPF103 no imbed file PPA@DB2O
search cancel

Error doing Database Management binds after applying latest maintenance ISPF103 no imbed file PPA@DB2O

book

Article ID: 204858

calendar_today

Updated On:

Products

Plan 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

Issue/Introduction

After applying the latest maintenance to our Database Management for Db2 for z/OS tools, the Post Install implementation step
rebinding all plans and packages (option 0). fails with the following error:

INSFTBND is generating local bind commands SETUP00 using PLANS00:
                                                                               
                                                                               
**** ERROR in bind command tailoring                                           
zerrmsg= ISPF103                                                               
zerrsm= No imbed file                                                          
zerrlm= Imbed file 'PPA@DB2O' does not exist, ANLPACK record-39                
zerrhm=                                                                        
zerralrm= YES                            
                                     

It appears that SO15690 may be the problem. It updated the skeleton ANLPACK adding the )IM PPA@DB2O statement.
However no PPA@DB2O skeleton was created by the PTF. It did create a PPA@DB2O load module, but of course
that cannot be imbedded with file tailoring. Is the skeleton PPA@DB2O missing from the PTF?

Resolution

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

BIND PACKAGE ( &ANLPLN01._ANL )
MEMBER ( PPA@DB2O )
)IM BOPTS02K
)IM BOPTODRB
)IM BOWNER
)IM BREPLACE