db2stop taking time - DB2 Database

sandeep.iitk

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

Subscribe Post Reply

7213

stefan.albert

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

sandeep.iitk

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

w.l.fischer

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

stefan.albert

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

Similar topics

RUNSTATS taking looong time

by: Kumar | last post by:

Need urgent help... I am trying to make a change in one column (primary key). I dropped the primary key which dropped other 2-3 foreign keys referencing this column. I made the changes. ...

DB2 Database

Post Back Taking lot of Time

by: thomson | last post by:

Hi all, I have created a Web Application in my system, This application is accessed only in the local network. I have observed that in some machine When there is a post back it will be taking...

ASP.NET

db2stop

by: db2group88 | last post by:

Hi, we are using db2 V8.2 on windows, i try to deleted the data from the table but i change my mind and stop the process, then if i do db2stop, seems it is doing a rollback and take the same amount...

DB2 Database

ha_db2stop or db2stop?

by: Laurence | last post by:

Hi folks, The sentence "If you are an HACMPâ„¢ user, you must use the ha_db2stop command to stop DB2 instead of the db2stop command. If you use the db2stop command instead of the ha_db2stop...

DB2 Database

how to stop all database manager processes even after db2stop

by: zgh1970 | last post by:

Hi, Friends, I need to know how to stop all database process even after db2stop. How can I stop all database processes? I have finished upgraded our system test and UAT region from 32-bit to...

DB2 Database

select query is taking some time to return values

by: Kumarswamy | last post by:

Hi, I have a problem, i have used one condition in where clause ..... but it is taking some time to return values....... so my procedure is taking lot of time....... for the same table if i query...

Oracle Database

how to check for when a db2stop command is last issued

by: db2dbdba | last post by:

Hi All, How can I check for when a db2stop command is last issued? Or when a db2 force applications all command is last issued? Thanks in advance R

DB2 Database

db2stop and db2start require password in partition env

by: danfan46 | last post by:

Hi! I'm trying to set up a database instance on a prime Linux server, using db2 V9.5 with fixpack 1 applied. I issued db2set DB2RSHCMD=/usr/bin/ssh After adding 2 partitions, when issuing...

DB2 Database

Taking lot of time in loading user control on a web page

by: Gouri.Mahajan7 | last post by:

Hello, When I press the button on the web page I am loading the user control on the web page. This user control is invoking some methods of the web service. The control on the web page is loaded...

ASP.NET

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++