2501496 - DB2 z/OS: SQLCODE = -747 during export of the system copy | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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>




Read more...

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 ONE Support launchpad (Login required).

Search for additional results

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