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
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.
SAP Knowledge Base Article - Preview