Topic
1 reply Latest Post - ‏2012-05-19T12:58:05Z by hatuan
hatuan
hatuan
2 Posts
ACCEPTED ANSWER

Pinned topic DB2 10.1 Express-C SAMPLE connect error

‏2012-05-19T04:25:17Z |
I installed new DB2 10.1 Express-c but when I connect to SAMPLE it have error
"SQL1224N The database manager is not able to accept new requests, has
terminated all requests in progress, or has terminated the specified request
because of an error or a forced interrupt. SQLSTATE=55032'

DB2 9.7.5 don't have the problem
Please help me.
Tuan Hoang ANh
Updated on 2012-05-19T12:58:05Z at 2012-05-19T12:58:05Z by hatuan
  • hatuan
    hatuan
    2 Posts
    ACCEPTED ANSWER

    Re: DB2 10.1 Express-C SAMPLE connect error

    ‏2012-05-19T12:58:05Z  in response to hatuan
    Here is my db2diag.log
    2012-05-19-17.16.29.909000+420 I1F1010 LEVEL: Event
    PID : 3192 TID : 3544 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    HOSTNAME: TuanHa-PC
    EDUID : 3544 EDUNAME: db2wlmt
    FUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, probe:120
    START : New Diagnostic Log file
    DATA #1 : Build Level, 152 bytes
    Instance "DB2" uses "64" bits and DB2 code release "SQL10010"
    with level identifier "0201010E".
    Informational tokens are "DB2 v10.1.0.872", "s120403", "NTX64101", Fix Pack "0".
    DATA #2 : System Info, 1568 bytes
    System: WIN32_NT TUANHA-PC Service Pack 1 6.1 AMD64 Family 6, model 42, stepping 7
    CPU: total:4 online:4 Cores per socket:8 Threading degree per core:1
    Physical Memory(MB): total:4047 free:1066 available:1066
    Virtual Memory(MB): total:9201 free:3759
    Swap Memory(MB): total:5154 free:2693
    Information in this record is only valid at the time when this file was
    created (see this record's time stamp)

    2012-05-19-17.16.29.908000+420 I1014F424 LEVEL: Warning
    PID : 3192 TID : 3544 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    HOSTNAME: TuanHa-PC
    EDUID : 3544 EDUNAME: db2wlmt
    FUNCTION: DB2 UDB, base sys utilities, sqleTimedSleep, probe:891
    DATA #1 : unsigned integer, 8 bytes
    1337422590002
    DATA #2 : unsigned integer, 8 bytes
    1337422589907

    2012-05-19-17.16.30.021000+420 I1440F425 LEVEL: Warning
    PID : 3192 TID : 3556 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    HOSTNAME: TuanHa-PC
    EDUID : 3556 EDUNAME: db2wlmtm
    FUNCTION: DB2 UDB, base sys utilities, sqleTimedSleep, probe:891
    DATA #1 : unsigned integer, 8 bytes
    1337422590615
    DATA #2 : unsigned integer, 8 bytes
    1337422590020

    2012-05-19-17.17.33.169000+420 I1867F905 LEVEL: Warning
    PID : 3192 TID : 15440 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    APPHDL : 0-21145
    HOSTNAME: TuanHa-PC
    EDUID : 15440 EDUNAME: db2agent ()
    FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::requestMemory, probe:50
    MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory Available"
    DIA8300C A memory heap error has occurred.
    DATA #1 : String, 28 bytes
    Attempt to get memory failed
    DATA #2 : unsigned integer, 8 bytes
    1048576
    DATA #3 : unsigned integer, 8 bytes
    0
    DATA #4 : String, 7 bytes
    PRIVATE
    DATA #5 : unsigned integer, 8 bytes
    2815754240
    DATA #6 : unsigned integer, 8 bytes
    196608
    DATA #7 : unsigned integer, 8 bytes
    3392012288
    DATA #8 : unsigned integer, 8 bytes
    3392315392
    DATA #9 : unsigned integer, 8 bytes
    196608

    2012-05-19-17.17.33.170000+420 E2774F586 LEVEL: Warning
    PID : 3192 TID : 15440 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    APPHDL : 0-21145
    HOSTNAME: TuanHa-PC
    EDUID : 15440 EDUNAME: db2agent ()
    FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:10
    DATA #1 : <preformatted>
    Instance Memory Controller statistics.
    Instance Memory Automatic: Yes.
    Maximum size = 3312808 KB
    Current size = 3312512 KB
    Usage HWM = 3313984 KB
    Cached memory = 192 KB
    Cached DB memory = 0 KB

    2012-05-19-17.17.33.171000+420 I3362F463 LEVEL: Warning
    PID : 3192 TID : 15440 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    APPHDL : 0-21145
    HOSTNAME: TuanHa-PC
    EDUID : 15440 EDUNAME: db2agent ()
    FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:11
    DATA #1 : <preformatted>
    DBMS-DB2 - Current size : 540224 KB, HWM : 540608 KB, Reserved : 0 KB

    2012-05-19-17.17.33.171000+420 I3827F466 LEVEL: Warning
    PID : 3192 TID : 15440 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    APPHDL : 0-21145
    HOSTNAME: TuanHa-PC
    EDUID : 15440 EDUNAME: db2agent ()
    FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:12
    DATA #1 : <preformatted>
    FMP_RESOURCES - Current size : 22528 KB, HWM : 22528 KB, Reserved : 0 KB

    2012-05-19-17.17.33.172000+420 I4295F466 LEVEL: Warning
    PID : 3192 TID : 15440 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    APPHDL : 0-21145
    HOSTNAME: TuanHa-PC
    EDUID : 15440 EDUNAME: db2agent ()
    FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:13
    DATA #1 : <preformatted>
    PRIVATE - Current size : 2749760 KB, HWM : 2775680 KB, Reserved : 192 KB

    2012-05-19-17.17.33.173000+420 I4763F895 LEVEL: Warning
    PID : 3192 TID : 15440 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    APPHDL : 0-21145
    HOSTNAME: TuanHa-PC
    EDUID : 15440 EDUNAME: db2agent ()
    FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::requestMemory, probe:50
    MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory Available"
    DIA8300C A memory heap error has occurred.
    DATA #1 : String, 28 bytes
    Attempt to get memory failed
    DATA #2 : unsigned integer, 8 bytes
    1048576
    DATA #3 : unsigned integer, 8 bytes
    ....

    tuanhoanganh@yahoo.com