Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Posts
    27

    Unanswered: database server is hanging URGENT ?????

    Hi ALL,

    db2 version 8 sun 5.8
    I need help from all.
    My database server is hanging I can not issue any db2 command. no db2 connect to , no db2 get db cfg ...

    1>The system and virtual memory is ok 1.5GB still available.
    2>Logs are archived, log dir is not full.

    Unfortunately, I deleted the dumpfiles just a few minutes before this issue came.

    Any one get problem with database server hanging. Please suggest me any solution because many problems cause database hanging not only one.

    Please guide me to analyze that to get the root CAUSE.

    I appreciate 10000 times. I am working on production servers.

    Thx much

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by db2kevin
    .

    Unfortunately, I deleted the dumpfiles just a few minutes before this issue came.
    ...
    Please guide me to analyze that to get the root CAUSE.
    Chances are, you've deleted one too many "dumpfile", whatever it is.

    What do you see in db2diag.log?

  3. #3
    Join Date
    Jun 2006
    Posts
    27
    There was two errors that relate to store procedures but I can fix it late on by dropping and recreating them.


    2006-07-02-22.00.33.784184-240 I1177C335 LEVEL: Error
    PID : 5302 TID : 1 PROC : db2bp
    INSTANCE: db2clms1 NODE : 000
    FUNCTION: DB2 UDB, database utilities, sqlubConnectDatabase, probe:1252
    DATA #1 : Hexdump, 10 bytes
    0x00157FA4 : FFFF FC0B 4244 5444 4200 ....BDTDB.

    2006-08-08-17.15.08.375813-240 I16073268C435 LEVEL: Error
    PID : 26914 TID : 1 PROC : db2agent (CLAIMS) 0
    INSTANCE: db2clms1 NODE : 000 DB : CLAIMSDB
    APPHDL : 0-469 APPID: A180EFB3.A333.01E498200524
    FUNCTION: DB2 UDB, access plan manager, sqlra_describe_static, probe:50
    RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
    "SQLCA has already been built"
    2006-08-28-06.22.44.091230-240 I3560713C304 LEVEL: Error
    PID : 17976 TID : 1 PROC : db2bp
    INSTANCE: db2cli1 NODE : 000
    FUNCTION: DB2 UDB, common communication, sqlcctcpconnr, probe:110
    MESSAGE : DIA3202C The TCP/IP call "connect" returned an errno="146".

    2006-08-29-12.45.41.918397-240 I3561018C304 LEVEL: Error
    PID : 12758 TID : 1 PROC : db2bp
    INSTANCE: db2cli1 NODE : 000
    FUNCTION: DB2 UDB, common communication, sqlcctcpconnr, probe:110
    MESSAGE : DIA3202C The TCP/IP call "connect" returned an errno="146".

Posting Permissions

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