"DDL statement failed" in Database load faze

[Former Member]

Hello,

I have an problem when installing DB2 on Solaris platform.

During the installation, in Database load Faze, i get the error:

MSC-01015 Process finished with error(s), check log file /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/DB6/NUC/DB/SAPVIEW.log

I check the log & it has a whole bunch on tables that are created & at the end of it i get this message:

DB) ERROR: DDL statement failed

(CREATE VIEW "D010TINF" ( "PROG", "R3STATE", "LANGUAGE", "UNAM", "UDAT", "UTIME", "DATALG" ) AS SELECT T0001."PROGNAME"

, T0001."R3STATE", T0001."LANGUAGE", T0001."UNAM", T0001."UDAT", T0001."UTIME", T0001."DATALG" FROM "REPOTEXT" T0001)

DbSlExecute: rc = 103

(SQL error -204)

error message returned by DbSl:

SQL0204N "SAPS47.REPOTEXT"; is an undefined name. SQLSTATE=42704

(DB) INFO: disconnected from DB

/sapmnt/S47/exe/R3load: job finished with 1 error(s)

/sapmnt/S47/exe/R3load: END OF LOG: 20080810125355

/sapmnt/S47/exe/R3load: START OF LOG: 20080810130455

/sapmnt/S47/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/sapmnt/S47/exe/R3load: version R6.40/V1.4

/sapmnt/S47/exe/R3load -dbcodepage 1100 -i /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/DB6/NUC/DB/SAPVIEW.cmd -l /tmp/sapin

st_instdir/R3E47X2/SYSTEM/ABAP/DB6/NUC/DB/SAPVIEW.log -c 300 -merge_bck -stop_on_error

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

(DROP VIEW "D010TINF")

DbSlExecute: rc = 103

(SQL error -204)

error message returned by DbSl:

SQL0204N "SAPS47.D010TINF"; is an undefined name. SQLSTATE=42704

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "D010TINF" ( "PROG", "R3STATE", "LANGUAGE", "UNAM", "UDAT", "UTIME", "DATALG" ) AS SELECT T0001."PROGNAME"

, T0001."R3STATE", T0001."LANGUAGE", T0001."UNAM", T0001."UDAT", T0001."UTIME", T0001."DATALG" FROM "REPOTEXT" T0001)

DbSlExecute: rc = 103

(SQL error -204)

error message returned by DbSl:

SQL0204N "SAPS47.REPOTEXT"; is an undefined name. SQLSTATE=42704

(DB) INFO: disconnected from DB

/sapmnt/S47/exe/R3load: job finished with 1 error(s)

/sapmnt/S47/exe/R3load: END OF LOG: 20080810130457

/sapmnt/S47/exe/R3load: START OF LOG: 20080810140953

/sapmnt/S47/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/sapmnt/S47/exe/R3load: version R6.40/V1.4

/sapmnt/S47/exe/R3load -dbcodepage 1100 -i /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/DB6/NUC/DB/SAPVIEW.cmd -l /tmp/sapin

st_instdir/R3E47X2/SYSTEM/ABAP/DB6/NUC/DB/SAPVIEW.log -c 300 -merge_bck -stop_on_error

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

(DROP VIEW "D010TINF")

DbSlExecute: rc = 103

(SQL error -204)

error message returned by DbSl:

SQL0204N "SAPS47.D010TINF"; is an undefined name. SQLSTATE=42704

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "D010TINF" ( "PROG", "R3STATE", "LANGUAGE", "UNAM", "UDAT", "UTIME", "DATALG" ) AS SELECT T0001."PROGNAME"

, T0001."R3STATE", T0001."LANGUAGE", T0001."UNAM", T0001."UDAT", T0001."UTIME", T0001."DATALG" FROM "REPOTEXT" T0001)

DbSlExecute: rc = 103

(SQL error -204)

error message returned by DbSl:

SQL0204N "SAPS47.REPOTEXT"; is an undefined name. SQLSTATE=42704

(DB) INFO: disconnected from DB

/sapmnt/S47/exe/R3load: job finished with 1 error(s)

/sapmnt/S47/exe/R3load: END OF LOG: 20080810140954

Please lend me some of your wisdom

Regards,

Yoav Zilberman

[Former Member · Accepted solution]

Hi Yoav,

your import failed already before the SAPVIEW package was processed. You should check the other packages too for errors or for packages which are not imported. But the errors show that at lease the tables REPOTEXT and D010TINF are missing. I'm not sure, but I think they are in SAPDDIC package. You should run the package again before running SAPVIEW. For a functioning system you need both, tables and views.

Regards

Ralph