IDB2UNLD job abends with U1963

Products

• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

When running the IDB2 unload job to invoke the IDB2UIFI program the following failure occurs:

 USER COMPLETION CODE=1963 REASON CODE=00000014     

TIME=07.40.14  SEQ=06348  CPU=0000  ASID=012B   

PSW AT TIME OF ERROR  078D1000   9990674C  ILC 2  INTC 0D  

ACTIVE MODULE           ADDRESS=00000000_19900000  OFFSET=0000674C

NAME=IDB2UIFI        

DATA AT PSW  19906746 - 00181610  0A0D1990  59540000   

Cause:

Without an overriding SUFFIX=xx parameter the expected PTSYS00 member was missing from the job's PTIPARM allocation

 

 

Environment

Release : 20.0

Resolution

Specifying the suffix=parameter on the IDB2UIFI parameter string (in this particular case suffix=20) proved corrective .Example

// PARM=('/REQ=UNLDHIST,DBSUB=&DBSUB,DBLOC=&DBLOC,'  ,'REMPOS=&REMEMBER,TESTV=&TESTVER,SUFFIX=20,',

//               'UNLD=&UNLOAD,UNLTYP=&UNLDTYP,UNLCD=&UNLDCHD').