Hi all,
We use DB2 v7.2 on AIX.
For backup we use the following command:
db2 backup database [db] online use tsm
We remove old backups from TSM as follows:
db2adutl delete full keep 14 database [db]
db2adutl delete logs between S[nnn].LOG and S[nnn].LOG database [db]
So we only need the last 14 backup's available on TSM.
Can you please tell me which values we have to use for NUM_DB_BACKUPS and
REC_HIS_RETENTN? The DB2 documentation is not very clear for us at this
point.
Our current values are:
Number of database backups to retain (NUM_DB_BACKUPS) = 14
Recovery history retention (days) (REC_HIS_RETENTN) = 366
We don't exactly understand the meaning of the REC_HIS_RETENTN value.
Best regards
Raoul Joemman
Martinair Holland
*****************************************************************
This e-mail and any attachment may contain confidential
and privileged material intended for the addressee only.
If you are not the addressee, you are notified that no part of
the e-mail or any attachment may be disclosed, copied or
distributed, and that any other action related to this e-mail
or attachment is strictly prohibited, and may be unlawful.
If you have received this e-mail by error, please notify the
sender immediately by return e-mail, and delete this message.
Martinair Holland N.V., its subsidiaries and/or its employees
shall not be liable for the incorrect or incomplete transmission
of this e-mail or any attachments, nor responsible for any
delay in receipt.
*****************************************************************
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
