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

    Unanswered: RETCODE : ZRC=0x870F00F2=-2029059854=SQLO_NORES "no resources to create pro

    Hi all,



    C:\Documents and Settings\icmadmin>db2level
    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".




    my production database is unexpectedly closing down,
    i found following error most of the times

    2012-08-21-21.24.14.065000+330 I818192H433 LEVEL: Severe
    PID : 4540 TID : 10612 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : ICMNLSDB
    APPHDL : 0-1312 APPID: GA480168.P40E.11F106004116
    FUNCTION: DB2 UDB, data management, sqldLoadTCB, probe:4592
    RETCODE : ZRC=0x870F00F2=-2029059854=SQLO_NORES
    "no resources to create process or thread"

    2012-08-21-21.24.14.065000+330 I818627H463 LEVEL: Severe
    PID : 4540 TID : 10612 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : ICMNLSDB
    APPHDL : 0-1312 APPID: GA480168.P40E.11F106004116
    FUNCTION: DB2 UDB, data management, sqldLoadTCB, probe:4592
    MESSAGE : Error loading TCB. tcbFlags =
    DATA #1 : Hexdump, 4 bytes
    0x4DD91ED8 : 1420 0000 . ..

    2012-08-21-21.24.14.065000+330 I819092H360 LEVEL: Severe
    PID : 4540 TID : 10612 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : ICMNLSDB
    APPHDL : 0-1312 APPID: GA480168.P40E.11F106004116
    MESSAGE : SQLD_TCB:
    DATA #1 : String, 39 bytes
    Perm Table(3:42)=TBSPACEID=3.TABLEID=42

    2012-08-21-21.24.14.065000+330 I819454H153 LEVEL: Severe
    PID:4540 TID:10612 NODE:000 Title: SQLD_TCB
    Dump File:\IBM\SQLLIB\DB2\454010612.000

    some of the database parameters


    Database heap (4KB) (DBHEAP) = 6500
    Size of database shared memory (4KB) (DATABASE_MEMORY) = 786432
    Catalog cache size (4KB) (CATALOGCACHE_SZ) = (MAXAPPLS*4)
    Log buffer size (4KB) (LOGBUFSZ) = 113
    Utilities heap size (4KB) (UTIL_HEAP_SZ) = 5000
    Buffer pool size (pages) (BUFFPAGE) = 512
    Extended storage segments size (4KB) (ESTORE_SEG_SZ) = 16000
    Number of extended storage segments (NUM_ESTORE_SEGS) = 0
    Max storage for lock list (4KB) (LOCKLIST) = 500

    Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 20000
    Percent of mem for appl. group heap (GROUPHEAP_RATIO) = 70
    Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 7000

    Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = (SHEAPTHRES)
    Sort list heap (4KB) (SORTHEAP) = 400
    SQL statement heap (4KB) (STMTHEAP) = 26000
    Default application heap (4KB) (APPLHEAPSZ) = 15000
    Package cache size (4KB) (PCKCACHESZ) = (MAXAPPLS*8)
    Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384

    Interval for checking deadlock (ms) (DLCHKTIME) = 10000
    Percent. of lock lists per application (MAXLOCKS) = 60
    Lock timeout (sec) (LOCKTIMEOUT) = 60

    Changed pages threshold (CHNGPGS_THRESH) = 60
    Number of asynchronous page cleaners (NUM_IOCLEANERS) = 2
    Number of I/O servers (NUM_IOSERVERS) = 13
    Index sort flag (INDEXSORT) = YES
    Sequential detect flag (SEQDETECT) = YES
    Default prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATIC

    Track modified pages (TRACKMOD) = OFF

    Default number of containers = 1
    Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32

    Max number of active applications (MAXAPPLS) = AUTOMATIC
    Average number of active applications (AVG_APPLS) = 64
    Max DB files open per application (MAXFILOP) = 128

    Log file size (4KB) (LOGFILSIZ) = 1024
    Number of primary log files (LOGPRIMARY) = 8
    Number of secondary log files (LOGSECOND) = 10

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    check if any memory leak..
    if so - machine needs to be restarted - check event viewer for any other reason..
    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
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Check if there's enough space for the tablespace 3 to autoextend.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

Posting Permissions

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