You need not go through stopping the database engine at all.
Particularly if you are in Fixpack-3, the db2stop will hang
and you need to kill the child process of db2stop process.
This killing sometimes crashes the database. This has happened
to us.
If you are doing db2stop, db2start and backup in a a script,
then you may not succeed.
Hence best solution would be to force all applications twice.
Then start your backup command.
Hope this helps
Partha
-----Original Message-----
From: Brian Sandmann
[mailto:db2udbdba-ezmlmshield-x71406414.[Email address protected]
Sent: Monday, February 28, 2005 10:24 AM
To: LazyDBA Discussion
Subject: RE: Backup script fails with SQL1035N - The database currently
in use SQLSTATE=57019
Using 7.2, but I thought the quiesce could only be used for a table, not an
entire db.
-----Original Message-----
From: Matt Devlin
[mailto:db2udbdba-ezmlmshield-x84774479.[Email address protected]
Sent: Monday, February 28, 2005 11:23 AM
To: LazyDBA Discussion
Subject: RE: Backup script fails with SQL1035N - The database currently
in use SQLSTATE=57019
What Version of UDB? What about using the quiesce database command?
-----Original Message-----
From: Domnick Wolfgang
[mailto:db2udbdba-ezmlmshield-x55148046.[Email address protected]
Sent: Monday, February 28, 2005 11:05 AM
To: LazyDBA Discussion
Subject: AW: Backup script fails with SQL1035N - The database currently
in use SQLSTATE=57019
I'm afraid all this won't help very much if another user makes a connect
to the database before the backup starts. If you have a lot of users and
can prevent this then you must write a skript, which removes all other
users the right to connect to the database. After the backup you have to
run another skript to return this right to the users.
Mit freundlichen Grüßen / Kind Regards
Wolfgang Domnick
Vitanet GmbH
W.[Email address protected]
www.vitanet.de
-----Ursprüngliche Nachricht-----
Von: mcannon [mailto:db2udbdba-ezmlmshield-x45402769.[Email address
protected]
Gesendet: Montag, 28. Februar 2005 16:52
An: LazyDBA Discussion
Betreff: RE: Backup script fails with SQL1035N - The database currently
in use SQLSTATE=57019
Quote:
"db2stop
db2start
db2backup database prd use tsm open 2 sessions"
Answer from me was to use stop force instead of just stop.... This will
force all applications and connections on a stop....
"db2stop force
db2start
db2backup database prd use tsm open 2 sessions"
|---------+--------------------------------------------------------->
| | "Hutchins Robert " |
| | <db2udbdba-ezmlmshield-x57442500.[Email Address Removed] | azyDBA.com> |
| | |
| | |
| | 02/28/2005 10:34 AM |
| | |
|---------+--------------------------------------------------------->
>-----------------------------------------------------------------------
--------------------|
|
|
| To: "LazyDBA Discussion" <[Email address protected]
|
| cc:
|
| Subject: RE: Backup script fails with SQL1035N - The database
currently in use |
| SQLSTATE=57019
|
>-----------------------------------------------------------------------
--------------------|
The database needs to be up to be backed up.
-----Original Message-----
From: mcannon
[mailto:db2udbdba-ezmlmshield-x85115378.[Email
address protected]
Sent: Mon 2/28/2005 10:25 AM
To: LazyDBA Discussion
Cc:
Subject: Re: Backup script fails with SQL1035N - The
database
currently in use SQLSTATE=57019
You could use
db2 stop force Command....
|---------+--------------------------------------------------------->
| | "Brian Sandmann "
|
| |
<db2udbdba-ezmlmshield-x34213196.[Email Address Removed] | | azyDBA.com>
|
| |
|
| |
|
| | 02/28/2005 10:05 AM
|
| |
|
|---------+--------------------------------------------------------->
>-----------------------------------------------------------------------
--------------------|
|
|
| To: "LazyDBA Discussion" <[Email address
protected] |
| cc:
|
| Subject: Backup script fails with SQL1035N - The
database currently in use |
| SQLSTATE=57019
|
>-----------------------------------------------------------------------
--------------------|
My backup script failed with SQL1035N - The database
currently
in use
SQLSTATE=57019. My script is as follows.
db2stop
db2start
db2backup database prd use tsm open 2 sessions
Instead of using db2stop/db2start should I use the "force
apllications all"
command or the "teminate" command. What the difference
between db2stop,
terminate, and force applications all?
Thanks in advance,
sandmann
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page