Hi,
I was loading one table and the jcl after execution gave the return cod 08.

It shows the following message.Can anyone pls tell me what is the source of error and what should be done?

.DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = VXTXC
.DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC
.DSNU050I DSNUGUTC - LOAD DATA LOG YES INDDN SYSREC00 REPLACE
.DSNU650I -DBW1 DSNURWI - INTO TABLE DB2DBA.IVIS_CARR
.DSNU056I -DBW1 DSNUGMAP - TABLE 'DB2DBA.ISTX' NOT FOUND
.DSNU650I -DBW1 DSNURWI - (ID_CRY POSITION(1) CHAR(2),
.DSNU650I -DBW1 DSNURWI - NAM_CRY POSITION(4) CHAR(60),
.DSNU650I -DBW1 DSNURWI - NAM_CRY POSITION(65) CHAR(16) NULLIF(65)=' ',
.DSNU650I -DBW1 DSNURWI - CODE_TRAN_TYP POSITION(82) CHAR(3),
.DSNU650I -DBW1 DSNURWI - CODE_SCAC POSITION(86) CHAR(4),
.DSNU650I -DBW1 DSNURWI - DATE_CRR_EXP POSITION(91) DATE EXTERNAL(10) NULLI
.DSNU650I -DBW1 DSNURWI - DATE_CREA POSITION(102) TIMESTAMP EXTERNAL(26),
.DSNU650I -DBW1 DSNURWI - ID_USER POSITION(129) CHAR(8),
.DSNU650I -DBW1 DSNURWI - DATE_LAST_UPDT POSITION(138) TIMESTAMP EXTERNAL(26)
.DSNU650I -DBW1 DSNURWI - ID_LAST_UPDT_USER POSITION(165) CHAR(8))
.DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8

John,

the name of the table DB2DBA.IVIS_CARR you are trying to load seems to be a synonym of the table DB2DBA.ISTX that cannot be found in catalog.

Hope this clue can be useful for you.

Sorry the actual message displayed is...

DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = VXTXC
.DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC
.DSNU050I DSNUGUTC - LOAD DATA LOG YES INDDN SYSREC00 REPLACE
.DSNU650I -DBW1 DSNURWI - INTO TABLE DB2DBA.ISTX
.DSNU056I -DBW1 DSNUGMAP - TABLE 'DB2DBA.ISTX' NOT FOUND
.DSNU650I -DBW1 DSNURWI - (ID_CRY POSITION(1) CHAR(2),
.DSNU650I -DBW1 DSNURWI - NAM_CRY POSITION(4) CHAR(60),
.DSNU650I -DBW1 DSNURWI - NAM_CRY POSITION(65) CHAR(16) NULLIF(65)=' ',
.DSNU650I -DBW1 DSNURWI - CODE_TRAN_TYP POSITION(82) CHAR(3),
.DSNU650I -DBW1 DSNURWI - CODE_SCAC POSITION(86) CHAR(4),
.DSNU650I -DBW1 DSNURWI - DATE_CRR_EXP POSITION(91) DATE EXTERNAL(10) NULLI
.DSNU650I -DBW1 DSNURWI - DATE_CREA POSITION(102) TIMESTAMP EXTERNAL(26),
.DSNU650I -DBW1 DSNURWI - ID_USER POSITION(129) CHAR(8),
.DSNU650I -DBW1 DSNURWI - DATE_LAST_UPDT POSITION(138) TIMESTAMP EXTERNAL(26)
.DSNU650I -DBW1 DSNURWI - ID_LAST_UPDT_USER POSITION(165) CHAR(8))
.DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8

John, I'm a bit puzzled.

The table DB2DBA.ISTX you are trying to load is apparently missing in the catalog, but probably somebody has instructed you to load this table.

Maybe the qualifier of the ISTX table is different...

What is the catalog answer if you look for the ISTX table in the sysibm.systables catalog table?

I checked in sysibm.systables.It is catalogued and the prefix used is DB2DBA.

Hi,
I got the problem.
When i checked the load in test region,it was working fine.But after it is moved to production,it gave this error.So when i checked the date of creation in sysibm.systables , i found that the prod table was catalogued only yesterday.That means the job was moved to production before cataloguing the table which resulted in the load error.
Thanks a lot for your response.

Good John.

Happy you could solve the problem.