PRFWY* Packages using the QMF Database DSQDBCTL
search cancel

PRFWY* Packages using the QMF Database DSQDBCTL

book

Article ID: 276233

calendar_today

Updated On:

Products

Report Facility for TSO

Issue/Introduction

Decommissioning an old database DSQDBCTL which seems to belong to QMF. Stopped the database to ensure it's not being used by anything.

While applying the latest ptfs for PRF(Report Facility) and running the bind jobs,the binds for some packages are failing because they are dependent on this database.

For Example

DSNT500I  _DBD1 DSNXOTL RESOURCE UNAVAILABLE                         
           REASON 00C90081                                           
           TYPE 00000100                                             
           NAME DSQDBCTL                                             
DSNT233I  _DBD1 UNSUCCESSFUL BIND FOR                                
           PACKAGE =                                                 
XXX.PRFQPLAN_ALL.PRFWYDR.(CAD200_2018-03-29-10.32.30)    

Resolution

Once the database DSQDBCTL is actually dropped from the DB2 Subsystem then this will problem will no longer be an issue.