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




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