SAP Knowledge Base Article - Preview

2873803 - IBM Db2 LUW [DB6] . . . SQL0156N The name used for this operation is not a table. SQLSTATE=42809

Symptom

  • instdir_SAPDFACT.log
                 . . .
                    A1 ETSK 005 Starting create for object "<table_nm>~040" of type "index" #YYYYMMDDHHMMSS
                    A1 ESQL 004 index <table_nm>~040: SQL overridden by '/export/ABAP/DB/DB6/DFACT.SQL', line 21-24
                    A1EEIMP 010 Task failed with error: (DB6) DDL statement failed with SQL error!
                    A1EEIMP 010   (CREATE TYPE 2  INDEX "<table_nm>~040" ON "<table_nm>" ("<key_nm>"  ) PIECESIZE ####### K)
                    A1EEIMP 010 (SQL error -156)
                    A1EEIMP 010   Error message returned by DbSl:
                    A1EEIMP 010 SQL0156N  The name used for this operation is not a table.  SQLSTATE=42809
  • DFACT.SQL
                 . . .
                    #
                    # DB2 : NATIVE SQL EXPORT GENERATED AT 20191213110412
                    #
                   
                    ind: <table_nm>~0
                    sql: CREATE TYPE 2 UNIQUE INDEX "<table_nm>~0"
                         ON "<table_nm>"


Read more...

Environment

  • IBM Db2 LUW
  • SWPM heterogeneous system copy
       . . .from . . . IBM Db2 LUW
       . . . to  . . . IBM Db2 LUW

Product

SAP ERP 6.0

Keywords

KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.