Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Location
    Trivandrum
    Posts
    27

    Angry Unanswered: 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 Attached Files

  2. #2
    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

  3. #3
    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 ?

  4. #4
    Join Date
    Jul 2011
    Posts
    29
    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.

  5. #5
    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 !!!!!!!!!!!!!!!!!!!!!!!!!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •