1 / 13

Ingres Community Edition 10.1 on OpenVMS I64 Version 8.4 Bill Pedersen, CCSS

Ingres Community Edition 10.1 on OpenVMS I64 Version 8.4 Bill Pedersen, CCSS. Building Ingres on OpenVMS I64 Version 8.4 Using Ingres as a basis for open source applications on OpenVMS. A little bit about me... History: Involved with "DEC" hardware since 1972

helki
Download Presentation

Ingres Community Edition 10.1 on OpenVMS I64 Version 8.4 Bill Pedersen, CCSS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Ingres Community Edition 10.1 on OpenVMS I64 Version 8.4 Bill Pedersen, CCSS

  2. Building Ingres on OpenVMS I64 Version 8.4 • Using Ingres as a basis for open source applications on OpenVMS

  3. A little bit about me... • History: • Involved with "DEC" hardware since 1972 • "Ported" Chess-11 to VMS / San Diego DECUS Fall 1977 • DEC Western Region 1978-1983 • Independent consultant 1983 - Present • OpenVMS Evangelist/VMS Bigot

  4. Ingres – “INteractiveGraphics REtrievalSystem” • NonStop SQL started as a variant of Ingres • Other spinoffs of Ingres Project include: • Sybase • Microsoft SQL Server • Rational Technologies >>> Ingres Corporation • PostgreSQL(Postgres = POST inGRES) • Britton-Lee • By 1980 over 1000 copies distributed • Company name change 22 Sep 2011: Actian

  5. The effort: • Ingres Community Edition Version 10.1 • Build 114 Source Code in February • Currently at Build 125 • OpenVMS not currently seen as “CE” participant • Structure and environment to build from source still exists for OpenVMS • Loaded on to OpenVMS without issue after download from site

  6. Then the fun began... • Missing utilities • Old versions of utilities • Build procedures do not updated to current versions... • Build depends on: • sedV3.02 (1998, current version is 4.2.1) • flex V2.5.4 (1997, current version is 2.5.35) • These and other utilities were not included in the distribution • After three days all were found ... • Add into the stew the OpenVMS C compiler and... • We have a successful build of Ingres on OpenVMS I64 V8.4!

  7. Built VMS_INSTAL kit(Available on request) • www.ccsscorp.com/ingres.html • Installed successfully on OpenVMS I64 V8.4 • Using with open source port

  8. OpenBravo ERP to OpenVMS. • Tomcat V6 application • Oracle RDBMS on Linuxto support port • Oracle RDBMS or PostgreSQL • Using Shift2Ingres database migration toolkit

  9. Shift2Ingres • CA's $1Million Challenge in 2005 • Successful port of OpenHR • Oracle RDBMS to Ingres • No changes to application • Runs under Java 1.4 with GUI

  10. Shift2Ingres (under the covers) • Utilizes Object Management Extension • User defined data • User defined functionality • Looks like Oracle RDBMS • Modified Ingres JDBC driver • JDBC driver knows about special “Oracle” datatypes

  11. Work to be done - • Defining datatypes • Final migration of the data to Ingres • Expect to do this over next few months • PL/SQL issues • S2I supports translation of PL/SQL to SQL • Need to review

  12. Q/A Bill PedersenComputer Consulting System Services, LLC pedersen@ccsscorp.com

  13. Boot Camp Cluster • Ingres • OpenBravo (using Linux Oracle RDBMS) • Tomcat 6.x

More Related