RE: unload/load
What I was trying to say was ,
it is not possible for me to set TAPEDEV to null and change database status
to nologging using ontape , do alter fragment set status back to logging and
point the TAPDEV back to the original TAPEDEV, sorry about the LTAPEDEV.
Sathish
-----Original Message-----
From: Neil Truby [mailto:ntruby@netcomuk.co.uk]
Sent: Thursday, November 19, 1998 4:43 PM
To: Sadagopan, Sathish, CFCTR
Subject: Re: unload/load
Sadagopan, Sathish, CFCTR wrote:
>
> Hi,
> 1) I have a table in a dedicated dbspace with many chunks in the
> dbspace.Since there has a been a lot of activity on that table of late , I
> want to free up the many holes in the dbspace and force contiguity of
data.I
> cannot do an 'alter fragment' since I do not have enough log space to
> prevent a long.Tx.
> Setting LTAPEDEV to null is ruled out since the system is online.
You could add some log space temporarily, in cooked disk if necessary,
just to get this exercise thorugh, then drop it again.
Setting LTAPEDEV to null has no relevance to getting a long transaction.
Neil Truby
aracnet Limited
Weybridge, UK