Moving a CA Dataquery JCL member to another MUF

book

Article ID: 129630

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware

Issue/Introduction

When users create special JCL in CA Dataquery - whether as a PROC type or any other JCL type, there is a particular process to follow because of the way this JCL member is defined internally. In essence, it is required to take a backup of a collection of members (in which the desired member is found), and then using a selective restore to only load the desired member into the new system.

Environment

Release: DBCISF00200-15.1-Datacom-Database-Option for CICS Services
Component:

Resolution

As mentioned earlier, it is not possible at present to select only a single JCL-type member by name for a backup process, and therefore, you should backup all members of a particular Group, or just backup all groups. Here is a sample jobstep to do this:
//*                                                   
//JCL JCLLIB ORDER=(Your-CA-Datacom.CUSPROC)
//*                                                   
//DQLIBMT   EXEC PGM=DQLIBRMT,REGION=0M     
//          INCLUDE MEMBER=B15STLIB 
//          INCLUDE MEMBER=B15DDOUT 
//DQBKPFIL DD DISP=(,CATLG,DELETE),DSN=Your-BACKUP-File-Name,​​​​
//             UNIT=3390,MGMTCLAS=TSO,STORCLAS=TSO, 
//             SPACE=(CYL,(10,1),RLSE)              
//SYSIN    DD   *                           
SIGN/ON DATACOM-INSTALL PASSWORD NEWUSER    
REPORT....TITLE=DIRECTORY           (NB: Replace periods with spaces)
BACKUP....GROUPS=ALL                (NB: Replace periods with spaces) 
/*                                          

Then, on the target system, to restore the single member, you would use something like this jobstep. Be sure to replace uuuuuuuuuu with the CA Dataquery user that is the owner of the member, and mmmmmmmmmm with the actual member name to be loaded:
//*                                                   
//JCL JCLLIB ORDER=(Your-CA-Datacom.CUSPROC)
//*                                                   
//DQLIBMT   EXEC PGM=DQLIBRMT,REGION=0M     
//          INCLUDE MEMBER=B15STLIB 
//          INCLUDE MEMBER=B15DDOUT 
//DQBKPFIL DD DISP=SHR,DSN=Your-BACKUP-File-Name​​​​            
//SYSIN    DD   *                           
SIGN/ON DATACOM-INSTALL PASSWORD NEWUSER    
RESTORE...NAME=uuuuuuuuuu,MEMBER=mmmmmmmmmm (NB: Replace periods with spaces)
REPORT....TITLE=DIRECTORY                    (NB: Replace periods with spaces)
/*

After the Restore has completed, be sure to review the DIRECTORY Report to see that your member is now there.

Additional Information

For more information about the DQLIBRMT utility, please refer to the following documentation.

Version 15.1: Administrating > Administrating CA Dataquery  > Managing Your Query LIbriary Table, in the section Performing Query Table Maintenance (DQLIBRMT)
Version 15.0: Administrating > Administrating CA Dataquery  > Managing Your Query LIbriary Table, in the section Performing Query Table Maintenance (DQLIBRMT)

As always, please contact CA Technologies support for CA Datacom if you have further questions.