DB2 11 for z/OS Migration Overview - neodbug

1 DB2 11 for z/OS Migration Overview neodbug User's Group Meeting May 21, 2015. Charles Lewis Technical Sales Specialist IBM Mid-Atlantic Region Disclaimer and Trademarks Information contained in this material has not been submitted to any formal IBM review and is distributed on "as is" basis without any warranty either expressed or implied. Measurements data have been obtained in laboratory environment. Information in this presentation about IBM's future plans reflect current thinking and is subject to change at IBM's business discretion. You should not rely on such information to make business plans. The use of this information is a customer responsibility. IBM MAY HAVE PATENTS OR PENDING PATENT APPLICATIONS COVERING SUBJECT. MATTER IN THIS DOCUMENT. THE FURNISHING OF THIS DOCUMENT DOES NOT. IMPLY GIVING LICENSE TO THESE PATENTS. TRADEMARKS: THE FOLLOWING TERMS ARE TRADEMARKS OR REGISTERED. TRADEMARKS OF THE IBM CORPORATION IN THE UNITED STATES AND/OR OTHER. COUNTRIES: AIX, AS/400, DATABASE 2, DB2, e-business logo, Enterprise Storage Server, ESCON, FICON, OS/390, OS/400, ES/9000, MVS/ESA, Netfinity, RISC, RISC.

2 SYSTEM/6000, System i, System p, System x, System z, IBM, Lotus, NOTES, WebSphere, z/Architecture, z/OS, zSeries The FOLLOWING TERMS ARE TRADEMARKS OR REGISTERED TRADEMARKS OF THE. MICROSOFT CORPORATION IN THE UNITED STATES AND/OR OTHER COUNTRIES: MICROSOFT, WINDOWS, WINDOWS NT, ODBC, WINDOWS 95. For additional information see DB2 11 for z/OS Migration Agenda Packaging Application Compatibility Prerequisite Summary & RBA / LRSN Expansion Planning Summary of removed &. deprecated items New / Changed System Parameters Summary of Migration steps Review of incompatibilities Migration Process Details Preparations Panels Modes Catalog Evolutions DB2 11 for z/OS MPW Migration Materials Information in this presentation is kept current on a best effort basis. You should always refer to current documentation to plan and verify your Migration projects. Documentation used in the MPW presentations and checklists include: Announcement Letter 213-376. Program Directory - GI10-8945-00. Installation Guide GC19-4056-00.

3 Silicon Valley Lab guidance IBM internal systems Field Experience DB2 11 for z/OS Documentation Administration Guide (SC19-4050). Application Programming and SQL Guide (SC19-4051). Application Programming Guide and Reference for Java (SC19-4052). Codes (GC19-4053). Command Reference (SC19-4054). Data Sharing: Planning and Administration (SC19-4055). Installation and Migration Guide (GC19-4056). Internationalization Guide (SC19-4057). Introduction to DB2 for z/OS (GC19-4058). IRLM Messages and Codes for IMS and DB2 for z/OS (GC19-2666). Licensed Program Specifications (GC19-4059). Managing Performance (SC19-4060). Managing Security (SC19-4061). Messages (GC19-4062). ODBC Guide and Reference (SC19-4063). pureXML Guide (SC19-4064). RACF Access Control Module Guide (SC19-4065). SQL Reference (SC19-4066). Utility Guide and Reference (SC19-4067). What's New? (GC19-2985). Diagnosis Guide and Reference SDSNIVPD library member DSNDR (with PM95206). DB2 11 for z/OS Packaging DB2 11 for z/OS.

4 Orderable Chargeable Base No-Charge Features Features DB2 Base z/OS Appl Connectivity to DB2 for z/OS DB2 QMF V11. IRLM V2R3 DB2 QMF Enterprise Edition REXX DB2 QMF Classic Edition MQListener IMS Attach Related RACF Auth Exit No-Charge Panels (English / Kanji). JDBC / SQLJ / ODBC. Product DB2 Accessories Suite 5697-Q04. See announcement 213-395 for details DB2 11 for z/OS Base Components Required FMIDs DB2 Base HDBBB10. REXX Language Support MQ Listener Subsystem Initialization HIZBB10. IRLM V2R3 HIR2230. IMS Attach HIYBB10. RACF Authorization ExitHDREB10. Optional FMIDs ODBC JDBBB17. JDBC / SQLJ JDBBB12. Kanji panels JDBBB11. DB2 11 for z/OS Optional No Charge Feature z/OS Application Connectivity to DB2 for z/OS. DB2 Universal Database Driver for z/OS, Java Edition Java Type 4 Driver DB2 11 for z/OS Related No Charge Product IBM DB2 Accessories Suite, (5697-Q04). (Announcement letter 213-395). IBM DB2 Accessories Suite V11 Feature Support for new DB2 Spatial functions Data Studio JSON Support (II14727).

5 IBM Text Search for DB2 for z/OS. Internationalization Components for Unicode (needed for Spatial Support). See Program Directory GI10-8957. IBM DB2 Accessories Suite V10 Feature Includes what is in the V11 Accessories Suite Including JSON Support (II14727). See Program Directory GI10-8958. IBM DB2 Accessories Suite V9 Feature No JSON support available DB2 11 for z/OS Chargeable Features DB2 QMF Enterprise Edition DB2 QMF for TSO / CICS. DB2 QMF Analytics for TSO (new). DB2 QMF High Performance Option DB2 QMF for Workstation DB2 QMF for WebSphere DB2 QMF Classic Edition DB2 QMF for TSO / CICS. DB2 QMF v11 and new one-time charge QMF V11. (5697-QMF). supported with DB2 11 for z/OS. DB2 10 for z/OS (all modes) with PM50434. DB2 9 for z/OS NFM with PM45482. The Evolution of QMF. Today we have QMF for z/OS working with mobile, providing DB2 Analytics 30 Years of Innovation Accelerator support, text analytics, predictive analytics, geospatial And We Continue to Invest mapping, and so much more.

6 QMF for Windows is released, this would later become the QMF EE workstation component, extending QMF functionality to workstation users, allowing for visual reports and interactive dashboards QMF Enterprise Edition further extended these capabilities to users via an ordinary Web browser, allowing even greater access to business critical data We started with QMF for TSO/CICS. QMF queries, reports, and procedures are stored in DB2 tables, collectively called the QMF Catalog. This became QMF Classic Edition QMF for z/OS V11 offers fast, simple connection to a broad spectrum of data sources QMF pricing is based on the DB2 footprint. This allows it unlimited access to all other sources at no additional cost. IBM DB2. Teradata Informix for iSeries IBM DB2. MySQL Oracle for z/OS. Postgres SQL. Server IBM IBM DB2 QMF V11. SolidDB IMS PureData ADABAS for LUW. Sun JDBC- ODBC Cloudant bridge data zSQL. sources such as Excel and text files BigInsights etc. Web Access Hadoop http data QMF for z/OS v11 - capability highlights Graphical queries, reports Heterogeneous database access Federated data Dashboards and KPIs Scheduling for automation Advanced analytic functions and analysis Virtual data sources ( use queries as input vs SAVE DATA).

7 JDBC access to any RDBMS. Superlative support of the IBM DB2. Analytics Accelerator Spatial data access Mobile device support Multi-dimensional analysis Full DB2 11 for z/OS support (temporal data, etc.). Operational Business Intelligence ( access to IMS, Adabas, IDMS). Big Data Prerequisite Summary & Planning .. PID 5615-DB2. FMIDs HDBBB10, HIYBB10, HIZBB10, HIR2230, HDREB10. z/Architecture (z10 and subsequent 64-bit z/Architecture Processors). z/OS or above Data Sharing: CF Level 12, with 13 or 14 recommended GBP Enhancements require CFLEVEL 17 or higher DB2 LUW / Connect / Data Server Driver / JDBC / ODBC. Any in-support IBM Information Managements clients / drivers FP2 advised for new features See the Program Directory for more details (ex DB2 for z/OS client to DB2 LUW server). Migrate from DB2 10 for z/OS NFM. With Fallback SPE PM31841. With associated coreqs & prerequisites Reassemble DSNHDECP module See Informational APARs II14660/II14745 ( Migration ), II14730 / II14732 (Client & DDF).

8 Establish performance baselines Prerequisite Summary & Planning .. Check / correct incompatibilities Run a current V10 DSNTIJPB pre- Migration job (PM94057). Same as V11 DSNTIJPM. Check maintenance for currency Release Incompatibilities documented in: Installation Guide Application Programming and SQL Guide Check programming language requirements DSNHPC7 included in the base for older COBOL and PL/I. See the Program Directory IBM InfoSphere Data Replication (IIDR) IBM DB2 Analytics Accelerator V4. IBM DB2 Tools Compatibility Prerequisite Summary & Planning .. Configure a minimum of (IEASYSxx): 1TB of contiguous shared private per DB2 HVSHARE. Default is 510TB. 6GB of contiguous shared extended private per DB2 HVCOMMON. Same as DB2 10. Default 66GB. No significant storage usage differences OnDemand Buffer Pool allocation from DB2 10 was removed This likely does not represent a storage requirement VPSIZE will be allocated when Buffer Pool is allocated Early testing indicates 0 5% additional memory dependent on query workload Consider 10% cushion for potential growth with less behaved workloads SMS managed catalog and directory This was a requirement for DB2 10.

9 Data Class attributes of Extended Format Extended Addressability New areas of the Cat / Dir moved under SMS management during Migration to 11. Additional migrated areas REORGed after V10 ENFM would also have been converted DSNTIJSS provided as a sample for configuration Prerequisite Summary & Planning .. Reestablish V10 IVP to test DB2 11 before NFM. PI13612 should be applied for COBOL 5 support Assess ISV Requirements / Readiness Tools and applications (Check your IBM DB2 Tools). Some vendors may add instructions for Migration and / or require maintenance Assess the training requirements for your organization PDSEs required for SDSNLOAD, SDSNLOD2, ADSNLOAD, ADSNLOD2. Same as V10. Establish a project team and project plan Review the Installation Guide checklists and MPW Project Framework Consider Single Version Charging when building your plan Prerequisite Summary & Planning Develop conversion and coexistence goals How did your V10 test plans work? Reuse and improve upon your experiences Migration occurs in three familiar phases Conversion Mode (CM).

10 Data Sharing may see an X mode during coexistence Enable New Function Mode (ENFM). New Function Mode (NFM). Use the proactive PMR process This is to notify IBM DB2 Support of your up coming Migration activity It is typically routed to the DB2 Duty Manager on call for that time If problems occur during the Migration , open a new Sev 1 PMR / SR. REBIND / REGENERATE while in CM. Use REBIND Plan Management (Package / Bind Stability). Consider FREEing Original Packages to establish a new DB2 10 back up Consider: REBIND .. EXPLAIN (YES) .. APREUSE(WARN or ERROR). REBIND .. EXPLAIN (YES) .. APCOMPARE(WARN or ERROR). DB2 11 for z/OS Migration Modes / NFM Decisions DB2 10 DB2 11. APPLCOMPAT. DSNTIJTC DSNTIJEN DSNTIJNF. DB2 11 DB2 11. for z/OS for z/OS. CM ENFM. NFM NFM. DSNTIJEN DSNTIJNF DSNTIJNF. DSNTIJCS DSNTIJES. Fallback SPE applied and incompatibilities DB2 10. DB2 11 DB2 11. mitigated. for z/OS. CM* ENFM*. NFM. DSNTIJEN. DSNTIJCS. DSNTIJCS. RBA/LRSN. Expanded DB2 11. CM*. V10 Catalog V11 CM Catalog V11 Catalog V11 Catalog Optional Removed Features Summary No pre-V9 bound Packages Require REBIND, including PLANMGMT copies Password protection of Active / Archive Logs Previous NEWFUN values DB2 Supplied Routines AMI based DB2 MQ Functions See JPB/JPM report Sysplex Query Parallelism DSN1 CHKR.