SAP Knowledge Base Article - Preview

3304429 - Seeing SQL0204N on SPLITTED_LOAD import.

Symptom

You're using the SPLITTED_LOAD expert option for R3load import and encounter the following error:

========================================
A1 EFLD 017 Table RSDDSTATINFO is no virtual table.
A1 EFLD 016 Temporary table RSDDSTATINFO_SPLITTED_LOAD_3033589774 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 RSDDSTATINFO_SPLITTED_LOAD_3033589774 for split load processing.
A1EEIMP 008 
A1EEIMP 008 (DB6) SQL Code:      -204
A1EEIMP 008 (DB6) Message text:  SQL0204N  "SAPR3.RSDDSTATINFO" is an undefined name.  SQLSTATE=42704
A1EEIMP 008 (DB6) SQL statement: CREATE TABLE "RSDDSTATINFO_SPLITTED_LOAD_3033589774" LIKE "RSDDSTATINFO" IN <tbspace name> 
========================================

What happens here is that we try to create the temporary copy of the table RSDDSTATINFO (LIKE condition) in the tablespace for the migration. But it fails as the table is not existing yet.

But closer review of the logs we can see that the creation of the temporary table fails because the original table is not there:
========================================  
A2 ETSK 000 Starting import for object "RSDDSTATINFO" of type "table" #20230204023605
A1EEIMP 008 (DB6) SQL Code:      -204
A1EEIMP 008 (DB6) Message text:  SQL0204N  "SAPR3.RSDDSTATINFO" is an undefined name.  SQLSTATE=42704
A1EEIMP 008 (DB6) SQL statement: CREATE TABLE "RSDDSTATINFO_SPLITTED_LOAD_837966859" LIKE "RSDDSTATINFO" IN PSAPTEMPMIG
========================================

But the original table was created some seconds before:
========================================
A2 ETSK 000 Starting create for object "RSDDSTATINFO" of type "table" #20230204023508
A1 EDB6 013 Exceptional compression mode for table RSDDSTATINFO is "YES".
A1 EIMP 001 Task for 'RSDDSTATINFO' executed #20230204023535
A2 ETSK 005 Finished create for object "RSDDSTATINFO" of type "table" in 26.62 sec #20230204023535
========================================


Read more...

Environment

  • IBM DB2 LUW (DB6) any release
  • SWPM 1.0 sp36 and older

Product

SAP NetWeaver Application Server all versions

Keywords

R3load , SPLITTED_LOAD , SQL0204N , -204 , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , 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.