Review the list of plans and packages generated by job ssid0004

Products

• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

When you work with option 'INS     Free Obsolete Packages and Plans (Optional)' in Post-Install Tasks, there is no way to review the list of plans and packages generated in the ssid0004 JCL that will be free when the ssid0004 job is run. 
 
The only way to review the list of plans and packages generated in the ssid0004 JCL is after the ssid0004 job has been run. 

Resolution

After the ssid0004 JCL was generated review the JCL and immediately delete the //FREEPKG1 step so plans and packages are not mistakenly freed prior to review. Delete starting from the following to the end of the ssid0004 JCL: 

//*----------------------------------------------------------------- 
//* PERFORM THE FREE PACKAGE/PLAN STATEMENTS                         
//*----------------------------------------------------------------- 

Then edit the //STRPQR1 step and modify the //OUTDD to an actual data set that can be reviewed as in the following example modifying the HLQ prefix:

 

//OUTDD    DD  DISP=(,CATLG),DSN=HLQ.FREEPKGS,             
//             UNIT=SYSDA,SPACE=(3200,(1000,500),RLSE),        
//             DCB=(RECFM=FB,LRECL=80)             

   
If you are satisfied with the results, then generate again the ssid0004 JCL and run the ssid0004 job without any update.