Results 1 to 3 of 3

Thread: sqlcode -904

  1. #1
    Join Date
    Sep 2003
    Location
    manila
    Posts
    21

    Question sqlcode -904

    hi all,

    i'm using DB2 for OS390 ver 7 and encountered the following error and don't know what to do, please help! I already issued a display command against the index and the table and they are both in Read write status.

    Stmt No: . SELECT COUNT(*) FROM EMP
    DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00E30100, TYPE OF RESOURCE 00000906, AND RESOURCE NAME DB2C

    From redbooks i saw the following explanation for the reason code

    00E30100
    Explanation: This reason code can be returned in the following cases:

    o A parallel task running on a DB2 terminates abnormally.
    o An assisting DB2 terminates abnormally.

    This reason code is issued by the following CSECTs: DSNTTTC, DSNTTREB

    System Action: The member name where the failure occurred is returned to
    the application as the resource name in SQLCODE -904. In a
    non-data-sharing environment, the member name is blank, and the failure
    occurrs on the local DB2.

    Operator Response: Enter DISPLAY GROUP from an active DB2 to see if a DB2
    subsystem is down. Restart the failed DB2 subsystem.

    Problem Determination: Collect the following diagnostic items listed in
    Appendix B, "Problem determination" in item PROBLEM_DETERMIN : 1, 2, 5.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,649
    Looks like the subsystem db2c is not available ... Use the display group command to know the status
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Sep 2003
    Location
    manila
    Posts
    21
    I already did that prior to posting the error here and all susbsystems are active.

Posting Permissions

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