Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2006
    Posts
    8

    Unanswered: DB2 is hanged, only can connect

    db2 info :
    ---------------------
    DB21085I Instance "hbbiinst" uses "64" bits and DB2 code release "SQL08025"
    Informational tokens are "DB2 v8.1.0.112", "s060429", "U807382", and FixPak
    "12".
    Product is installed at "/opt/IBM/db2/V8.1".

    -----------------------
    sys info:
    SunOS 5.8 Generic_117350-28 sun4u sparc SUNW,Sun-Fire-15000

    64 CPU,128 G mem , DB2 16 nodes

    =========================================
    I think my db2 is hanged ,We can only connect it .But can not do any query ,and can not disconnect also. We input the db2 connect reset command to disconect from db2 but the db2cmd can not return .

    We user db2 force command to kill the apps,the db2cmd return success.But infact ,the apps are still exist.We try many time to kill them ,but is seems the db2 force did not work as we wish.

    =========================
    This is the db2diag.log's infomation:
    (2006-10-01 10:05:02) bio(4416408)
    2006-10-01-10.00.13.635436+480 I2177947423A468 LEVEL: Severe
    PID : 12875 TID : 1 PROC : db2agntp (DWDB) 0
    INSTANCE: hbbiinst NODE : 000 DB : HBBIDB
    APPHDL : 4-481 APPID: *N4.hbbiinst.060930211842
    FUNCTION: DB2 UDB, buffer dist serv, sqkd_bds_buffer_table::getNextReply, probe:20
    RETCODE : ZRC=0x80590003=-2141650941=SQLKF_INTRP "FCM Interrupt"
    DIA8003C The interrupt has been received.

    2006-10-01-10.00.13.697800+480 I2177947892A469 LEVEL: Severe
    PID : 12875 TID : 1 PROC : db2agntp (DWDB) 0
    INSTANCE: hbbiinst NODE : 000 DB : HBBIDB
    APPHDL : 4-481 APPID: *N4.hbbiinst.060930211842
    FUNCTION: DB2 UDB, buffer dist serv, sqkd_bds_buffer_table::getNextBuffer, probe:10
    RETCODE : ZRC=0x80590003=-2141650941=SQLKF_INTRP "FCM Interrupt"
    DIA8003C The interrupt has been received.

    ============================================
    pls. help me ,thk. very much

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I would suggest to open a PMR with IBM.

    Andy

  3. #3
    Join Date
    Apr 2006
    Posts
    8
    what does PMR mean?

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    It means that you contact IBM DB2 support and open a problem ticket. I do not know what "PMR" means in IBMese.

    Andy

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I believe that PMR is Problem Management Record or Report. You will have to be entitled to support in order to open a PMR. Usually this mean you need a customer number or passport advantage account.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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