Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    123

    Unanswered: ZRC=0x8805006C=-2012938132=SQLE_ZRC_CTX_NO_CTX

    Hi All,
    my environment info is as follows:

    DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08026" with

    level identifier "03070106".

    Informational tokens are "DB2 v8.1.13.193", "s060801", "WR21371", and FixPak

    "13".

    Product is installed at "D:\IBM\SQLLIB".


    Windows environment.

    In my environment user accessing database is around 400 members (accessing max CLOB data only )

    After crossing 200 connections i am getting following errors frequently in diaglog and db2 doing to crash, due to some application dependency i cant migrate to 9.1, pls find the attached dbcfg, dbmcfg, db2set and diaglog for your reference.

    2013-01-12-09.26.18.168000+330 I49258362H449 LEVEL: Error
    PID : 4100 TID : 7440 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : TESTDB
    APPHDL : 0-508 APPID: GA4801F1.JC0C.12DA42033742
    FUNCTION: DB2 UDB, buffer pool services, sqlbReadPageFromContainer, probe:20
    RETCODE : ZRC=0x870F00F2=-2029059854=SQLO_NORES
    "no resources to create process or thread"

    2013-03-05-11.02.21.222000+330 I8476H369 LEVEL: Severe
    PID : 2652 TID : 3452 PROC : MsiExec.exe
    INSTANCE: DB2 NODE : 000
    FUNCTION: DB2 UDB, base sys utilities, sqleFreeCtxInternal, probe:10
    RETCODE : ZRC=0x8805006C=-2012938132=SQLE_ZRC_CTX_NO_CTX
    "Thread or process does not have a context to use."

    2013-03-11-10.54.10.367000+330 E1370946H591 LEVEL: Severe (OS)
    PID : 4376 TID : 5888 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : TESTDB
    APPHDL : 0-1185 APPID: GA4801F1.AC05.13A1C1035416
    FUNCTION: DB2 UDB, oper system services, getPrivateChunksFromOs, probe:100
    CALLED : OS, -, VirtualAlloc
    OSERR : 8 "Not enough storage is available to process this command."
    MESSAGE : Private memory and/or virtual address space exhausted
    DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
    10502144

    2013-03-11-10.54.10.461000+330 E1371539H591 LEVEL: Severe (OS)
    PID : 4376 TID : 5888 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : TESTDB
    APPHDL : 0-1185 APPID: GA4801F1.AC05.13A1C1035416
    FUNCTION: DB2 UDB, oper system services, getPrivateChunksFromOs, probe:100
    CALLED : OS, -, VirtualAlloc
    OSERR : 8 "Not enough storage is available to process this command."
    MESSAGE : Private memory and/or virtual address space exhausted
    DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes


    Any ideas , pls let me know

    .dbcfg.txt

    dbmcfg.txt

    db2set.txt

    diag 118 error.txt

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Looking at the value of APP_CTL_HEAP_SZ, at 200 concurrent connections your application private memory requirement can exceed 5 GB, which you can't have available on a 32-bit system. You will need to limit the number of concurrent connections, reduce the application control heap setting, enable the connection concentrator, or all of the above.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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