<SQL0204N "SAPECP.TSDB6" is an undefined name. SQLSTATE=42704>

[Former Member]

R/S All,

*I am getting error while installation as follows. It's ECC6-DB2-WINDOWS installation. Kindly guid me to reslove following error

UPDATE COMMAND OPTIONS USING O ON

DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE COMMAND OPTIONS USING N OFF

DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE sapecp.tsdb6 SET tabspace = 'ECP#'||substr(tabspace,5,length(tabspace)-4), indspace = 'ECP#'||substr(indspace,5,length(tabspace)-4) WHERE ( tabspace like 'PSAP%' AND indspace like 'PSAP%' ) OR ( tabspace like '___#%' AND indspace like '___#%' )

DB21034E The command was processed as an SQL statement because it was not a

valid Command Line Processor command. During SQL processing it returned:

SQL0204N "SAPECP.TSDB6" is an undefined name. SQLSTATE=42704

UPDATE sapecp.tadb6 SET tabspace = 'ECP#'||substr(tabspace,5,length(tabspace)-4) WHERE tabspace like 'PSAP%' OR tabspace like '___#%'

DB20000I The SQL command completed successfully.

UPDATE sapecp.iadb6 SET tabspace = 'ECP#'||substr(tabspace,5,length(tabspace)-4) WHERE tabspace like 'PSAP%' OR tabspace like '___#%'

DB21034E The command was processed as an SQL statement because it was not a

valid Command Line Processor command. During SQL processing it returned:

SQL0204N "SAPECP.IADB6" is an undefined name. SQLSTATE=42704

-- successfull execution of script RC(0)

TERMINATE

DB20000I The TERMINATE command completed successfully.

ERROR 2010-10-28 09:20:23.671

MDB-01999 Error occured, first error is: <SQL0204N "SAPECP.TSDB6" is an undefined name. SQLSTATE=42704>

ERROR 2010-10-28 09:20:23.671

MUT-03025 Caught ESAPinstException in Modulecall: Error occured, first error is: <SQL0204N "SAPECP.TSDB6" is an undefined name. SQLSTATE=42704>.

ERROR 2010-10-28 09:20:23.687

FCO-00011 The step adjust_TablespaceNames with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|2|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_Postload|ind|ind|ind|ind|10|0|NW_Postload_DB6|ind|ind|ind|ind|5|0|NW_DB6_Adjust_TablespaceNames|ind|ind|ind|ind|1|0|adjust_TablespaceNames was executed with status ERROR ( Last error reported by the step :Caught ESAPinstException in Modulecall: Error occured, first error is: <SQL0204N "SAPECP.TSDB6" is an undefined name. SQLSTATE=42704>.).

[Former Member]

Dear Team,

I am trying to import db2 aix to windows but getting error please help.

UPDATE COMMAND OPTIONS USING S OFF

DB20000I  The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE COMMAND OPTIONS USING A OFF

DB20000I  The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE COMMAND OPTIONS USING X ON 

DB20000I  The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE COMMAND OPTIONS USING O ON 

DB20000I  The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE COMMAND OPTIONS USING N OFF

DB20000I  The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE saptep.tsdb6 SET tabspace = 'TEP#'||substr(tabspace,5,length(tabspace)-4) WHERE tabspace like 'PSAP%' OR tabspace like '___#%'

DB21034E  The command was processed as an SQL statement because it was not a

valid Command Line Processor command.  During SQL processing it returned:

SQL0204N  "SAPTEP.TSDB6" is an undefined name.  SQLSTATE=42704

UPDATE saptep.tsdb6 SET indspace = 'TEP#'||substr(indspace,5,length(indspace)-4) WHERE indspace like 'PSAP%' OR indspace like '___#%'

DB21034E  The command was processed as an SQL statement because it was not a

valid Command Line Processor command.  During SQL processing it returned:

SQL0204N  "SAPTEP.TSDB6" is an undefined name.  SQLSTATE=42704

UPDATE saptep.tsdb6 SET tabspace = 'YTEP#'||substr(tabspace,6,length(tabspace)-5) WHERE tabspace like 'Y___#%'

DB21034E  The command was processed as an SQL statement because it was not a

valid Command Line Processor command.  During SQL processing it returned:

SQL0204N  "SAPTEP.TSDB6" is an undefined name.  SQLSTATE=42704

UPDATE saptep.tsdb6 SET indspace = 'YTEP#'||substr(indspace,6,length(indspace)-5) WHERE indspace like 'Y___#%'

DB21034E  The command was processed as an SQL statement because it was not a

valid Command Line Processor command.  During SQL processing it returned:

SQL0204N  "SAPTEP.TSDB6" is an undefined name.  SQLSTATE=42704

UPDATE saptep.tsdb6 SET tabspace = 'ZTEP#'||substr(tabspace,6,length(tabspace)-5) WHERE tabspace like 'Z___#%'

DB21034E  The command was processed as an SQL statement because it was not a

valid Command Line Processor command.  During SQL processing it returned:

SQL0204N  "SAPTEP.TSDB6" is an undefined name.  SQLSTATE=42704

UPDATE saptep.tsdb6 SET indspace = 'ZTEP#'||substr(indspace,6,length(indspace)-5) WHERE indspace like 'Z___#%'

DB21034E  The command was processed as an SQL statement because it was not a

valid Command Line Processor command.  During SQL processing it returned:

SQL0204N  "SAPTEP.TSDB6" is an undefined name.  SQLSTATE=42704

UPDATE saptep.tadb6 SET tabspace = 'TEP#'||substr(tabspace,5,length(tabspace)-4) WHERE tabspace like 'PSAP%' OR tabspace like '___#%'

DB20000I  The SQL command completed successfully.

UPDATE saptep.tadb6 SET tabspace = 'YTEP#'||substr(tabspace,6,length(tabspace)-5) WHERE tabspace like 'Y___#%'

SQL0100W  No row was found for FETCH, UPDATE or DELETE; or the result of a

query is an empty table.  SQLSTATE=02000

UPDATE saptep.tadb6 SET tabspace = 'ZTEP#'||substr(tabspace,6,length(tabspace)-5) WHERE tabspace like 'Z___#%'

SQL0100W  No row was found for FETCH, UPDATE or DELETE; or the result of a

query is an empty table.  SQLSTATE=02000

UPDATE saptep.iadb6 SET tabspace = 'TEP#'||substr(tabspace,5,length(tabspace)-4) WHERE tabspace like 'PSAP%' OR tabspace like '___#%'

DB20000I  The SQL command completed successfully.

UPDATE saptep.iadb6 SET tabspace = 'YTEP#'||substr(tabspace,6,length(tabspace)-5) WHERE tabspace like 'Y___#%'

SQL0100W  No row was found for FETCH, UPDATE or DELETE; or the result of a

query is an empty table.  SQLSTATE=02000

UPDATE saptep.iadb6 SET tabspace = 'ZTEP#'||substr(tabspace,6,length(tabspace)-5) WHERE tabspace like 'Z___#%'

SQL0100W  No row was found for FETCH, UPDATE or DELETE; or the result of a

query is an empty table.  SQLSTATE=02000

-- successfull execution of script RC(0)                           

TERMINATE

DB20000I  The TERMINATE command completed successfully.

Regards

Raj

[Former Member]

Hi Raj,

I am facing same problem. Please let me know how you are able to overcome the issue...?

Thanks

Venkat R