Thread: DB2

-904 unavailable resource - where do I even start?

Started by Omar • user3 replies194 viewsLast activity 2 weeks ago
Post #1
1 votes
Omar
Reputation
155
Posts: 12
Joined: Jan 7, 2025, 10:05 AM
Posted: Jul 27, 2026, 8:05 AM

DSNT408I SQLCODE = -904 ... REASON 00C90096, TYPE 00000302, RESOURCE NAME looking like hex junk.

I know -904 means something is unavailable. How do people decode this without guessing for an hour?

Post #2
0 votes
Elena
Reputation
391
Posts: 19
Joined: Apr 18, 2024, 9:30 AM
Posted: Jul 27, 2026, 10:05 AM

Manual first: reason code + resource type. Those two tell you whether it is a tablespace, DBD, package, temp database, whatever.

Then look at what happened right before (utility, STOP DATABASE, full log, max connections). Forum answers stay generic because the "why" is always local.

Post #3
0 votes
Tom
Reputation
263
Posts: 18
Joined: Mar 8, 2024, 10:10 PM
Posted: Jul 27, 2026, 4:05 PM

In CEDF I have seen -904 on OPEN CURSOR with reason pointing at TEMP DATABASE, then the next FETCH is -501 because the open never stuck. Fix the -904 first.

You must be signed in to reply to this thread