How to stop/force hanged on-line backup process?

grofaty · #1 (**permalink**) 03-18-08, 04:36

Hi,
on DB2 v8.1 fp11 on "Linux System z" the on-line backup has frozen. It looks like the disk where database tablespace was on was full.

I have cleaned out disk to make free disk space.

I have checked the tablespace status and it is in backup in progress status:

Code:

db2 list tablespaces show detail

 Tablespace ID                        = 2
 Name                                 = USERSPACE1
 Type                                 = System managed space
 Contents                             = Any data
 State                                = 0x0800
   Detailed explanation:
     Backup in progress

I have monitored utilities to see the on-line backup progress and it is just frozen on 86%.

Code:

db2 list utilities show detail

ID                               = 7
Type                             = BACKUP
Database Name                    = ISQ
Partition Number                 = 0
Description                      = online db
Start Time                       = 18.03.2008 06:45:12.525075
Throttling:
   Priority                      = Unthrottled
Progress Monitoring:
   Estimated Percentage Complete = 86
      Total Work                 = 4754586791 bytes
      Completed Work             = 4106422415 bytes
      Start Time                 = 18.03.2008 06:45:12.536922

Question:
1. how to make database to continue writing the on-line backup?
2. or how to stop/force on-line backup?

Thanks,
Grofaty

grofaty · #2 (**permalink**) 03-18-08, 09:35

Hi,
I have solved the problem. Quite interesting: db2 event monitoring was off but was created few week ago with autostart option. Four days ago syadmin rebooted Linux and DB2 autostarted, so event monitoring has turned on because of autostart option. Event monitoring has fulled disk space at the time on-line backup was working and on-line backup has frozen. When event monitoring was stopped db2 on-line backup process finished. It just looks like event monitoring and on-line backup was in some kind lock mode.

We tried to make an on-line backup manually and now it works fine. It just looks a chain reaction was triggered.
Thanks,
Grofaty

Internet Services

Web Development

Digital Marketing

Consumer Tech