Deliver report definition cleanup

book

Article ID: 220722

calendar_today

Updated On:

Products

CA Deliver

Issue/Introduction

We are cleaning up the Deliver database and would like to delete all report definitions that are not run anymore.

We've used REXX, RMOGRW, and SARGRW, to create a mass spreadsheet that narrows down what needs to be deleted, but is there a way to back up these definitions or the database before deletion?

Environment

Release : 14.0

Component : CA View

Resolution

It is recommended to back up the entire Deliver database, before making any kind of mass changes. 

This would be accomplished by running RMODBASE UNLOAD:

//XXXXXXXX JOB ...                                               
//RMODBASE EXEC PGM=RMODBASE,PARM='DLVR_HLQ'  <=== MODIFY DB NAME
//STEPLIB  DD  DISP=SHR,DSN=DLVR.CVDELOAD     <=== MODIFY, IF USE
//SYSPRINT DD  SYSOUT=*                                          
//RMOUNLD  DD  DSN=XXXXXX.XXXXXX.RMOUNLD,                        
//             DISP=(,CATLG,DELETE),                             
//             UNIT=XXXX,VOL=SER=YYYYYY,                         
//             SPACE=(CYL,(NNN,NN),RLSE)                         
//SYSIN    DD   *                                                
UNLOAD HISTDELALL                                                
/*                                                               
//                                                               

The above will put the database to a flat file, which could then be loaded to a new database (using RMODBASE LOAD, under a different name), whereas then the Deliver RMOUTIL utility could be used, to copy definitions from one database to another.