Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > DB2 > DB2 for z/OS: Installation & Migration Training

DB2 for z/OS: Installation & Migration Training

Course#: WA2160

This course provides attendees with an effective introduction to the skills and knowledge required to implement a DB2 system. The planning, installation and setting up of a DB2 subsystem are discussed in detail, along with an overview of operational issues. This course also provides valuable information regarding the migration to new releases.

Objectives

On successful completion of this course attendees will be able to:

  • describe the planning considerations for installing, migrating, or updating a DB2 system
  • list additional considerations when using distributed data facility or shared data
  • explain the installation process using the DSNTINS0 or DSNTINST CLIST, and the jobs it produces
  • define the additional considerations when migrating between DB2 releases
  • describe DB2 attachment installation, and implications with other non-DB2 systems
  • manage the general day to day operation of the DB2 system.

Audience

This course is intended for systems programmers and systems administrators who wish to develop their knowledge and expertise in installing a DB2 for z/OS system.

Prerequisites

A general understanding of DB2 is required. In addition, familiarity with either CICS or IMS would also be of use. The course assumes knowledge and use of TSO and ISPF.

Duration

2 days

Outline of WA2160 DB2 for z/OS: Installation & Migration Training

1. Introduction

  • Definitions
  • Compatibility Mode (CM)
  • Enable New Function Mode (ENFM)
  • New Function Mode (NFM)
  • migration paths
  • installation / migration steps

2. Installation Planning

  • DASD storage requirements
  • storage estimates - cylinders
  • storage estimates - Megabytes
  • DASD requirements - DB2 catalog & directory
  • DASD requirements - default, work & temporary databases
  • DASD requirements - Log Data Sets
  • DASD requirements - user data
  • DASD requirements - user indexes
  • Virtual Storage requirements
  • Buffer, Sort & RID pools
  • EDM pool
  • DSCBs and working storage
  • real storage estimation
  • planning distributed data
  • planning shared data

3. Installation & Migration Review

  • The major steps
  • loading DB2 libraries (the SMP process)
  • msys for setup
  • DB2 Customization Center
  • the install CLISTs
  • invoking the install CLIST
  • install main panel
  • installation panels
  • the customised jobs

4. Installation CLIST

  • The installation CLIST
  • invoking the Install CLIST
  • DSNTIPA1 - install, migrate, update main panel
  • DSNTIPP1 - data sharing options
  • DSNTIPA2 - data parameters
  • DSNTIPK - define group or member
  • DSNTIPH - system resource data set names
  • DSNTIPT, DSNTIPU, DSNTIPW - data set names
  • DSNTIPD, DSNTIP7 - sizes
  • DSNTIPE - thread management
  • DSNTIP1, DSNTIP2 - buffer pool sizes
  • DSNTIPN - tracing parameters
  • DSNTIPO - operator functions
  • DSNTIPF, DSNTIP4 - application programming defaults
  • DSNTIP8 - performance and optimization
  • DSNTIPI, DSNTIPJ - IRLM
  • DSNTIPP - protection
  • DSNTIPM - MVS PARMLIB updates
  • DSNTIPL - active log data set parameters
  • DSNTIPA - archive log data set parameters
  • DSNTIPS - databases & spaces to start automatically
  • DSNTIPR, DSNTIP5 - distributed data facility
  • DSNTIPX - routine parameters
  • DSNTIPZ - data definition control support
  • DSNTIPY - job editing
  • DSNTIPC - CLIST calculations panel

5. Installation Jobs

  • The installation jobs
  • job DSNTIJMV - define DB2 to z/OS
  • job DSNTIJCA - define ICF catalog
  • jobs DSNTIJIN & DSNTIJID - define & initialise system data sets
  • job DSNTIJUZ - define initialisation parameters; optional jobs
  • job DSNTIJTC - tailor the DB2 catalog
  • jobs DSNTIJTM, DSNTIJSG - Defining DB2 Objects, etc.
  • job DSNTIJRX - REXX support (optional)
  • jobs DSNTIJIC & DSNTEJxx - back-up and verification

6. Connecting to DB2

  • DB2 connections (attachments)
  • TSO attachment
  • job DSNTIJVC - build the CLIST library
  • make libraries available to TSO
  • connect DB2I panels to main panel
  • invoking TSO attachment
  • CICS attachment; Resource Control Table
  • DB2CONN using CEDA
  • DB2ENTRY using CEDA
  • DB2TRAN using CEDA
  • controlling CICS attachment
  • IMS attachment
  • IMS Subsystem Member (SSM)
  • Subsystem Member relationships
  • Resource Translation Table (RTT)
  • controlling IMS attachment

7. Migration & Updating

  • Migration paths
  • migration steps
  • migration considerations
  • migration compatibility
  • migration review
  • prerequisites & maintenance level of current system
  • integrity of current system; back-up current system
  • migration steps
  • migration & data sharing
  • the customised jobs
  • fallback
  • enabling new function mode
  • installation panel DSNTIPA1 - ENFM
  • shadow data set allocations - DSNTIP00
  • image copy data set allocations - DSNTIP01
  • storage requirements - DSNTIP02
  • jobs DSNTIJNE, DSNTIJNF & DSNTIJNH
  • jobs DSNTIJNG, DSNTIJNR and DSNTIJEN
  • enlarging the BSDS
  • updating DB2

8. Distributed Data Facility

  • Distributed Data Facility
  • VTAM components
  • enabling TCP/IP communication
  • communications tables
  • distributed protocols
  • distributed security

9. DB2 Operations

  • DB2 command format
  • starting DB2
  • log initialisation
  • current status rebuild
  • forward log recovery
  • backward log recovery
  • processing log records
  • controlling Lock Manager
  • controlling Distributed Data Facility
  • controlling CICS attachment
  • CICS attachment commands
  • controlling IMS attachment
  • IMS attachment commands
  • controlling threads
  • controlling databases
  • controlling Bufferpools
  • other DB2 commands
  • stopping DB2

10. Performance & Tuning

  • What is 'performance'?
  • Service Level Agreements
  • performance objectives
  • workload categories
  • performance factors
  • database design
  • application design
  • system parameters
  • EDM pool size
  • Bufferpool sizes & thresholds
  • DB2 traces
  • trace types & classes
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.