How Stop DB2 db BACKUP

[Former Member]

Hi,

The system Runs in DB2 DB, and actually need help with this topic.

My Backup are running fine, but recently, have a problem with operation time and my scheduled online backup, my system got slow, so now i need to know how to stop my online backup, because sometimes we need  reschedule it later.

My database are in DB2 and have Partitions, the backup its online and with compress, so the instruction i use its next:

/db2_software/bin/db2 -v backup db $db2sid on all dbpartitionnums online use TSM with 2 buffers buffer 1024 compres include logs >> $LOG/$DB2SID.log

Now i need to stop that on line backup, i am unable to see it in application level
1. I try something like this, but doesn't work beacuase i can't know whats the process id, the command does not return results

db2 list applications show detail | grep -i backup
db2 list applications show detail | grep -i perform

This command does nor return results, so i can't run a force application

db2 "force application (25322)"

2. I tried from OS, but theres a secuence and i can't determine how to kill that process

ps -eaf | grep db2sysc

  db2Database  8519880  8388826   0 05:16:05      - 17:20 db2sysc 2
  db2Database  8585416  8454342   0 05:16:05      - 16:43 db2sysc 1
  db2Database  6160876  4653414 138 05:16:05      - 169:29 db2sysc 0
  db2Database  6947078  9830400   0 05:16:07      - 16:25 db2sysc 3
  db2Database  7536944  7668022   0 05:16:08      - 16:40 db2sysc 4

so i can't kill the backup

kill -9 ID

Please help
Thank you

[Ambarish]

Hi,

One option is to restart datbase instance however it needs a wise decision as it will have an impact on business operations (for production system DB).

Are you using database tools like TSM, Veritas,or Legato etc? In that case killing (using the "force application" command) the backup process on db2 may result in hung database. It is not recommended!! .

Thanks,

Ambarish