Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2008
    Location
    India
    Posts
    40

    Unanswered: Dsnu012i Dsnugbac - Utility Execution Terminated,return Code-08

    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

  2. #2
    Join Date
    Dec 2004
    Location
    Italy
    Posts
    32
    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.

  3. #3
    Join Date
    Oct 2008
    Location
    India
    Posts
    40
    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

  4. #4
    Join Date
    Dec 2004
    Location
    Italy
    Posts
    32
    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?

  5. #5
    Join Date
    Oct 2008
    Location
    India
    Posts
    40
    I checked in sysibm.systables.It is catalogued and the prefix used is DB2DBA.

  6. #6
    Join Date
    Oct 2008
    Location
    India
    Posts
    40
    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.

  7. #7
    Join Date
    Dec 2004
    Location
    Italy
    Posts
    32
    Good John.

    Happy you could solve the problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •