Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Need Reason and Solution for SQLCODE = -904

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Lord.of.Wind

New User


Joined: 17 Nov 2005
Posts: 60

PostPosted: Mon Jul 31, 2006 1:17 pm    Post subject: Need Reason and Solution for SQLCODE = -904
Reply with quote

select *
FROM
SECURITY B,
SECURITY_OPER A
WHERE
A.FK_TSSB0454_CSE_01 = B.C_SECURITY_NUMBER
SQLCODE = -904

*DDL
FK_TSSB0454_CSE_01 DECIMAL(16, 0) NOT NULL,
C_SECURITY_NUMBER DECIMAL(16, 0) NOT NULL

select *
FROM
GiDFSBA.SB_F_SECURITY b,
sqlcode = 0

select *
FROM
GiDFSBA.SB_F_SECURITY_OPER
sqlcode = 0

------------------------------
Anybody can tell me why that SQLCODE = -904 but 100 or 0?
Many many thanks!
Back to top
View user's profile Send private message

mahsug

New User


Joined: 01 Jul 2003
Posts: 15
Location: Phoenix , AZ

PostPosted: Mon Jul 31, 2006 1:30 pm    Post subject: Reg : -904
Reply with quote

Hi Lord of Wind,

First of all, I want to tell you that -904 can be for many reasons , be it if the resource is in restrictive state , or some problems with underlying physical VSAM LDS. So , please post the complete error message.

But to troubleshoot , with the -904 message, a resource code would be specified , which can be looked upon in Db2 error messages reference manual. Also , you would be specified of the db2 object , which is causing you the problem . So you can analyse more on the object , to find out why is -904 occuring.

More than all these , you can also search at MSTR spool , to see what is restricting you to use the resource , which may be very handy to trouble shoot these kind of situations.

Please let me know , if any more queries

Bye
Mahesh
Back to top
View user's profile Send private message
Lord.of.Wind

New User


Joined: 17 Nov 2005
Posts: 60

PostPosted: Mon Jul 31, 2006 8:38 pm    Post subject:
Reply with quote

Thank you so much! I will paste the full error message tomorrow!
Back to top
View user's profile Send private message
Lord.of.Wind

New User


Joined: 17 Nov 2005
Posts: 60

PostPosted: Tue Aug 01, 2006 7:30 am    Post subject:
Reply with quote

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90084, TYPE OF RESOURCE 00000230, AND
RESOURCE NAME 4K
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRSOR SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -115 13172746 0 13231826 -959250432 0 SQL DIAGNOSTIC
INFORMATION
DSNT416I SQLERRD = X'FFFFFF8D' X'00C9000A' X'00000000' X'00C9E6D2'
X'C6D30000' X'00000000' SQL DIAGNOSTIC INFORMATION

and
QW 57011-677 INSUFFICIENT VIRTUAL STORAGE FOR BUFFERPOOL EXPANSION

Explanation: An attempt to either open (create) or expand a buffer pool
has failed because insufficient virtual storage was available.

This error may occur under either of two circumstances:

o An attempt to create a buffer pool while opening a table space or
index(space), or
o An attempt to expand a buffer pool from its current size to its
maximum size.

System Action: The statement cannot be executed.

Programmer Response: If this error should occur during interactive
execution of an SQL statement or execution of an application program,
installation administration should be notified.
Back to top
View user's profile Send private message
santy780

New User


Joined: 15 Jul 2006
Posts: 9

PostPosted: Tue Aug 01, 2006 4:26 pm    Post subject:
Reply with quote

lord, -904 can occur when the dbd's (database descriptors) are very large , reduce the size of the dbd's. ask ur dba to run MODIFY RECOVERY to remove old image copy information for the dropped tables.
Back to top
View user's profile Send private message
Lord.of.Wind

New User


Joined: 17 Nov 2005
Posts: 60

PostPosted: Tue Aug 01, 2006 5:34 pm    Post subject:
Reply with quote

Thank you so much! I will send this information to somebody.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
No new posts SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
This topic is locked: you cannot edit posts or make replies. Need help in design the solution ritnihi PL/I & Assembler 1 Tue Dec 22, 2015 1:48 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us