SAP Knowledge Base Article - Preview

3128987 - SQL error "SQL code: -747" when accessing table "<tablename>"

Symptom

Unicode pre-conversion phase reports the following SQL code -747 during the consistency check.  

An ST22 dump may be produced reporting this:
==============================================================
Category                  Installation Errors
Runtime Errors         DBSQL_SQL_ERROR
Except.                    CX_SY_OPEN_SQL_DB
Date and Time         16.11.2021 15:27:59
  
Short Text                                                                                       
    SQL error "SQL code: -747" occurred while accessing table "SCIREST_PS". 
==============================================================

Related developer trace will report this:
==============================================================
 C Tue Nov 16 15:27:58:164 2021
 C  *** ERROR => DB2 Call 'SQLExecute' Error: conHdl = 00 SQLCODE = -747 : [IBM][CLI Driver][DB2] TABLE SAPR3.SCIREST_PS 
    IS NOT AVAILABLE UNTIL THE AUXILIARY TABLES AND INDEXES FOR ITS EXTERNALLY STORED COLUMNS HAVE BEEN CREATED
 C  {root-id=0200000000121EDC91DD2C0C6EAC6D93}_{conn-id=00000000000000000000000000000000}_0
 C  DB2Trc: SELECT "INSPECID" , "INSPECVERS" , "CIUSER" , "OBJTYPE" , "OBJNAME" , "TEST" , "ERRCNT" , "CONSECCNT\
 C  DB2Trc: " , "SOBJNAME" , "SOBJTYPE" , "LINE" , "COL" , "KIND" , "CODE" , "PARAM1" , "PARAM2" , "PARAM3" , "P\
 C  DB2Trc: ARAM4" , "CHECKSUM1" , "EXCEPTN" , "INCLSPEC" , "DETAIL" FROM "SCIREST_PS" FETCH FIRST 20 ROWS ONLY \
 C  DB2Trc: FOR READ ONLY WITH UR ;
 B  ***LOG BY4=> sql error -747   performing PRE on table SCIREST_PS [dbdbslst     5137]
 B  ***LOG BY0=> [IBM][CLI Driver][DB2] TABLE SAPR3.SCIREST_PS IS NOT AVAILABLE UNTIL THE AUXILIARY TABLES AND INDEXES 
     FOR ITS EXTERNALLY STORED COLUMNS HAVE BEEN CREATED [dbdbslst     5137]
==============================================================

Other conditions may trigger this error and any table containing LOB data can be affected by this -747 error.


""> Read more...

Environment

  • Db2 z/OS any supported release
  • Netweaver AS any release

Product

SAP ERP 6.0

Keywords

LOB CLOB BLOB DB2 MVS z/OS SQL0747N , KBA , 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.