Cognos 839 on HP3000 ( Quick, Quiz, Qtp ) migrate path to UNIX ?
krikor Gullekian
krigul at yahoo.com
Fri Dec 9 18:28:02 CST 2011
There are many tools out there that will help you to migrate, if you don't have many complex powerhouse code or MPE commands embedded within the Powrhouse code, it will be easy and quite fast.
KSAM is a little tricky, better migrate it to your RDBMS, ISAM might be tricky specially with large files and many keys.
However you do it, get a good DBA to optimize the DB before going to production. BTW how big is the application?
Good luck and if you need any help many people in this group can help.
Krikor Gullekian
krigul at yahoo.com
--- On Fri, 12/9/11, powerh-l-request at lists.sowder.com <powerh-l-request at lists.sowder.com> wrote:
From: powerh-l-request at lists.sowder.com <powerh-l-request at lists.sowder.com>
Subject: powerh-l Digest, Vol 78, Issue 3
To: powerh-l at lists.sowder.com
Date: Friday, December 9, 2011, 1:00 PM
Send powerh-l mailing list submissions to
powerh-l at lists.sowder.com
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
powerh-l-request at lists.sowder.com
You can reach the person managing the list at
powerh-l-owner at lists.sowder.com
When replying, please edit your Subject line so it is more specific
than "Re: Contents of powerh-l digest..."
Today's Topics:
1. Cognos 839 on HP3000 ( Quick, Quiz, Qtp ) migrate path to
UNIX ? (Legault, Raymond D)
2. Re:Cognos 839 on HP3000 ( Quick, Quiz, Qtp ) migrate path to
UNIX ? (Bob Deskin)
3. RE:Cognos 839 on HP3000 ( Quick, Quiz, Qtp ) migrate path to
UNIX ? (Charles Finley)
----------------------------------------------------------------------
Message: 1
Date: Thu, 8 Dec 2011 13:48:56 -0800
From: "Legault, Raymond D" <raymond.d.legault at boeing.com>
Subject: Cognos 839 on HP3000 ( Quick, Quiz, Qtp ) migrate path to
UNIX ?
To: "powerh-l at lists.sowder.com" <powerh-l at lists.sowder.com>
Message-ID:
<BAC61BCE56DF62498E011B2FCCC90D75332051D733 at XCH-NW-22V.nw.nos.boeing.com>
Content-Type: text/plain; charset="us-ascii"
Gentleman
Would any of you know the easiest migration path with the least amount of modifications
For migrating off of the Hp3000 to UNIX? I assume the new database could be SQL Server or Oracle.
Index files ( KSAM) are also used quite heavily.
Thank You in advance.
Ray Legault
------------------------------
Message: 2
Date: Thu, 8 Dec 2011 16:57:57 -0500
From: Bob Deskin <Bob.Deskin at ca.ibm.com>
Subject: Re: Cognos 839 on HP3000 ( Quick, Quiz, Qtp ) migrate path to
UNIX ?
To: "Legault, Raymond D" <raymond.d.legault at boeing.com>
Cc: powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com,
"powerh-l at lists.sowder.com" <powerh-l at lists.sowder.com>
Message-ID:
<OF7AC08407.3CD94C74-ON85257960.007861FF-85257960.0078AAA4 at ca.ibm.com>
Content-Type: text/plain; charset="US-ASCII"
Review the MPE/iX Migration Guide from
http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/powerhouse/8.4f/mig_mpeix.pdf
It has chapters on migrating to UNIX, Linux, and Windows. It also
discusses moving to relational databases and differences between KSAM and
C-ISAM. Once you've gone through that, you'll be in a much better position
to ask specific questions.
Bob Deskin
Senior Product Manager
IBM Cognos Application Development Tools
IBM Canada
http://www.ibm.com/software/data/cognos/products/powerhouse/
From: "Legault, Raymond D" <raymond.d.legault at boeing.com>
To: "powerh-l at lists.sowder.com" <powerh-l at lists.sowder.com>
Date: 2011-12-08 04:49 PM
Subject: Cognos 839 on HP3000 ( Quick, Quiz, Qtp ) migrate path to
UNIX ?
Sent by: powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com
Gentleman
Would any of you know the easiest migration path with the least amount of
modifications
For migrating off of the Hp3000 to UNIX? I assume the new database could
be SQL Server or Oracle.
Index files ( KSAM) are also used quite heavily.
Thank You in advance.
Ray Legault
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
------------------------------
Message: 3
Date: Thu, 8 Dec 2011 15:04:42 -0800
From: "Charles Finley" <cfinley at xformix.com>
Subject: RE: Cognos 839 on HP3000 ( Quick, Quiz, Qtp ) migrate path to
UNIX ?
To: "'Bob Deskin'" <Bob.Deskin at ca.ibm.com>, "'Legault, Raymond D'"
<raymond.d.legault at boeing.com>
Cc: powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com,
powerh-l at lists.sowder.com
Message-ID: <001e01ccb5fd$c5bfb390$513f1ab0$@com>
Content-Type: text/plain; charset="us-ascii"
It will be a pleasant surprise to you how easy it can be if you use the
right tools.
We, Transformix can migrate Powerhouse to Oracle or SQL Server with mostly
automated changes using tools. We pretend to be Eloquence so if upon
installation of Powerhouse you tell it that Eloquence is your database you
should expect that code works mostly as is. This means that on Windows you
can use Oracle, DB2, SQL Server or Postgresql. As far as KSAM is concerned,
we store the data inside of the RDBMS and we allow the use of either KSAM or
C-ISAM/DISAM to be used to access the data. Therefore, for Powerhouse code
we would pretend to be the shared library or dll they are looking for to
replace KSAM and your code should mostly work as is. Moreover, if you have
3gl code like COBOL, etc. that must also access the data they two are likely
to work with few modifications.
We also have an implementation of MPE JCL, Spooler, Batchjob, FTP, Suprtool,
etc. This all works and can be demonstrated immediately with Powerhouse for
Windows, Linux or Unix.
Which version of Unix would you prefer to use?
Charles Finley
(619) 795-0720
-----Original Message-----
From: Bob Deskin [mailto:Bob.Deskin at ca.ibm.com]
Sent: Thursday, December 08, 2011 1:58 PM
To: Legault, Raymond D
Cc: powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com;
powerh-l at lists.sowder.com
Subject: Re: Cognos 839 on HP3000 ( Quick, Quiz, Qtp ) migrate path to UNIX
?
Review the MPE/iX Migration Guide from
http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/powerho
use/8.4f/mig_mpeix.pdf
It has chapters on migrating to UNIX, Linux, and Windows. It also
discusses moving to relational databases and differences between KSAM and
C-ISAM. Once you've gone through that, you'll be in a much better position
to ask specific questions.
Bob Deskin
Senior Product Manager
IBM Cognos Application Development Tools
IBM Canada
http://www.ibm.com/software/data/cognos/products/powerhouse/
From: "Legault, Raymond D" <raymond.d.legault at boeing.com>
To: "powerh-l at lists.sowder.com" <powerh-l at lists.sowder.com>
Date: 2011-12-08 04:49 PM
Subject: Cognos 839 on HP3000 ( Quick, Quiz, Qtp ) migrate path to
UNIX ?
Sent by: powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com
Gentleman
Would any of you know the easiest migration path with the least amount of
modifications
For migrating off of the Hp3000 to UNIX? I assume the new database could
be SQL Server or Oracle.
Index files ( KSAM) are also used quite heavily.
Thank You in advance.
Ray Legault
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
__________ Information from ESET Smart Security, version of virus signature
database 6695 (20111208) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus signature
database 6695 (20111208) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus signature
database 6695 (20111208) __________
The message was checked by ESET Smart Security.
http://www.eset.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.
End of powerh-l Digest, Vol 78, Issue 3
***************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20111209/1c50ae6d/attachment.htm>
More information about the powerh-l
mailing list