Moving Dataquery JCL members to another MUF

Products

• Datacom
• Datacom/DB

Issue/Introduction

When users create special JCL in Dataquery–whether a PROC 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 use a selective restore to only load the desired member into the new system.

Environment

Release : All

Component : Datacom/DB

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 backup all groups. Here is a sample jobstep to do this:

//*                                                   
//JCL      JCLLIB ORDER=(Your-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, to restore the single member on the target system, you would use something like this jobstep. Be sure to replace uuuuuuuuuu with the Dataquery user that is the owner of the member, and mmmmmmmmmm with the actual member name to be loaded:

//*                                                   
//JCL      JCLLIB ORDER=(Your-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 managing your Dataquery library members, please refer to the documentation for "Performing Query Table Maintenance (DQLIBRMT)." 

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

***