Is a history file required in DB2? Absolutely! as its name suggests, for
recovery. Every backup, recovery, load, roll-forward, tablespace alter and
quiesce, reorg, stats and table drop is recorded and timestamped there.
That's from memory, there's probably a whole bunch of other stuff essential
for recovery that goes in there too.

You cannot sensibly 'move' a history file to a new directory as such - it
needs to be in its default location, because that's where DB2 will look for
it and there's no way to tell the engine to look for it elsewhere. The
command you refer to simply updates the reference to the location of a
backup within the RHF file itself.

What underlies your question? why do you want to move the RHF? If you are
concerned by its size, consider the PRUNE HISTORY command, and the per
partition REC_HIS_RETENTN and NUM_DB_BACKUPS db cfg parameters.

Regards
Alex Levy
Sustainable Software Ltd.


-----Original Message-----
From: Terry Gilbert
[mailto:db2udbdba-ezmlmshield-x78394382.[Email address protected]
Sent: 30 April 2008 21:41
To: LazyDBA Discussion
Subject: History File v8.2


Few history file questions,

Is a history file required in db2? (If not, can I turn it off or disable
it?)

If I have to have one, how do I move it? The update history location
command seems to apply to entries inside the history file somehow - doc is
unclear.

Thanks in advance
T


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page