PostgreSQL vs. Db2 for z/OS

Marcus Davage

PostgreSQL vs. Db2 for z/OS
Classification: Public

Greetings fellow labourers,

Does anyone have an opinion/experience/evidence of moving a 720 TPS workload, running 500 MIPS per GP and 700 MIPS per ZIIP across 4 way data sharing sysplex, from Db2/z onto PostgreSQL?

Regards,
Marcus Davage CEng CITP MBCS
IBM Certified DB2 Database Administrator
LinkedIn http://uk.linkedin.com/in/marcusdavage | IDUG http://www.idug.org/p/us/sn/uid=24500 | Twitter http://twitter.com/spufidoo | About.me http://about.me/spufidoo


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may contain privileged material. If you have received this e-mail in error, please notify the sender and delete it (including any attachments) immediately. You must not copy, distribute, disclose or use any of the information in it or any attachments. Telephone calls may be monitored or recorded.

Jørn Thyssen

RE: PostgreSQL vs. Db2 for z/OS
(in response to Marcus Davage)

Hi Marcus,

We need more information about the nature of the workload and non-functional requirements, and your current IT landscape. 

Is this business critical application? Is it a mixed CICS and batch workload written in COBOL? What are the requirements on performance, response times, RTO, RPO, etc? Would you have other workloads still remaining on mainframe? Do you have enterprise skills for PostgreSQL?

 

The IBM Eagle Team offers to do a TCO calculation of the mainframe vs your choice of distributed platform. You can compare this to the TCO calculations of the consulting company that thinks PostgreSQL is a good idea.

 

Also read this article http://www.redbooks.ibm.com/redpapers/pdfs/redp5032.pdf to get some understanding of the traps you can fall into. I have seen customers embark projects to migrate off the mainframe - always projects with an aggressive 1-2 year time line, but after 5-10 years they still have workload on the mainframe. I can only imagine the cost of running dual systems for 5-10 years, implementing every change in two places, expensive data exchange between systems, etc etc  

 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

Views are personal.