What kind of documentation should I collect for IBM to do diagnosis when migration fails?

Answer

The documentation required is different for different type of problems.

In order for IBM to diagnose the Db2 migration failures, the following basic docs should be collected and sent to IBM for investigation:

• Any dump produced
• Joblog of migration job
• Db2 MSTR joblog
• The output of DB2 command -DISPLAY GROUP DETAIL
• DSN1PRNT output of DSNDB01 header page with he following sampleJCL, to confirm catalog level:

//JOBLIB  DD DSN=DB2-loadlib.data set name,DISP=SHR            
//DSNTIN   EXEC PGM=DSN1PRNT,PARM='PRINT(0),FORMAT'                
//SYSPRINT DD  SYSOUT=*                                            
//SYSUT1   DD  DSN=xxxxxxx.DSNDBC.DSNDB01.DBD01.I0001.A001,DISP=SHR
//SYSUT2   DD  DUMMY                                              

//S1       EXEC PGM=IDCAMS                                      
//SYSPRINT DD  SYSOUT=*                                          
//SYSUDUMP DD  SYSOUT=*                                          
//OUTDD    DD  DSN=DSNC000.BSDS03.SEQCOPY,              <- change
//             DISP=(NEW,CATLG),UNIT=SYSDA,                      
//             DCB=(LRECL=8185,BLKSIZE=24576,RECFM=VB),          
//             SPACE=(CYL,(8,2),RLSE)                            
//SYSIN    DD  *                                                
       REPRO -                                                  
            INDATASET(DSNC000.BSDS03) -                 <- change
            OUTFILE(OUTDD)                                      
 /*                                              

//STEP1   EXEC PGM=DSNJU999,PARM='DUMP SCA grpname'  
//STEPLIB  DD DSN=DSNB10.SDSNEXIT,DISP=SHR          
//         DD DSN=DSNB10.SDSNLOAD,DISP=SHR          
//SYSUDUMP DD SYSOUT=*                              
//SYSPRINT DD SYSOUT=*            

grpname is the group name used at your site. You must first link edit DSNJU999 as APF-authorized using the sample in DSNB10.SDSNAMP(DSNTIDSA).

The link-edited output goes to SDSNEXIT data set.