469,299 Members | 2,088 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,299 developers. It's quick & easy.

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
Oct 23 '08 #1
5 6852
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...@gmail.com" <sandeep.i...@gmail.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
Oct 24 '08 #2
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
Oct 24 '08 #3
Ian
sa**********@gmail.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.

Oct 25 '08 #4
On Oct 23, 11:45*pm, "sandeep.i...@gmail.com" <sandeep.i...@gmail.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.
Oct 26 '08 #5
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...@mobileaudio.comwrote:
sandeep.i...@gmail.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.
Oct 27 '08 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Kumar | last post: by
1 post views Thread by thomson | last post: by
2 posts views Thread by db2group88 | last post: by
1 post views Thread by Laurence | last post: by
6 posts views Thread by Gouri.Mahajan7 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.