2501496 - DB2 z/OS: SQLCODE = -747 during export of the system copy

Symptom

You perform system copy using SWPM. During the export, R2szchk fails with the following error:

ERROR: Select for get_avg_bloblen failed
       (DBSL rc = 99)

[IBM][CLI Driver][DB2] DSNT408I SQLCODE = -747, ERROR: TABLE <tabname> IS NOT AVAILABLE UNTIL THE AUXILIARY TABLES AND INDEXES
         FOR ITS EXTERNALLY STORED COLUMNS HAVE BEEN CREATED
DSNT418I SQLSTATE   = 57054 SQLSTATE RETURN CODE
DSNT415I SQLERRP    = DSNXOTL SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD    = -550 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD    = X'FFFFFDDA' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC
         INFORMATION
~

ERROR: add_fld: get_avg_bloblen failed for table <tabname>

Environment

SAP on IBM Db2 for z/OS

Keywords

-747, SQLCODE = -747, auxiliary, export, LOB , KBA , BC-DB-DB2-INS , DB2 for z/OS - Installation , BC-DB-DB2 , DB2 for z/OS , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.