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.