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
  • SAP one support "SAP for Me"

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 for Me (Login required).

Search for additional results

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