Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2012

    Unanswered: Error while connecting to db2 database - not enough system resources vaialble

    I am tryring to connect to a database on db2 server but getting the following error.

    SQL10003C There are not enough system resources to process the
    request. The request cannot be processed.

    If I do "db2 list active databases" get the following error :
    SQL1092N "DB2ZCDM2" does not have the authority to perform the requested

    but instace owner is part of sysadm group.

    db2level - db2 v9.1 fp4a
    oslevel - AIX 5.3
    The server has 20G real memory and 1G paging space.

    There is another isntance on the same server and a database in it. I am able to successfully connect
    to that database.

    db2 ? SQL10003C
    SQL10003C There are not enough system resources to process the
    request. The request cannot be processed.


    The database manager could not process the request due to
    insufficient system resources. The resources that can cause this
    error include:
    o The amount of memory in the system
    o The number of message queue identifiers available in the

    User Response:
    Stop the application. Possible solutions include:
    o Remove background processes.
    o Terminate other applications using the above resources.
    o If you are using Remote Data Services, increase the Remote
    Data Services heap size (rsheapsz) in the server and client
    configuration because at least one block is used per
    NOTE: This is applicable only for releases of DB2 prior to
    Version 2.
    o Decrease the values of the configuration parameters that
    define allocation of memory, including ASLHEAPSZ if UDFs are
    involved in the failing statement.
    o Avoid accessing large files or use non-buffered I/O. To use
    non-buffered I/O, set the DB2 registry variable DB2NTNOCACHE
    to YES.

    sqlcode : -10003

    sqlstate : 57011

    Also I can see the below messages continuously getting generated in the db2diag.log

    2012-07-16- I379207909A695 LEVEL: Severe
    PID : 442566 TID : 1 PROC : db2agent (CDMBKZD2) 0
    INSTANCE: db2zcdm2 NODE : 000
    APPHDL : 0-895 APPID: *LOCAL.db2zcdm2.121121023922
    FUNCTION: DB2 UDB, buffer pool services, sqlbGetFileSystemInfo, probe:25
    MESSAGE : ZRC=0x8B0F0058=-1961951144=SQLO_NOMEM_PRIH
    "No memory available in 'Private Heap'"
    SQL0083C A memory allocation error has occurred.
    DATA #1 : String, 30 bytes
    Could not get file system info
    DATA #2 : Pointer, 8 bytes
    DATA #3 : Pointer, 8 bytes
    DATA #4 : Bitmask, 4 bytes

    Could anyone please help me identifying the problem and a solution to this?

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    for the first problem : maybe this can help
    IBM sqlsAllocateSortMemory : Not enough memory available for a (private) sortheap - United States
    instance owner is not correctly attached to sysadm group
    publish value of dbm cfg - publish user-group relation
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Jul 2012


    Thanks przytula_guy for your input!

    I could resolve all these errors by instance restart.
    There was no enough memory available for any new database connections.

    Now I am able to connect to database successfully. No memory allocations errors. No SQL1092N error messages regarding authority.

Posting Permissions

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