There is one way that you could cause that file top move to a new location.
The file has to be in the database path chosen at create time.
However, one can relocate a database by specifically moving the whole
database path to a new file system.
This will be an offline operation where you file system copy the current
path to the new path in the new file system.
You should copy only the SQL0000n directory but not its
subdirectories if they are containers.
You then use the relocate command to update all the instance and database
pointers.
If you have tablespace containers in the current database path, do not copy
them unless you require them to be there.
Hope this helps, Pierre.
-----Message d'origine-----
De : Terry Gilbert
[mailto:db2udbdba-ezmlmshield-x39734805.[Email address protected]
Envoyé : 1 mai 2008 08:15
À : LazyDBA Discussion
Objet : RE: History File v8.2
Caveat - new to this so some of my terms may be wrong, my arguments and
ideas may be whacked. (admittedly that may have nothing to do with me being
new to db2;-)
We have a lot of bulkloads (1k's to 10k's or rows) happening concurrently
and they are getting blocked waiting for history file access. The
filesystem is mounted CIO so the access to the history file is not
benefiting from a system file cache. We have had better performance with
CIO generally, I believe that's typical but I would love to hear of any
differing experiences .
So we thought first that maybe we don't need the history file but you've
answered that (thank you) secondly we thought to move the history file on
to another JFS filesystem but you've answered that too, thanks again :-)
Sounds like it was just unfortunate that the tablespace container for the
application data was placed in the same filesystem, and we should possibly
rebuiild this instance so that we can keep some of the db2 stuff using JFS
while our application data ends up using CIO filesystems.
Does that make sense?
Cheers
T
-----Original Message-----
From: Alex Levy [mailto:db2udbdba-ezmlmshield-x77382017.[Email address
protected]
Sent: Thursday, May 01, 2008 6:07 AM
To: LazyDBA Discussion
Subject: RE: History File v8.2
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
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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