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.

Looks like the subsystem db2c is not available ... Use the display group command to know the status

I already did that prior to posting the error here and all susbsystems are active.