CA View - Transfer a Database to Another z/OS Logical Partition (LPAR)

Products

• OM Deliver
• OM View

Issue/Introduction

The client provided their plan for transferring a View database from one LPAR to another.  
Note: The plan is specific to their source databases, their interim resources, and their goals. 
 

Environment

CA View - All Releases

Resolution

The client wants to follow this plan:

1. At the original site:
  
- Stop any CA Deliver RMOSTC tasks that write to the database   

- In the SARSTC task, issue “/f sartsc,NEW”, to run a View backup  

- List the tape data sets of the view DB:  

//SARPAC01   EXEC PGM=SARPAC,PARM='view_hlq,REPORT'  
//STEPLIB      DD DISP=SHR,DSN=VIEW.CVDELOAD         
//SYSPRINT   DD SYSOUT=*                                     
//SYSUDUMP   DD SYSOUT=*                                     
//SYSIN        DD DUMMY
//  

- Define the “volser”s listed in the VTS (of the original site) to the target site
- Define entries “sartape dsn/volser” in the catalog of the target site
   
2. At the target site:

- Define the “volser”s listed in the VTS (actions specific to the robotic VTS)
- Define entries “sartape dsn/volser”  (AMS/DEFINE)

3. At the target site, allocate a new VIEW database (with same name as the old one)

//CREATE     EXEC PGM=SARDBASE                           
//STEPLIB    DD  DISP=SHR,DSN=VIEW.CVDELOAD  
//SYSPRINT DD  SYSOUT=*                                
//SYSIN      DD  *                                       
NAME view_hlq
ADDDS CYL=3000  BLKSIZE=8906 INDEX VOLSER= . . .        
ADDDS CYL=1000  BLKSIZE=13862 DATA  VOLSER= . . .                                                         
//     
                                                
4. At the target site, RESTORE the index of the old view DB to the DB newly allocated,
   and run SARDBASE OLOAD and BLOAD to load the panels and banners, respectively:

//RESTORE EXEC PGM=SARDBASE                          
//STEPLIB    DD  DISP=SHR,DSN=VIEW.CVDELOAD
//SYSPRINT DD  SYSOUT=*                               
//SARRECV  DD  DISP=SHR,DSN=view_hlq.RECV (view_hlq  DB name)     
//SARTAPE DD DISP=SHR,…  archival tape containing the backup of the master index.  
//SYSIN      DD  *                                      
NAME view_hlq                                 
RESTORE                                               
//


//OLOAD    EXEC PGM=SARDBASE                         
//STEPLIB  DD DSN=VIEW.CVDELOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*                               
//SAROLIB  DD DSN=VIEW.CVDEPENU,DISP=SHR
//SYSIN    DD *                                      
NAME view_hlq                                
OLOAD                                                                                                  
// 
                                                  
//BLOAD    EXEC PGM=SARDBASE                          
//STEPLIB  DD DSN=VIEW.CVDELOAD,DISP=SHR  
//SYSPRINT DD SYSOUT=*                                
//SARBLIB  DD DSN=VIEW.CVDEDATA,DISP=SHR  
//SYSIN    DD *                                       
NAME view_hlq                                 
BLOAD                                                                                            
//  
                                                  
5. At the target site, create new KA partition tapes:

- Run SARPAC REPORT, to see the list of tapes:

//SARPAC01 EXEC PGM=SARPAC,PARM='view_hlq,REPORT'   <=== Modify DB name
//STEPLIB  DD DISP=SHR,DSN=VIEW.CVDELOAD     
//SYSPRINT DD SYSOUT=*                                     
//SYSUDUMP DD SYSOUT=*                                     
//SYSIN    DD DUMMY
//   
  
- Run SARPAC, to move reports to new tapes:

//SARPAC02 EXEC PGM=SARPAC,PARM='view_hlq'   <=== Modify DB name
//STEPLIB  DD DISP=SHR,DSN=VIEW.CVDELOAD     
//SYSPRINT DD SYSOUT=*                                     
//SYSUDUMP DD SYSOUT=*                                     
//SYSIN    DD *
TAPESEQ=mmmmm‐nnnnn
/*
//   

6. At the target site, release old tapes with starting the SARSTC task and issuing "/f sartsc,NEW”, to run a View backup. 

Note: Due to the special circumstances of what they were moving, the above plan would work only specifically to that set of conditions.