SAP Knowledge Base Article - Preview

3061915 - Splitted load reports SQL0104N on create of temporary Db2 table

Symptom

You're performing an import using the splitted load option and seeing the following error reported.
=======================================================================================
A2 ETSK 005 Starting import for object "VVSCPOS" of type "table" #20210316074259
A1 EDMP 003 Export data is unsorted.
A1 EFLD 017 Table VVSCPOS is no virtual table.
A1 EFLD 016 Temporary table VVSCPOS_SPLITTED_LOAD_3643148620 for split load processing did not yet exist.
A1EEIMP 008 Task failed with error: (DBS) 'DBInitFastload' failed
A1EEIMP 008 (DB6) Failed to create temporary table VVSCPOS_SPLITTED_LOAD_3643148620 for split load processing.
A1EEIMP 008 
A1EEIMP 008 (DB6) SQL Code:      -104
A1EEIMP 008 (DB6) Message text:  SQL0104N  An unexpected token "YES" was found following "SCPOS" IN   COMPRESS".  Expected tokens may include:  "END-OF-STATEMENT".  SQLSTATE=42601
A1EEIMP 008 (DB6) SQL statement: CREATE TABLE "VVSCPOS_SPLITTED_LOAD_3643148620" LIKE "VVSCPOS" IN   COMPRESS YES
=======================================================================================

Load Options are:
-stop_on_error -loadprocedure fast SPLITTED_LOAD:COMPRESS_ADAPTIVE_ALL:DEF_CR

However, when the following load options are used the import works.
-stop_on_error -loadprocedure fast LOAD:COMPRESS_ADAPTIVE_ALL:DEF_CRT

Furthermore, it seems only create of partitioned tables are affected by this.  Non-partitioned tables get created without issue.


Read more...

Environment

  • Db2 (DB6) any version
  • Netweaver AS any version
  • Software Provisioning Manager (SWPM) any version

Product

SAP ERP 6.0 ; SAP NetWeaver all versions

Keywords

R3load , import , SPLITTED_LOAD , -104 , SQL0104N , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-INS , Installation SAP System , 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.