Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    68

    Unanswered: DIA3727C The database has been marked as being damaged.

    hi to all
    we are using db2 7.2 on linux 6.2
    pl tell me y this error is comming
    some times database automatically disconnected.

    2003-12-17-10.16.58.127106 Instance:db2inst1 Node:000
    PID:3759(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031217044636
    base_sys_utilities sqledbcu Probe:33 Database:TESTKALA

    Number of local applications forced: 1200 0000 ....



    2003-12-17-10.16.58.166148 Instance:db2inst1 Node:000
    PID:1085(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031217042823
    buffer_pool_services sqlbTerminateAgent Probe:837 Database:TESTKALA
    DIA3727C The database has been marked as being damaged.

    ZRC=0xFFFFE11A

    2003-12-17-10.16.58.167736 Instance:db2inst1 Node:000
    PID:1085(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031217042823
    base_sys_utilities sqleTermDbConnect Probe:5 Database:TESTKALA
    DIA3727C The database has been marked as being damaged.

    ZRC=0xFFFFE11A

    2003-12-17-10.17.11.866300 Instance:db2inst1 Node:000
    PID:3754(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031217044711

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: DIA3727C The database has been marked as being damaged.

    Shut down the database and use the db2dart tool to check the integrity of the database

    Cheers
    Sathyaram

    Originally posted by jagan_5378
    hi to all
    we are using db2 7.2 on linux 6.2
    pl tell me y this error is comming
    some times database automatically disconnected.

    2003-12-17-10.16.58.127106 Instance:db2inst1 Node:000
    PID:3759(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031217044636
    base_sys_utilities sqledbcu Probe:33 Database:TESTKALA

    Number of local applications forced: 1200 0000 ....



    2003-12-17-10.16.58.166148 Instance:db2inst1 Node:000
    PID:1085(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031217042823
    buffer_pool_services sqlbTerminateAgent Probe:837 Database:TESTKALA
    DIA3727C The database has been marked as being damaged.

    ZRC=0xFFFFE11A

    2003-12-17-10.16.58.167736 Instance:db2inst1 Node:000
    PID:1085(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031217042823
    base_sys_utilities sqleTermDbConnect Probe:5 Database:TESTKALA
    DIA3727C The database has been marked as being damaged.

    ZRC=0xFFFFE11A

    2003-12-17-10.17.11.866300 Instance:db2inst1 Node:000
    PID:3754(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031217044711
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Nov 2003
    Posts
    68
    thank u for u r immidate reply.
    i done above step.
    next what i have to do
    Data inspection phase end.

    Table inspection end.

    Tablespace inspection phase end.


    Tablespace inspection phase start. Pool: 3
    This is a temporary table space. Nothing to inspect.
    Tablespace inspection phase end.

    Database inspection phase end.

    ______________________________________

    DB2DART Processing completed with warning(s)!
    Warning(s) detected during processing.
    ______________________________________

    Complete DB2DART report found in: TESTKALA.RPT

    _______ D A R T P R O C E S S I N G C O M P L E T E ___

    TESTKALA.RPT file data
    Action option: DB

    Warning: The database state is not consistent.
    Connecting to Buffer Pool Services...

    Database inspection phase start.

    Tablespace file inspection phase start.
    Loading tablespace files.
    Inspecting next tablespace and associated containers.
    Inspecting next tablespace and associated containers.
    Inspecting next tablespace and associated containers.
    Inspecting next tablespace and associated containers.
    4 tablespaces were identified and their containers checked.
    Tablespace file inspection phase end.

Posting Permissions

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