View previous topic :: View next topic
|
Author |
Message |
Lord.of.Wind
New User
Joined: 17 Nov 2005 Posts: 60
|
|
|
|
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 |
|
|
mahsug
New User
Joined: 01 Jul 2003 Posts: 15 Location: Phoenix , AZ
|
|
|
|
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 |
|
|
Lord.of.Wind
New User
Joined: 17 Nov 2005 Posts: 60
|
|
|
|
Thank you so much! I will paste the full error message tomorrow! |
|
Back to top |
|
|
Lord.of.Wind
New User
Joined: 17 Nov 2005 Posts: 60
|
|
|
|
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 |
|
|
santy780
New User
Joined: 15 Jul 2006 Posts: 9
|
|
|
|
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 |
|
|
Lord.of.Wind
New User
Joined: 17 Nov 2005 Posts: 60
|
|
|
|
Thank you so much! I will send this information to somebody. |
|
Back to top |
|
|
|