AW: Backup script fails with SQL1035N - The database currently in use SQLSTATE=57019

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


DB2 & UDB email list listserv db2-l LazyDBA home page