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