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