Maintaining Large RMS files over 1 million blocks

[Trevor Dockeray (Account Manager)]

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
**********************************************************************