Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    306

    Question Unanswered: Instance failure during scheduled backup

    DB2 8.2 Win2003

    I'm experiencing some unexplained instance failures on a soon to go live production DB, which is obviously of great concern.

    The latest failure was during an overnight scheduled backup with quiesce.

    Basically db2diag.log shows that the database encountered some errors around the same time as the backup and eventually issued a dbstop command.

    Some highlights:
    .
    .
    .
    2006-02-23-23.45.08.601000+600 E982259H405 LEVEL: Error
    PID : 2724 TID : 6024 PROC : db2syscs.exe
    INSTANCE: SOL NODE : 000 DB : TERRA
    APPHDL : 0-1118 APPID: *LOCAL.SOL.060223134517
    FUNCTION: DB2 UDB, base sys utilities, sqleDatabaseQuiesce, probe:2
    MESSAGE : ADM7507W Database quiesce request has completed successfully.
    .
    .
    .
    2006-02-23-23.45.09.945000+600 I982666H481 LEVEL: Error
    PID : 2724 TID : 2372 PROC : db2syscs.exe
    INSTANCE: SOL NODE : 000 DB : TERRA
    APPHDL : 0-342 APPID: *LOCAL.SOL.060223134516
    FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:1
    MESSAGE : Error in agent servicing application with coor_node:
    DATA #1 : Hexdump, 2 bytes
    0x27F557E6 : 0000
    .
    .
    .
    .
    2006-02-23-23.45.10.070000+600 I987193H171 LEVEL: Severe
    PID:2724 TID:2372 NODE:000 Title: **** DRDA ASCB ****
    Dump File:C:\PROGRA~1\IBM\SQLLIB\SOL\27242372.000
    .
    .
    .
    2006-02-23-23.42.47.415000+600 I981436H430 LEVEL: Severe
    PID : 2724 TID : 6024 PROC : db2syscs.exe
    INSTANCE: SOL NODE : 000 DB : TERRA
    APPHDL : 0-1083 APPID: C0A80A71.A405.00E5C3134303
    FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
    RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
    "External Comm error"
    .
    .
    .
    2006-02-23-23.45.10.820000+600 I991422H489 LEVEL: Warning
    PID : 2724 TID : 2372 PROC : db2syscs.exe
    INSTANCE: SOL NODE : 000 DB : TERRA
    APPHDL : 0-342 APPID: *LOCAL.SOL.060223134516
    FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
    MESSAGE : Bringing down all db2fmp processes as part of db2stop
    DATA #1 : Hexdump, 4 bytes
    0x27F5FC90 : 0000 0000

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    There have been quite a few problem previously with the quiesce command. If you are not on at least FP10, I would upgrade.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jul 2004
    Posts
    306
    I'm on SP8 at the moment, I'll look at upgrading.
    I haven't had any problems with quiesce until now, I did have a previous occassion where the instance shut down when the backup ran to a drive which had run out of space and under SP3 I had problems where some SQL statements killed the instance.

    This is all making me a little concerned, are these problems widespread (it seems many SP's have a quirk that allows instance shutdown) or is it my particular situation?

Posting Permissions

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