468,316 Members | 2,096 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,316 developers. It's quick & easy.

Restore From Offline Backup

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
2 6759
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
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.

Similar topics

3 posts views Thread by butatista | last post: by
4 posts views Thread by Hardy | last post: by
13 posts views Thread by Andy K | last post: by
reply views Thread by Mamatha | last post: by
5 posts views Thread by chow.justy | last post: by
3 posts views Thread by Maxim | last post: by
3 posts views Thread by aka | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.