dba-db2.com - db2 performance tuning, DB2 tuning,db2 performance,sql tuning db2, DBA in DB2, DBA Scripts,DB2,DB2 consulting,DB2 consultant,DB2 architecture,DB2 training

How to terminate a DB2 backup

30 July,2014 by Tom Collins

Question: How can I terminate a DB2 backup ? Using   db2 list utilities I can see a BACKUP in progress , but how can I terminate the BACKUP from within DB2?

Answer:   To identify the process managing the BACKUP use this command

db2 list applications show detail | grep -i perform

From this result identify the process id related to the BACKUP. Force the application ID with this command. Check db2 list utilities to confirm if the backup is still running

Db2 force application (application_id)

Read More on DB2 backups

DB2 – Backup history

DB2 – check backup command and contents of a database

DB2 – Restore database from a ONLINE backup

 

Author: Rambler(http://www.dba-db2.com)

Share:

Posted by Tom Collins at 5:12 AM in Backup & Restore, Troubleshooting | Permalink | Comments (0) | TrackBack (0)

Searches: , , ,

Verify your Comment

Previewing your Comment

Posted by: |

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on How to terminate a DB2 backup

Comments are moderated, and will not appear until the author has approved them.

dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright