I am not sure on 7.2 , in 8.* there is a quiesce database command.
Either way, I have a program that I have used for years to backup udb
databases written in perl that is not affected by users. Some of my
databases support hundreds of concurrent connections with very fast
connection retry times.
I do a db2 force, then a db2 deactivate, then issues the backup command.
Also - maybe I missed a note but are online backups an option?
-----Original Message-----
From: Brian Sandmann
[mailto:db2udbdba-ezmlmshield-x71406414.[Email address protected]
Sent: Monday, February 28, 2005 11: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