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 > SQL0930N - There is not Enough Storage available to process the statement

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-15-04, 18:29
Chandrat Chandrat is offline
Registered User
 
Join Date: Dec 2003
Location: Trivandrum
Posts: 27
Angry SQL0930N - There is not Enough Storage available to process the statement

Hi friends,

Our Electronic archieve system has the following enviroment:

1. Windows 2000 Server with SP 3
2. DB2 8.1 with Fixpack 2
3. WAS 5.0.2
4. DB2 Content Manager V8.2
5. DB2 Content Manager windows Client V8.2

My Problem:

When I'm trying to save the document while Importing or Scanning through Content Manager Windows Client V8.2, I'm receiving the following Error

**********************************
[IBM][CLI Driver][DB2/NT]SQL0930N There is not enough Storage Available to process the Statement. SQLSTATE=57011
[SQLExecDirect][SQLCODE=930.SQLSTATE=57011][STATE]:57011
**********************************

The archive server has newly built with CM8.2 two months ago and my Data Partition on the Server has enough Storage Space (90 GB). We already scanned and imported more than 300 Documents into the archieve system. But sudddenly receiving the error and it is not allowing us to save the images & documents in to archieve system.

Please follow the attachment to verify the Error and Please help me to fix this issue

Thanks in advance.
Attached Files
File Type: doc Error Doc 1.doc (70.5 KB, 137 views)
Reply With Quote
  #2 (permalink)  
Old 08-16-04, 10:07
dbamota dbamota is offline
Registered User
 
Join Date: Sep 2003
Posts: 237
SQL0930N There is not enough storage available to process the
statement.

Explanation: A request was made to the database that required
another memory page but no more pages are available to the
database manager.

The statement cannot be processed.

User Response: Possible solutions include:

o Verify that your system has sufficient real and virtual
memory.

o Remove background processes.

o If the error occurs during DUOW resynchronization, increase
the maxagents and reduce the resync_interval database manager
configuration parameter values.

You have to change your database configuration and or Windows OS config to allow more memory for the process
__________________
mota
Reply With Quote
  #3 (permalink)  
Old 07-13-11, 04:58
nmcuong nmcuong is offline
Registered User
 
Join Date: Jul 2011
Posts: 10
Quote:
Originally Posted by dbamota View Post
SQL0930N There is not enough storage available to process the
statement.

Explanation: A request was made to the database that required
another memory page but no more pages are available to the
database manager.

The statement cannot be processed.

User Response: Possible solutions include:

o Verify that your system has sufficient real and virtual
memory.

o Remove background processes.

o If the error occurs during DUOW resynchronization, increase
the maxagents and reduce the resync_interval database manager
configuration parameter values.

You have to change your database configuration and or Windows OS config to allow more memory for the process
How can you give me details of solutions ?
Reply With Quote
  #4 (permalink)  
Old 07-13-11, 10:00
sanchez786 sanchez786 is offline
Registered User
 
Join Date: Jul 2011
Posts: 24
Quote:
Originally Posted by nmcuong View Post
How can you give me details of solutions ?
On the command line type: db2 "? SQL0930N"

It will give you details of the error and resolution.
Reply With Quote
  #5 (permalink)  
Old 07-13-11, 23:31
nmcuong nmcuong is offline
Registered User
 
Join Date: Jul 2011
Posts: 10
Quote:
Originally Posted by sanchez786 View Post
On the command line type: db2 "? SQL0930N"

It will give you details of the error and resolution.

Thanks !!!!!!!!!!!!!!!!!!!!!!!!!!!
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