By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,721 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

Restore From Offline Backup

P: n/a
I have an SAP development system running on Linux. It is not a critical
system, but I would like a restore-able backup. I have taken an offline
backup, but I am unable to restore it.

I am guessing I need to quiesce the database somehow and get it into an
offline state. What are commands to do so in db2?

This is what I get when Itry to restore.

db2 => restore database si4 from /db2/db2si4/backups taken at 2005110222
replace existing
SQL1035N The database is currently in use. SQLSTATE=57019
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
The best place to find information about commands is the Command
Reference manual. You're on the right track with QUIESCE, which is the
command you need to use.

QUIESCE may not free up your database from active users. Users having
SYSADM, DBADM, SYSMAINT or SYSCTRL authority will still be able to
connect to it. When you are finished with the restore, You will need to
use the UNQUIESCE command to allow users to connect again.
Phil Sherman

Buck Turgidson wrote:
I have an SAP development system running on Linux. It is not a critical
system, but I would like a restore-able backup. I have taken an offline
backup, but I am unable to restore it.

I am guessing I need to quiesce the database somehow and get it into an
offline state. What are commands to do so in db2?

This is what I get when Itry to restore.

db2 => restore database si4 from /db2/db2si4/backups taken at 2005110222
replace existing
SQL1035N The database is currently in use. SQLSTATE=57019

Nov 12 '05 #2

P: n/a
You don't need to QUIESCE the database. Try "db2 force applications
all" and then restore. If you've used activate db command to
activate the database, then you will also need to deactivate db (after
forcing off apps) and then restore. If you still get this error, you
may want to do a db2stop/db2start and restore.

Keith Ponnapalli
adv_dba at yahoo dot com
IBM Certified Advanced Database Administrator - DB2 UDB V8.1 for Linux,
UNIX, and Windows
INFORMIX Certified Database Administrator
Buck Turgidson wrote:
I have an SAP development system running on Linux. It is not a critical
system, but I would like a restore-able backup. I have taken an offline
backup, but I am unable to restore it.

I am guessing I need to quiesce the database somehow and get it into an
offline state. What are commands to do so in db2?

This is what I get when Itry to restore.

db2 => restore database si4 from /db2/db2si4/backups taken at 2005110222
replace existing
SQL1035N The database is currently in use. SQLSTATE=57019


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.