Hi,
I'm a mainframer, new to DB2 on Solaris v6.1, and I'm establishing an infrastructure for our fledgling DB2/Solaris environment. Until now we have not been running the PRUNE HISTORY command, although we do have rec_his_retentn and num_db_backups set to reasonable limits.
'LIST HISTORY REORG ALL FOR db' gives reorg data going back further than my screen buffer can hold (probably several months), so I assume that rec_his_retentn and num_db_backups do not apply to reorg history data held in the recovery history file. As far as I can tell, 'PRUNE HISTORY yyyymmdd' also does not clear down reorg history data.
Am I correct? Is there a way to clear down reorg history data? Does this data 'fall off the end' of the file like archlogs do in the BSDS in DB2/OS390? The manuals (which seem to omit more than they cover) appear to refer to administration of backup history only.
Incidentally, can anyone explain when and where to use the terms 'DB2' and 'UDB'? Seems to me they are almost interchangeable.
Thanks in anticipation for your assistance,
Jerry Long
MBL DBA
[EMAIL PROTECTED]
