hp mpe to vaxvms migration

[Edis, Robert]

G'day Stephen

The main issue in the conversion will be the standard non-relational to relation data structure changes.  

Oracle Rdb has the ability to have table, page or row level locking.  Depends on how you set it up.  The older versions had page level locking as the default.  I assume you'll be going to the latest version.  This RDBMS is used by high performance search databases and generally does better than other Oracle RDBMS's at dealing with very large amounts of data very fast.

I have been able to override and redefine the way PowerHouse displays Rdb columns by using Element definitions in the PHD.  This is not recommended by Cognos but it usually works. 

Going to OpenVMS also gives you other nice tools to play with.  RMS is a very fast and robust non-relational file system and mailboxes can be quite useful in a real-time environment.

BTW, I hope you don't really mean 'vaxvms' and are really talking about OpenVMS on an AlphaServer.

Good luck,

Blue

-----Original Message-----
From: powerh-l-admin@cube.swau.edu
[mailto:powerh-l-admin@cube.swau.edu]On Behalf Of
shulbert@littlejohnfrazer.com
Sent: Thursday, October 02, 2003 4:31 AM
To: powerh-l@lists.swau.edu
Subject: hp mpe to vaxvms migration


we have a client who is thinking of moving from mpe/image to openvms/native or relational.

anybody have any horror stories about non-portability issues?

e.g. image allows locking at the database level. is there an easy way to implement multi-record locks in either native or relational tables? also, powerhouse loses the ability to redefine records or elements when accessing tables in a relational database. is there any way round this?

any other pointers on things we haven't thought about?

mtia,
Stephen Hulbert.
Senior Analyst/Programmer.
Software Division. Littlejohn Frazer.
Direct: +44 (20) 7369 4501. Fax: +44 (20) 7987 9707
mailto:shulbert@littlejohnfrazer.com



The information contained in this communication is confidential and may
be legally privileged. It is intended solely for the use of the
individual or entity to whom it is addressed and others authorised to
receive it.  If you are not the intended recipient you are hereby
notified that any disclosure, copying, distribution or taking of any
action in reliance on the contents of this information is strictly
prohibited and may be unlawful.

Littlejohn Frazer reserves the right to monitor the content of any
message sent to or from littlejohnfrazer.com and its associate domains,
fmi-litjon.co.uk and litjon.co.uk

A list of partners may be inspected at 1 Park Place, Canary Wharf,
London, E14 4HJ

Registered to carry on audit work by the Institute of Chartered
Accountants in England & Wales, and authorised by the Financial
Services Authority to provide financial services

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.