Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2014
    Posts
    2

    Question Unanswered: How stop DB" Partition db backup

    Hi,

    My Backup are running fine, but recently i 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 cant kill the backup

    kill -9 ID

    Please help
    Thank you

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    What happens when you issue this command:
    db2 list utilities show detail
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2014
    Posts
    2

    How stop DB Partition db backup

    Marcus_A What happens when you issue this command:
    db2 list utilities show detail



    db2 list utilities show detail
    returns the backup is still running

    Shows 4 threads (number of partitions) in my database.

Posting Permissions

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