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

Search for additional results

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