db2stop taking time

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sandeep.iitk@gmail.com
    #1

    db2stop taking time

    Hi All,

    When i am trying to take offline backup of my production db .. it is
    taking more time in db2stop command (around 15 min.) while earlier max
    was 2 mins. what might be the reason for this delay.

    To stop the db I am using following sequence of commands:-
    db2set db2comm=
    db2 force application all
    db2stop force
    db2_kill
    db2start
    db2force application all
    backup command

    Please tell me if I have to use some other command or remove some ...

    Thanks
    Sandy
    Tags: None
    • stefan.albert
      #2
      Re: db2stop taking time

      why do you want to stop the DB anyway?

      a force and deactivate should be OK for an offline backup


      On Oct 23, 11:45 pm, "sandeep.i...@g mail.com" <sandeep.i...@g mail.com>
      wrote:
      Hi All,
      >
      When i am trying to take offline backup of my production db .. it is
      taking more time in db2stop command (around 15 min.) while earlier max
      was 2 mins. what might be the reason for this delay.
      >
      To stop the db I am using following sequence of commands:-
      db2set db2comm=
      db2 force application all
      db2stop force
      db2_kill
      db2start
      db2force application all
      backup command
      >
      Please tell me if I have to use some other command or remove some ...
      >
      Thanks
      Sandy

        Comment

        • sandeep.iitk@gmail.com
          #3
          Re: db2stop taking time

          wanted to stop DB for taking offline backup.
          just to confirm these 3 command will be suffice

          db2set db2comm=
          db2 force application all
          db2 deactivate db


          Please suggest
          thanks
          sandy

            Comment

            • Ian
              #4
              Re: db2stop taking time

              sandeep.iitk@gm ail.com wrote:
              wanted to stop DB for taking offline backup.
              just to confirm these 3 command will be suffice
              >
              db2set db2comm=
              No reason to do this.
              db2 force application all
              db2 deactivate db
              That's fine.

                Comment

                • w.l.fischer@googlemail.com
                  #5
                  Re: db2stop taking time

                  On Oct 23, 11:45 pm, "sandeep.i...@g mail.com" <sandeep.i...@g mail.com>
                  wrote:
                  Hi All,
                  >
                  When i am trying to take offline backup of my production db .. it is
                  taking more time in db2stop command (around 15 min.) while earlier max
                  was 2 mins. what might be the reason for this delay.
                  >
                  To stop the db I am using following sequence of commands:-
                  db2set db2comm=
                  db2 force application all
                  db2stop force
                  db2_kill
                  db2start
                  db2force application all
                  backup command
                  >
                  Please tell me if I have to use some other command or remove some ...
                  >
                  Thanks
                  Sandy
                  Did you change LOGFILSIZ, LOGPRIMARY, CHNGPGTHRES(?), SOFTMAX?

                  Not sure if I got all relevant parameters, but your database might
                  need a while before it gets into a consistent state. The force
                  applications command is asynchronous, so there may even be a rollback
                  active, if you had working applications during that time.

                    Comment

                    • stefan.albert
                      #6
                      Re: db2stop taking time

                      There is a reason NOT to do this - if you use DPF (a partitioned DB
                      environment).
                      I suppose, that db2_all would fail...?


                      On Oct 25, 6:19 am, Ian <ianb...@mobile audio.comwrote:
                      sandeep.i...@gm ail.com wrote:
                      wanted to stop DB  for taking offline backup.
                      just to confirm these 3 command will be suffice
                      >
                      db2set db2comm=
                      >
                      No reason to do this.
                      >
                      db2 force application all
                      db2  deactivate db
                      >
                      That's fine.

                        Comment

                        Previous template Next
                        Working...