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

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









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