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

    Unanswered: DIA3727C The database has been marked as being damaged

    hi to all
    please tell y it is comming .
    since 3 days daily morning this error comming.
    pl tell y it is comming ? how to rectify this?
    i done db2dart..

    DIA3727C The database has been marked as being damaged

    pl tell me y it is comming...

  2. #2
    Join Date
    Jun 2003
    Posts
    77

    Re: DIA3727C The database has been marked as being damaged

    Hi,
    I think this message comes when your database is crashed.
    DB2 tries a recovery process but if that too has failed, then the database is marked as damaged.
    db2dart generates a report named databasename.RPT at the location from where the db2dart command is issued.
    You can Open this report with wordpad and take a look at this report . See what exactly is damaged.
    Can you post what is the error in your .rpt file?



    Are you still able to use it?
    What is your
    Originally posted by jagan_5378
    hi to all
    please tell y it is comming .
    since 3 days daily morning this error comming.
    pl tell y it is comming ? how to rectify this?
    i done db2dart..

    DIA3727C The database has been marked as being damaged

    pl tell me y it is comming...

  3. #3
    Join Date
    Jun 2003
    Posts
    77
    What is your version of DB2 and platform?

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Jagan had posted the same question last week .... The other thread is at

    http://www.dbforums.com/showthread.php?threadid=974804


    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Nov 2003
    Posts
    68
    hi to all

    after run the db2dart i got two files TESTKALA.RPT ,DART.ERR
    in TESTKALA.RPT file
    last lines
    Tablespace inspection phase start. Pool: 3
    This is a temporary table space. Nothing to inspect.
    Tablespace inspection phase end.

    Database inspection phase end.

    ______________________________________

    The requested DB2DART processing has completed successfully!
    All operation completed without error;
    no problems were detected in the database.
    ______________________________________

    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




    this is the DART.ERR file


    === ===
    === Error events occurred during DART processing! ===
    === ===
    === This file will list the location of each error ===
    === event. Note that some error events are always ===
    === generated under normal processing to mark ===
    === conditions such as EOF, or file not found. ===
    === ===
    === Current date and time: ===
    Sat Dec 20 12:34:28 2003 IST
    === ===
    ================================================== ========================


    File Line DART Error DB Engn Function Called
    Number (Dec) Error(HEX)
    ================================================== ========================
    drtpool.C 1015 -75 1 sqloopenp( poolTable
    drtpool.C 1037 -75 1 sqloopenp( poolTable
    drtpool.C 1097 -75 FFFFF609
    drtpool.C 1109 -75 FFFFF609
    drtbpf.C 583 -75 FFFFF609
    drtbpf.C 598 -75 FFFFF609
    drtrec.C 201 20 0 DART_ERR_NOMORE_RECS
    drtsys.C 2530 20 0 DartGetNextObjRec( p
    "DART.ERR" 43L, 2883C
    drtsys.C 2530 20 0 DartGetNextObjRec( p
    drtdbmgr.C 1507 -75 1 sqloopenp( poolTable
    drtrec.C 201 20 0 DART_ERR_NOMORE_RECS
    drtsys.C 1189 20 0 DartGetNextObjRec( p
    drtsys.C 1286 -68 0 DART_ERR_OBJ_NOT_FOU
    drtpool.C 2610 -68 0 DartGetNextSMSPoolOb
    drtpool.C 1746 -68 0 DartGetNextPoolObjec
    drtrec.C 201 20 0 DART_ERR_NOMORE_RECS
    drtobtbl.C 201 20 0 DartGetNextObjRec( p
    drtrec.C 201 20 0 DART_ERR_NOMORE_RECS
    drtobj.C 143 20 0 DartGetNextObjRec( p
    drtobj.C 348 -68 0 DART_ERR_OBJ_NOT_FOU
    drtpool.C 2990 -68 0 DartGetNextDMSPoolOb
    drtrec.C 201 20 0 DART_ERR_NOMORE_RECS
    drtobj.C 143 20 0 DartGetNextObjRec( p
    drtobj.C 348 -68 0 DART_ERR_OBJ_NOT_FOU
    drtpool.C 2668 -68 0 DartGetNextDMSPoolOb
    drtpool.C 1746 -68 0 DartGetNextPoolObjec
    drtdbmgr.C 1524 -75 FFFFF609
    ~

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Did you 'shutdown' the database before you did db2dart ....

    Cheers
    Sathyaram

    Originally posted by jagan_5378
    hi to all

    after run the db2dart i got two files TESTKALA.RPT ,DART.ERR
    in TESTKALA.RPT file
    last lines
    Tablespace inspection phase start. Pool: 3
    This is a temporary table space. Nothing to inspect.
    Tablespace inspection phase end.

    Database inspection phase end.

    ______________________________________

    The requested DB2DART processing has completed successfully!
    All operation completed without error;
    no problems were detected in the database.
    ______________________________________

    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




    this is the DART.ERR file


    === ===
    === Error events occurred during DART processing! ===
    === ===
    === This file will list the location of each error ===
    === event. Note that some error events are always ===
    === generated under normal processing to mark ===
    === conditions such as EOF, or file not found. ===
    === ===
    === Current date and time: ===
    Sat Dec 20 12:34:28 2003 IST
    === ===
    ================================================== ========================


    File Line DART Error DB Engn Function Called
    Number (Dec) Error(HEX)
    ================================================== ========================
    drtpool.C 1015 -75 1 sqloopenp( poolTable
    drtpool.C 1037 -75 1 sqloopenp( poolTable
    drtpool.C 1097 -75 FFFFF609
    drtpool.C 1109 -75 FFFFF609
    drtbpf.C 583 -75 FFFFF609
    drtbpf.C 598 -75 FFFFF609
    drtrec.C 201 20 0 DART_ERR_NOMORE_RECS
    drtsys.C 2530 20 0 DartGetNextObjRec( p
    "DART.ERR" 43L, 2883C
    drtsys.C 2530 20 0 DartGetNextObjRec( p
    drtdbmgr.C 1507 -75 1 sqloopenp( poolTable
    drtrec.C 201 20 0 DART_ERR_NOMORE_RECS
    drtsys.C 1189 20 0 DartGetNextObjRec( p
    drtsys.C 1286 -68 0 DART_ERR_OBJ_NOT_FOU
    drtpool.C 2610 -68 0 DartGetNextSMSPoolOb
    drtpool.C 1746 -68 0 DartGetNextPoolObjec
    drtrec.C 201 20 0 DART_ERR_NOMORE_RECS
    drtobtbl.C 201 20 0 DartGetNextObjRec( p
    drtrec.C 201 20 0 DART_ERR_NOMORE_RECS
    drtobj.C 143 20 0 DartGetNextObjRec( p
    drtobj.C 348 -68 0 DART_ERR_OBJ_NOT_FOU
    drtpool.C 2990 -68 0 DartGetNextDMSPoolOb
    drtrec.C 201 20 0 DART_ERR_NOMORE_RECS
    drtobj.C 143 20 0 DartGetNextObjRec( p
    drtobj.C 348 -68 0 DART_ERR_OBJ_NOT_FOU
    drtpool.C 2668 -68 0 DartGetNextDMSPoolOb
    drtpool.C 1746 -68 0 DartGetNextPoolObjec
    drtdbmgr.C 1524 -75 FFFFF609
    ~
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  7. #7
    Join Date
    Nov 2003
    Posts
    68
    hi sir
    i done like this
    db2 force application all
    db2stop
    db2start
    db2dart database.
    like this i done that

Posting Permissions

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