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

    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
    command.

    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.

    Explanation:

    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
    system.

    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
    application.
    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
    file.

    2012-07-16-00.03.28.761815+060 I379207909A695 LEVEL: Severe
    PID : 442566 TID : 1 PROC : db2agent (CDMBKZD2) 0
    INSTANCE: db2zcdm2 NODE : 000
    APPHDL : 0-895 APPID: *LOCAL.db2zcdm2.121121023922
    AUTHID : DB2ZCDM2
    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
    0x0780000020010b40
    DATA #3 : Pointer, 8 bytes
    0x0ffffffffffef148
    DATA #4 : Bitmask, 4 bytes
    0x00000180


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

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    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
    http://www.infocura.be

  3. #3
    Join Date
    Jul 2012
    Posts
    2

    Update

    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
  •