Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    190

    Unanswered: Backup terminated

    I getting a read problem, which terminates my backup. I know which tablespace it is having a problem with, but how can I tell which logical volumn? Is there a AIX command to check a logical volumn for problems?
    I have added a section of the db2diag.log when the failure occurs.

    2004-06-22-07.50.11.877014 Instance:db2fudd Node:000
    PID:52132(db2agent (RECORDS)) Appid:0A011624.0A62.040618193846
    base_sys_utilities sqlesrsp Probe:9 Database:RECORDS

    RIDS/sqlesrsp MS/DB_BAD_FAT PRCS/9ffff fbf6


    2004-06-22-07.50.12.014217 Instance:db2fudd Node:000
    PID:173282(db2agent (RECORDS)) Appid:AC1D0B29.12F2.040622124512
    base_sys_utilities sqlesrsp Probe:9 Database:RECORDS
    0000 0000 0000 0000 ........


    2004-06-23-00.39.31.925603 Instance:db2fudd Node:000
    PID:54896(db2pfchr) Appid:none
    buffer_pool_services sqlbDirectRead Probe:820
    DIA9999E An internal error occurred. Report the following error code :
    "FFFFB06E".

    2004-06-23-00.39.31.958960 Instance:db2fudd Node:000
    PID:54896(db2pfchr) Appid:none
    buffer_pool_services sqlbDirectRead Probe:820

    Obj={pool:15;obj:0;type:15} State=x0 Parent={0;0}, EM=0, PP0=0

    Data TitleQLB_OBJECT_DESC PID:54896 Node:000
    000f 0000 0000 0000 0f00 0000 0000 0000 ................
    0000 0000 0000 0000 0000 0000 0000 0000 ................
    0000 0000 0000 0002 0000 0000 0000 0000 ................
    0000 1000 0000 0100 0000 0000 0000 0000 ................
    0000 0000 0000 0000 ........


    2004-06-23-00.39.32.251758 Instance:db2fudd Node:000
    PID:119348(db2bm.128778.0) Appid:none
    database_utilities sqlubreaddms Probe:9

    DiagData
    0054 ee00 .T..


    2004-06-23-00.39.32.393241 Instance:db2fudd Node:000
    PID:119348(db2bm.128778.0) Appid:none
    database_utilities sqlubreaddms Probe:10

    DiagData
    004e 1952 .N.R


    2004-06-23-00.39.32.551800 Instance:db2fudd Node:000
    PID:119348(db2bm.128778.0) Appid:none
    database_utilities sqlubreaddms Probe:11

    DiagData
    000f ..


    2004-06-23-00.39.32.693142 Instance:db2fudd Node:000
    PID:119348(db2bm.128778.0) Appid:none
    database_utilities sqlubreaddms Probe:12

    DiagData
    0000 00ff ....


    2004-06-23-00.39.32.951814 Instance:db2fudd Node:000
    PID:119348(db2bm.128778.0) Appid:none
    database_utilities sqlubreaddms Probe:13

    DiagData
    004e 1854 .N.T


    2004-06-23-00.39.33.210445 Instance:db2fudd Node:000
    PID:119348(db2bm.128778.0) Appid:none
    database_utilities sqlubreaddms Probe:8

    DiagData
    ffff b06e ...n


    2004-06-23-00.39.33.435618 Instance:db2fudd Node:000
    PID:119348(db2bm.128778.0) Appid:none
    database_utilities sqlubreaddms Probe:8

    DiagData
    ffff fc7a ...z


    2004-06-23-00.39.33.635659 Instance:db2fudd Node:000
    PID:119348(db2bm.128778.0) Appid:none
    database_utilities sqlubreaddms Probe:2208

    ffff fc7a ...z


    2004-06-23-00.40.09.800764 Instance:db2fudd Node:000
    PID:128778(db2agent (RECORDS)) Appid:*LOCAL.db2fudd.040623000002
    database_utilities sqlubcka Probe:0 Database:RECORDS

    Backup terminated.


    Thanks

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Is this DIAGLEVEL 4? I believe it should spit out a path at that level.
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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