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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.