3304448 - Environment variable DB6LOAD_TEMP_TBSPACE isn't working - SQL0204N.

For R3load SPLITTED_LOAD import you've decided to use the DB6LOAD_TEMP_TBSPACE environment variable to specify in which tablespace the temporary table copies are created.

You've followed the steps correctly per note 1058437, but R3load still is not the using the tablespace for temporary tables.

1. Create tablespace
   
   db2 "connect to db <sid> user <connect user> using <password>"
   
   db2 "CREATE LARGE TABLESPACE "<tbspace name>" IN DATABASE PARTITION GROUP SAPNODEGRP_DB6 PAGESIZE 16K MANAGED BY AUTOMATIC 
   STORAGE USING STOGROUP "SAPTMPGRP" AUTORESIZE YES INITIALSIZE 32 M MAXSIZE NONE EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC 
   BUFFERPOOL "IBMDEFAULTBP" NO FILE SYSTEM CACHING DROPPED TABLE RECOVERY OFF" 
     
2. Updated the <SID>adm user .dbenv and .sapenv shell files to set environments:
   
   export DB6LOAD_TEMP_TBSPACE=<tbspace name>
   setenv DB6LOAD_TEMP_TBSPACE <tbspace name>
   
   
3. However, after resuming SWPM the following error is reported:
   
   ========================================
   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> 
   ========================================

• IBM DB2 LUW (DB6) any release
• SWPM 1.0 sp36 or earlier

R3load , SPLITTED_LOAD , DB6LOAD_TEMP_TBSPACE , SQL0204N , -104 , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , Problem