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
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.