Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup tablespace

Status
Not open for further replies.

Ruvera

Programmer
May 8, 2002
12
RU
I want to make backup of tablespace TTT (database BBB).
Wrote:
"db2 backup database BBB tablespace (TTT) online to C:\backup without prompting"
I receive the message:
"DBA1136
A backup at the tablespace level cannot be perfomed because the datebase is not enable for forward recovery."

In the documentation it is written, that it is necessary to change a configuration of database: "LOGRETAIN must be set to YES in order to perform tablespace-level backups".
I have changed a configuration database, but I receive the same mistake (DBA1136 ).
Why?


 
Try setting LOGRETAIN to ON rather than YES

UPDATE DATABASE CONFIGURATION FOR database-alias USING LOGRETAIN ON


 
Make sure you perform a db2stop and db2start. This is required when updating the database configuration files.

David
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top