Results 1 to 2 of 2

Thread: -904

  1. #1
    Join Date
    Nov 2002
    Location
    Bhubaneswar
    Posts
    1

    Unanswered: -904

    Hi I am getting this message while trying to browse the table? Can anyone give me a solution to this this.

    ********************************* TOP OF DATA *********************************
    DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
    UNAVAILABLE RESOURCE. REASON 00D70024, TYPE OF RESOURCE
    00000220, AND RESOURCE NAME CST002.DSNDBC.CSSRD007.CSS308I1.I-
    0001.A001
    DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
    DSNT415I SQLERRP = DSNXRRC SQL PROCEDURE DETECTING ERROR
    DSNT416I SQLERRD = 102 13172746 0 13820889 -1041948670 12714048
    SQL DIAGNOSTIC INFORMATION
    DSNT416I SQLERRD = X'00000066' X'00C9000A' X'00000000'
    X'00D2E3D9' X'C1E52002' X'00C20040' SQL DIAGNOSTIC
    INFORMATION
    ******************************** BOTTOM OF DATA *******************************

  2. #2
    Join Date
    Feb 2002
    Location
    Germany
    Posts
    141
    From "Messages and codes":
    <manual>
    00D70024
    Explanation: No data sets exist for a nonpartitioned table space or index space. Because at least one existed at create time, a serious problem might have occurred for this table space or index space. The name of the data set that DB2 expected to find for the table space or index space appears in message DSNP012I and/or in the SQLCA along with the reason code.
    System Action: The request is terminated.
    System Programmer Response: Ensure that the data set and its pack are available to DB2 and that the data set has not been inadvertently deleted or migrated by any DASD operation. If the data set name is correct, is cataloged, and appears in the VTOC, run the access method services DIAGNOSE command on the integrated catalog facility (ICF) catalog identified by the first qualifier of the data set name. The DIAGNOSE command is described in DFSMS/MVS: Access Method Services for the Integrated Catalog.
    Problem Determination: Obtain the following:
    The integrated catalog facility (ICF) catalog
    The VTOC listings
    Details of the request that led to this code
    Contents of the SQLCA
    The operator's console sheet showing related messages
    </manual>
    Rodney Krick

Posting Permissions

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