Migrating from HP/iX to HP/UX

[arthur kogan]

Hi Mary,

there is an old document (about 5 years old) from Cognos detailing most of the
issues re migration from HP3000 to HPUX. It is talking about older versions of
PH, but the issues are still relevant. You can try asking Cognos in Sydney,
Australia for it (they had a copy when I left in March this year).

There are also various issues about connecting to ORACLE and UNIX being case
sensitive. There are various documents on this (and in particular about
defining the ORACLE database in the PH dictionary) in the Cognos Knowledge Base
available via the Internet.

Regards,

Arthur Kogan
Westpac Financial Services
Sydney, Australia

Mary.McNairney@stos.co.nz wrote:

> Subject: Migrating from HP/iX to HP/UX
> Date: Mon, 28 Sep 1998 15:45:20 +1200
> From: Mary.McNairney@stos.co.nz
> To: power-l@lists.swau.edu
>
> Hi,
>
> I am migrating an application (with existing 8 digit dates)
>    from HP3000 PowerHouse 7.09 for MPE/iX and KSAM
>    to   HP9000 PowerHouse 8.13 for HP/UX and Oracle.
>
> I have received and installed the PowerHouse software, but am still
> waiting for a complete set of user manuals for PH8.13 and Oracle.
>
> We have created jobs to:
>   - change hyphens to underscores in field and file names for both
> dictionary and program source
>   - create the script file for creating the Oracle tables
>   - extract the data into portable subfiles
>
> I have some questions which I would like answered:
>
> 1. Has anyone already done this migration? If so, are there any known
> pitfalls for us to avoid? Also, are there any ways to set up PowerHouse
> on Unix to make the migration easier?
>
> 2. I have set up a test Oracle database with a few tables and have
> created a simple PH dictionary to try and access it via the Oracle
> dictionary. When I run Qshow, it shows the database, but says Records
> and sizes none, even when I run Qshow with subdict=search. How can I get
> PowerHouse to use the oracle dictionary?
>
> Any help would be greatly appreciated.
>
> Mary McNairney    Email mary.mcnairney@stos.co.nz
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.



= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.