Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004

    Unhappy Unanswered: error on backup : need help :(

    I'm using Control Center and make a backup schedule. I have a problem about backup schedule can be done. I'm not what is the root cause of this problem.

    Here are the weird things that I get about the database.
    1. Checking from Journal, Running jobs push button, I see Backup jobs running in the list and they are not removed in the list for a long time.

    2. Checking in the DB2 Diagnostic Log (db2diag.log) It has the error about...
    String Title:sqle_panic: PID:744 Node:000

    2004-09-07- InstanceB2 Node:000
    PID:1316(db2syscs.exe) TID:1960 Appid:*LOCAL.DB2.040907145432
    database_utilities sqlubcka Probe:0 DatabasePTDB

    Backup terminated.

    2004-09-07- InstanceB2 Node:000
    PID:1316(db2syscs.exe) TID:1956 Appid:none
    buffer_pool_services sqlbcres Probe:25

    c700 0000 ว...

    2004-09-07- InstanceB2 Node:000
    PID:1316(db2syscs.exe) TID:1956 Appid:none
    buffer_pool_services sqlbcres Probe:1100
    DIA3726C A invalid page checksum was found for page "".


    Here is the current server configuration
    1. Windows2000 Server
    2. DB2 Version 6
    3. Using Table Space managed by System (SMS)
    4. Database size when backup is about 300 MB ( text only without BLOB)

    Sorry for the quite long content, I 'm not sure what is the real problem on this database. So, i'm asking for help on this. Thank you so much ...


  2. #2
    Join Date
    Aug 2001
    Check your db2 database using the db2dart command ... Looks like one of your database pages may be corrupt

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

  3. #3
    Join Date
    Sep 2004
    Thank you ...
    I used db2dart MYDB /DB . The result is

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

    Complete DB2DART report found in: MYDB.RPT

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

  4. #4
    Join Date
    Sep 2004

    Thumbs down

    My Running jobs for backup schedule is pending on the queue. Does anyone know how to remove it?

Posting Permissions

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