AUTO_DEL_REC_OBJ

This database configuration parameter specifies whether database log files, backup images, and load copy images should be deleted when their associated recovery history file entry is pruned.

If you set the auto_del_rec_obj database configuration parameter to ON, then the database manager will also delete the corresponding physical log files, backup images, and load copy images when it prunes the history file.

$ db2 get db cfg for SAMPLE |grep AUTO_DEL_
Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) = OFF

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: