Maintaining Large RMS files over 1 million blocks

[Trevor Dockeray (Account Manager)]

Luckily for me I have not come across that one yet :-) maybe more luck
than judgement! - a good reminder to always be very careful before
undertaking such procedures!  

I seem to recall that if you reorganise on a regular basis (especially
files that are appended, updated and possibly deleted from regularly -
where the 'damage' is done) the optimiser will manage file extensions
better than adhoc infrequent optimisation - and the file access
performance improves too.  

In fact, we reorganised the file not only to a .NEW version, but also to
another device to improve performance, and only replace the original
.DAT file should the new file be within 10% allocation size
(dir/siz=all) of the original - this ensured no gross errors where made.

TD

-----Original Message-----
From: Joe Boyle [mailto:atla38 at dsl.pipex.com] 
Sent: 10 August 2006 16:22
To: Trevor Dockeray (Account Manager); 'Desmond Dujon';
powerh-l at lists.sowder.com
Subject: RE: Maintaining Large RMS files over 1 million blocks

I seem to recall that the optimiser makes some ludicrous assumptions
regarding allocation for secondary keys, so I would suggest you get
someone
to inspect the output before you go ahead and build your file based on
it's
conclusions :)

Regards, Joe.

-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On
Behalf Of
Trevor Dockeray (Account Manager)
Sent: 10 August 2006 15:31
To: Desmond Dujon; powerh-l at lists.sowder.com
Subject: RE: Maintaining Large RMS files over 1 million blocks

Desmond

If you are trying to optimise the RMS file on OpenVMS I would recommend
you try:

$ anal /rms /fdl FILE.DAT /out=FILE.fdl
$ edit /fdl /nointer /anal=FILE.FDL FILE.FDL
$ convert /fdl=FILE.FDL FILE.DAT FILE.NEW

Please ensure that you are using the default EDT editor with no
enhancements.  To do this try 'edit==edit/edt'

This script will:
	Create an FDL of your existing data file
	Optimise the FDL 
	Convert your existing data file using the optimised FDL to a new
version of the file.

We optimise all of our RMS data files overnight using this method on a
weekly basis to ensure that files are efficient

Trevor

 

Regards,

Trevor Dockeray

Mobile:            07946 589749
Telephone:      0870 727 4343
Facsimile:        0870 727 4342

Lightsout - IT Services and Solutions Provider
www.lightsout.co.uk 
http://solutions.lightsout.co.uk/shop/ 

-----Original Message-----
From: powerh-l-bounces+trevor.dockeray=lightsout.co.uk at lists.sowder.com
[mailto:powerh-l-bounces+trevor.dockeray=lightsout.co.uk at lists.sowder.co
m] On Behalf Of Desmond Dujon
Sent: 10 August 2006 14:54
To: powerh-l at lists.sowder.com
Subject: Maintaining Large RMS files over 1 million blocks

Hi Folks

When I run the 

$convert file.dat file.dat

it takes several hours. The file is 1.5 million
blocks.

IS there a more efficient way to optimize the file?

Is moving to Oracle 7 on OpenVMS Alpha good option?
Thanks

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.


*****************************************************************
This email has been content checked and swept for 
virii by Mailsweeper


*****************************************************************



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************


-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list
archive at Google.