How to use RTC the repository unload job(BLZDB2UN) ?
Hello. Help me!
Now I'm trying to unload RTC repository data using the unload job(BLZDB2UN) provided by V3.0.1. How can I specify volume name in the placeholder "@space@" ? Thanks in advance, |
3 answers
This job is designed to use storage volume or SMS datasets.
If you want to use non SMS datasets you'll have to do some changes. 1) Make a backup copy of BLZDB2UN as BLZDB2U1 Edit BLZDB2U1 In step BLZUNLD Replace DSN=&&LOADSTM1,DISP=(NEW,PASS), by DSN=yourhlq.LOADSTM1,DISP=(,CATLG), Replace DSN=&&LOADSTM2,DISP=(NEW,PASS), by DSN=yourhlq.LOADSTM2,DISP=(,CATLG), Remove the steps LISTUN1 LISTUN2 UNLDTS UNLDBTS (it will remain only the steps BLZUNLD and MKDIR) Run the job. 2 ) Edit yourhlq.LOADSTM1 Add the parameter VOLUMES(volxxx,volyyy) after the DSN(....) parameter for the templates T1 and P1 Do the same thing fo yourhlq.LOADSTM2 3) Create a new JCL member with //BLZDB2UN JOB //DB2LIB SET DB2LIB=@db2Hlq@.SDSNLOAD //* Unload the non LOB tables //* //UNLDTS EXEC DSNUPROC,SYSTEM=@db2sys@,LIB=&DB2LIB //SYSIN DD DSN=yourhlq.LOADSTM1,DISP=SHR //* //* Unload the LOB tables //* //IF03 IF RC=0 THEN //UNLDBTS EXEC DSNUPROC,SYSTEM=@db2sys@,LIB=&DB2LIB //SYSIN DD DSN=yourhlq.LOADSTM2,DISP=SHR // ENDIF Do the @db2sys@ @db2Hlq@ changes and run the job. Hope this will help |
|
Jean
Thanks for your information! I was able to unload the data into my volume. Next, I'll try to load the data into another RTC repository... This job is designed to use storage volume or SMS datasets. |
|
Hello.
Now, I'm facing next issue in load process(BLZDB2LD). The following is the part of joblog, and the step 'UPDATE' never ends. Any advice ? Thanks in advance, --------------------------------------- SDSF BROWSE BLZDBLDJ (JOB00435) SYSPRINT Line 00000000 Col 001 080 Command ===> Scroll ===> CSR ********************************* Top of Data ********************************** 1*** BLZSCHM - START OF PROGRAM - 11/10/26 *** DB2PRE : JTS *** NEWPRE : JTS ******************************** Bottom of Data ******************************** Jean This job is designed to use storage volume or SMS datasets. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.