IDB2 EXTRACT AND TABLE LOAD ERRORS

Products

• SYSVIEW Performance Management Option for DB2 for z/OS
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

Just upgraded to db2 v12 last  night, now the  load job fails with these messages on extract step, which did not occur for other SSID on r19.

DBG70010E      10:28:34         1 ERRORS CONVERTING VALUES FOR OUTPUT FILE ARCIACDP
DBG70010E      10:28:34         1 ERRORS CONVERTING VALUES FOR OUTPUT FILE ARCIACSP

This extract error causes table load error:

DSNU338I  #D2P3 162 08:07:11.68 DSNURWBF - INVALID COLUMN SPECIFICATION FOR PKG_COLLECTION
DSNU302I  #D2P3 162 08:07:11.68 DSNURWBF - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=6848
                                                                                
                                                                                
DSNU017I    162 08:07:11.69 DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E40347' 
CAUSE=X'00E40323'  


 

Environment

Release : 19.0

Component : CA Insight Database Performance Monitor for DB for z/OS

Resolution

The problem was caused by pointing to r15 library which didnt work after the db2 v12 upgrade. Changing IDB2ARC to call in r19 NSIGHTRW resolved the problem.