If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > sqlcode -904

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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.
Reply With Quote
  #2 (permalink)  
Old
Super Moderator
 
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.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Sep 2003
Location: manila
Posts: 21
I already did that prior to posting the error here and all susbsystems are active.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On