Moving a CA Dataquery JCL member to another MUF

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.