1 / 13

DB2 UDB for z/OS V8

DB2 UDB for z/OS V8. DB2 UDB for z/OS V8. Kick Off Meeting January 23,2007. Agenda Introductions Welcome Overview Communications and Information Sharing Implementation Plan Reference Material Questions. Overview New Mainframe Technology zIPP (database) Specialty Engine

flower
Download Presentation

DB2 UDB for z/OS V8

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. DB2 UDB for z/OS V8

  2. DB2 UDB for z/OS V8 Kick Off Meeting January 23,2007

  3. Agenda • Introductions • Welcome • Overview • Communications and Information Sharing • Implementation Plan • Reference Material • Questions

  4. Overview • New Mainframe Technology • zIPP (database) Specialty Engine • Improves Resource Optimization • Reduces overall costs • Product Support

  5. Communications & Information Sharing • Webpage • http://www.ct.gov/doit/cwp/view.asp?Q=330566&A=2287 • E-Alerts • IBM • February 1st 9am to 11am • Blog - Traction • http://www.ct. ??????

  6. Communications & Information Sharing (continued) • Individual Agency Meetings • DOIT Contacts • Bill Katzer – Tech Support DB2 Product Owner • Mark Kirschner – Database Support DBA • Ed Fitch – Application Development Support

  7. Implementation Plan DB2 V8 Implementation Strategy • Phase I – Compatibility Mode • No new functions available. • Structured Query Language “order by” will now be done in Unicode, which will return rows in which the first 128 code points happen to match the first 128 code points of ASCII (numbers first). Hence, Unicode has a different collating sequence than EBCDIC. Also be aware that upper case comes before lower case. • Testing of new code base against current applications. Must be an extensive test prior to moving to Enable New Function Mode. Estimated time for this phase is three months.

  8. Implementation Plan DB2 V8 Implementation Strategy • Phase II – Enable New Function Mode • New functions become available. • Once in Enable New Function Mode, returning to compatibility mode is not an option. • Query Management Facility (QMF) will be moved to Enable New Function Mode at the same time. • Will remain in Enable New Function Mode for a very short period of time one to two days.

  9. Implementation Plan DB2 V8 Implementation Strategy • Phase III - New Function Mode • Subsystem is moved to New Function Mode, thereby completing the migration Version 8.

  10. Implementation Plan Tech Support Implementation Plan • A new method to upgrade subsystems will require an additional set of libraries. This will allow the test systems to be migrated to a new version and allow testing by our clients while keeping production running on the current version. • This change will be coordinated through the DBAs . • New additional panel choices for QMF and Spufi(DB2I) will be available and must be used for the testing environment.

  11. Implementation Plan FYI • The minimum requirement for DB2 Connect is DB2 Connect 8.2 FP10. • COBOL – Per John Campbell at IBM: “Existing COBOL load modules will run unchanged, but should be re-linked under LE. If a module is changed, then it will need to be compiled under Enterprise COBOL as it will have to run through the DB2 V8 Precompiler.”

  12. Reference Material • IBM Guides • SQL • Utility Guide and Reference • Migration Information • Release and Planning • Technical Preview

  13. Reference Material (continued) Additional Guides • DB2 UDB for z/OS Version 8 – Planning for Migration • DB2 UDB for z/OS Version 8 - The Migration Process, Including Tips and Hints Along the Way • DB2 UDB for z/OS Version 8 – Everything You Ever Wanted to Know,…. And More • Greatest Hits and Myths – DB2 UDB for z/OS Version 8 and Beyond • DB2 UDB for z/OS Version 8 Overview

More Related