Do more with less 1

DB2 for z/OS SQL Performance Plug-in for Rational Developers

Date: March 20th at 18:00 CET, 1pm EDT.

(engl)

Abstract:

Enterprises have invested a lot of resources and money to develop classical TSO/ISPF applications in COBOL, PL1, JAVA, etc. The mainframe also delivers methodologies and infrastructure for a secure and quality-proven environment. This gained advantage has to be kept for the future. The mainframe is also open for the GUI-driven world where applications are developed and built faster by experienced developers, but unfortunately not very often with mainframe infrastructure. This webinar shows how the enterprise can benefit from both the proven mainframe and the modern application development way on the workstation with GUIs. For the DBA and the developer with the traditional TSO/ISPF and batch approach, everything looks the sexy 3270 way. For the workstation developer without TSO/ISPF it´s just GUI. This is the hybrid world.

SEG’s/SEGUS’s SQL Performance Expert (SPX) serves this hybrid world with the classical green screens for the mainframe people and checks SQL performance within a GUI plug-in for the Rational Developer providing flexible rule sets to control, analyze and improve SQL performance issues.

Outline:

  • How can a hybrid world possibly look ? – big picture look at workstations and mainframe components
  • How a DBA works today in a typical mainframe environment (Batch)
  • e.g., SQL performance problems
  • How a Developer works today in a typical mainframe environment (Batch/ISPF)
  • e.g., SPX EDIT MACRO
  • How to keep the investment on the host, but increase the speed of development with Rational Developer for z (Integration with the SQL performance Plug-in and Batch) using the mainframe COBOL Compiler, DBRM analysis etc.
  • Even faster development : the Web 2.0 (complete Integration) with pure SQL

Speaker Biography:

Roy Boxwell has more than 24 years of experience in MVS, OS/390, and z/OS environments – 21 of those in DB2. He specializes in installation, migration, and performance monitoring and tuning. Roy leads the SEG development team responsible for the real time database maintenance solutions. He is also an active participant and contributor on the IDUG DB2 Listserv and sends out a monthly DB2 Newsletter.