RETIX RC 72 (2) LINK 69 (71) DFDSS area copy from another MUF
search cancel

RETIX RC 72 (2) LINK 69 (71) DFDSS area copy from another MUF

book

Article ID: 131628

calendar_today

Updated On:

Products

Datacom DATACOM - AD Datacom/AD Datacom/DB

Issue/Introduction

Copying a Datacom database area from another MUF using DFDSS.

Run DBUTLTY INIT of the IXX.
Then trying to RETIX the data area gets error:

DB02406I - PXX END - DATA CONTROL BLOCK AND CXX NAME DO NOT MATCH 
DB00501E - OPEN ERROR - RETURN CODE 72 (002) CXX=MUFT (xxxnnnnn)
DB00508E - CXXLINK=MUFP
DB10045E - ABNORMAL TERMINATION DUE TO ERROR(S)

The error indicates the database area is linked to CXX named MUFP but trying to LOAD the area with a CXX named MUFT.

Normally running a DBUTLTY FUNCTION=LINK DBID=nnnnn would resolve this but in this case because the IXX has been initialized the LINK fails with RC 69 (71): 

                                             LINK REPORT

DBID AREA CXXNAME  DSN               ERROR INFORMATION  
 nnn IXX  MUFT     DATACOM.nnnIXX                                                                                             
 nnn xxx           DATACOM.nnnxxx    69 (71) INDEX NOT LOADED FOR TABLE      

 

Environment

Release: 15.1

Resolution

Firstly make sure the correct files are used. Check the dataset names in the LINK REPORT  output of the LINK to make sure the CXX is pointing to the MUFT  copy of the files and not the original MUFP files.

If the MUFT CXX dataset names are pointing to the MUFP files, rename the files in the CXX by running DBUTLTY with:

CXXMAINT OPTION=ALTER,AREA=xxx,DBID=nnn,DSN=newname

If the dataset names are correct in the CXX, then before copying the data area run an INIT on the IXX and the area and then NULL load the area, this will mark the index as loaded.

INIT DBID=nnn,AREA=IXX  
INIT DBID=nnn,AREA=xxx  
LOAD DBID=nnn,AREA=xxx,FORMAT=NONE

Then copy the file and run the LINK before the RETIX. 

The full procedure to copy a data area is documented below.

 

Procedure to copy an area using DFDSS

Perform the following steps to copy an area from another MUF:

  1. Define the area in the target MUF and run an INIT of the IXX and an INIT and NULL load of the area
    INIT DBID=nnn,AREA=IXX  
    INIT DBID=nnn,AREA=xxx  
    LOAD DBID=nnn,AREA=xxx,FORMAT=NONE

  2. Run console command QUIESCE TXN or QUIESCE_DBID on the source MUF

  3. Run DFDSS COPY using ALLD(*) and ALLX or ALLDATA(*) and ALLEXCP to copy the data area from the source MUF

  4. Run console command QUIESCE OFF on the source MUF

  5. Run DBUTLTY LINK on the target MUF:
    LINK DBID=nnn

  6. Run DBUTLTY RETIX on the target MUF:
    RETIX DBID=nnn,SORT=999999999,OPTIMIZE=YES,OPTION1='(I)',SORTWK=30

Additional Information

See documentation sections Creating Copies of Databases and Data Areas, LINK, RETIX, QUIESCE and QUIESCE_DBID