IT Management

DB2 YDB Server for z/OS Version 8

5 Pages

During install/migrate, the precompiler default NEWFUN parameter is set based on the value of Install Type on panel DSNTIPA1 as follows:

  • UPDATE: NEWFUN setting taken from previous CLIST run.

Run the CLIST in MIGRATE mode. The CLIST customizes the usual set of jobs for migration from DB2 V7 to V8 Compatibility Mode. Note that the DB2 V8 Installation Verification Program (IVP) jobs are not customized at this point. Execute the jobs to migrate to DB2 V8 Compatibility Mode. To verify migration, run the IVP jobs from Version 7. When ready, run the CLIST and specify Enable New Function Mode (ENFM) for Install Type. The CLIST will then:

  • Calculate space required for the VSAM shadow data sets required to support Enable New Function Mode
  • Display a new Install panel listing the 18 DB2 catalog and directory tablespaces to be transformed in the next step. This list includes updateable fields for device type, volume specification, and space allocation for each shadow data set.
  • Display a summary of required space allocation; changes are allowed
  • Generate a new install jobs and customize the 8 DB2 V8 IVP jobs.

At this point, you can run the new install jobs to convert the DB2 catalog and directory to Enable New Function Mode. Note that there are several additional tasks that you must perform prior to enabling Version 8.

The minimum size of BP0 must be increased to 2,000 pages, and at least one 8KB and one 16KB bufferpool must be available to accommodate the longer row sizes of the catalog and directory tables.

The new generated install jobs perform the following functions:

  • Invoke CATENFM to signal the beginning of processing
  • Allocate the new shadow data sets
  • Convert the catalog and directory tablespaces from EBCDIC to Unicode via Reorg
  • Verify that all tablespaces have been converted
  • Convert to New Function Mode
  •  Regenerate DSNHDECP to change the value of the new Precompiler NEWFUN parameter to YES.

Without any doubt, the migration process is much more involved because of the new functionality. With all this added functionality, Unicode catalog, and larger catalog table rows, estimates indicate that 10 percent larger buffer pools may be required.


Beginning in DB2 V7, DBAs and systems programmers were able to change subsystem parameters (ZPARMs) dynamically by assembling a new subsystem parameter module and then using the SET SYSPARM command to load these new parameters into storage.

DB2 V8 extends the list of ZPARMs that may be changed this way. Basically, those parameters required for serviceability or that exist in DSNHDECP are not changeable. Here are a few of the changeable parameters:

  • CACHEDYN, MAXKEEPD (Caching of dynamic SQL)
  • SRTPOOL (Sort Pool size)
  • POOLINAC, IDTHTOIN, MAXTYPE1 (inactive DDF thread controls)
  • PARTKEYU (ability to update the value of a column that participates in a partitioning key).

Changes to Install SYSADM authority through the SET SYSPARM command are restricted to IDs already designated as Install SYSADM. Similarly, changes to the Install SYSOPR authority are restricted to IDs already designated as Install SYSOPR. See the DB2 Administration Guide for considerations regarding resetting these authorities, including possible revoke cascade situations. Also, when IDs are cached, the old authorization ID remains in effect after online changes.

Changes to CACHEDYN from YES to NO will not release space in the EDM Pool reserved for dynamic statements, and changes to the value of CACHEDYN will not affect the previous settings of currently running statements.

DPSIs and improved index support continue to address database challenges for VLDB applications for DB2 UDB Server for z/OS Version 8. These new features enable application and database designers to address business requirements with flexible solutions. The migration process helps everyone avoid issues and protect the databases while moving to the new 64-bit z/OS environment. The many enhancements found in DB2 UDB Server for z/OS Version 8 continue to raise the bar by leveraging the latest hardware and maximizing the performance and technology capabilities. DB2 UDB Server for z/OS Version 8 is state-of-the-art database technology. Z

5 Pages