Databases

DB2 for z/OS Version 8 DBA Certification Guide by Susan Lawson

By Susan Lawson

IBM Gold advisor Susan Lawson provides hundreds and hundreds of sensible concepts, professional directions, and worthwhile assistance for each side of DB2 UDB database management, together with database implementation, operation, restoration, safety, auditing, functionality, set up, migration, SQL, and extra.

Show description

Read or Download DB2 for z/OS Version 8 DBA Certification Guide PDF

Similar databases books

MySQL Cookbook

MySQL Cookbook presents a different problem-and-solution layout that provides functional examples for daily programming dilemmas. for each challenge addressed within the booklet, there is a worked-out resolution or "recipe" - brief, concentrated items of code so that you can insert at once into your functions. greater than a set of cut-and-paste code, this e-book rationalization how and why the code works, so that you can learn how to adapt the recommendations to related occasions.

The Lotus Sutra

Because it first seemed in China within the 3rd century, this Mahayana Buddhist Scripture has been considered as probably the most illustrious within the canon. Depicting occasions in a cosmic international that transcends usual recommendations of time and area, The Lotus Sutra provides summary non secular principles in concrete phrases and affirms that there's a unmarried route to enlightenment.

Extra resources for DB2 for z/OS Version 8 DBA Certification Guide

Sample text

1. In compatibility ( COMPAT) mode (CM), you install the new DB2 software and do some catalog updates, but no new functions are available to customers when you start DB2. Fallback to prior releases is still possible during this mode. DB2 members in a data sharing group can be migrated one by one to this mode (mix V7/V8). 2. In enable new-function mode (ENFM), you make extensive changes to the catalog. For the most part, fallback to version 7 is impossible unless a complete restore of the subsystem is performed.

The tasks executed during the update process are equivalent to those performed by the DB2 installation Job Control Language (JCL) jobs. If you wish to have JCL jobs configure DB2 on the host, the DB2 Customization Center can also generate an output member to be used as input to the CLIST. For more information on the msys for Setup DB2 Customization Center, refer to the z/OS Managed System Infrastructure for Setup Users Guide. DB2 provides a set of tools that automate the process of installing or migrating.

YES 8 AUTOCOMMIT ...... ===> YES 9 BROWSE OUTPUT ... ) For remote SQL processing: 10 CONNECT LOCATION ===> PRESS: ENTER to process END to exit HELP for more information Installation and Migration Installation is the process of preparing DB2 to operate as a z/OS subsystem. Migration is the process of upgrading to a more current release of DB2. Both processes require the same steps. This book does not cover the details of each migration step; if you require more information, refer to the DB2 Version 8 z/OS Installation manual.

Download PDF sample

Rated 4.76 of 5 – based on 30 votes