αíß

2

DTS Introduction• Welcome!– Alisa Claypool,

DTS Systems Software Specialist, DB2 for z/OS Systems Support

– Presentation Slides will be available on the DTS website

– Event Evaluation Survey

• Upcoming DTS Technology Days and Customer Forums

• Technology Services Board Meeting (January 16, 2007)• Chain of Custody Technology Day• Cal Net II Customer Forum• Network Customer Forum• Web Master User Group Meeting and Training Sessions• SAS User Group Meetings and Training Sessions

• Look for more DTS events coming soon at http://www.dts.ca.gov/news_events/

http://www.dts.ca.gov/news_events/



3

Today’s Agenda 1:30 - 1:35 Welcome and Orientation

(Alisa Claypool, DTS)

1:35 - 2:45 RC/Migrator – Compare & Extract Options (Greg Parrish, CA)

2:45 – 2:50 BREAK

2:50 - 3:10 Detector for DB2 - Overview

3:10 - 3:15 Insight Performance Monitor for DB2 (All)

3:15 – 3:30 DTS DB2 V8 Migration Effort (All)

CA Database Management CA Database Management Solutions Solutions

for DB2 for z/OSfor DB2 for z/OS

Greg Parrish, Senior [email protected]

RC/Migrator for DB2 z/OS RC/Migrator for DB2 z/OS Compare & Extraction StrategiesCompare & Extraction Strategies

andandDetector for DB2 z/OSDetector for DB2 z/OS

5 © 2006 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Agenda- CA Database Management

- Performance

- Administration

- Backup & Recovery

- Unicenter® Database Command Center

- RC/Migrator

- Overview

- Compare strategies

- Extraction strategies

- Detector Overview

- CA Database Management Roadmap


True Multi-Database Management

- Single Vendor

- Database Vendor Neutral

- Support DB2 z/OS, LUW, Oracle, SQL-Server, Sybase

- Platform Independent

- Consistent “look and feel” across database platforms and database types

- Cross database functionality

- Advanced Database Functionality

- Fast data unloads / extracts

- Database reorganization

- Performance monitoring


CA Database Management for DB2 z/OS

- Mature technology- DB2 for z/OS v8 exploitation (current GA release

“r11.5”)

- Unicenter® Database PerformanceManagement Suite- Ensures optimal database performance and data

availability- Unicenter® Database Administration Suite

- Provides intelligent administration that reduces complexity, time and effort

- Unicenter® Database Backup/Recovery Suite- Increases backup efficiency and automates

recoverability, increasing IT responsiveness to the business

UnicenterUnicenterEnterprise

ManagementPortal

EnterpriseManagement

Portal

DatabaseManagement

DatabaseManagement

DatabasePerformanceManagement

DatabasePerformanceManagement

DatabaseAdministration

DatabaseAdministration

DatabaseBackup andRecovery

DatabaseBackup andRecovery

CA COMMONSERVICES™

CA COMMONSERVICES™


Performance Management Solutions for DB2 z/OS

Application PerformanceApplication Performance

Unicenter

Detector

Database PerformanceDatabase Performance

Unicenter® CA-Insight

Unicenter®

Subsystem Analyzer

Unicenter®

Index Expert

Unicenter®

Database Analyzer

Unicenter® Plan Analyzer

Unicenter® SQL Ease

Unicenter® Bind AnalyzerUnicenter® Bind Analyzer

Unicenter®

Data Compressor

Unicenter® Rapid Reorg®


Database Administration Solutions for DB2 z/OS

- Object/Database Maintenance

- Unicenter® RC/Query

- Unicenter® RC/Update

- Unicenter® RI Editor

- Unicenter® Partition Expert®

- Unicenter® Fast Index ®

- Data Extraction/Archive

- Unicenter® RC/Extract

- Unicenter® Fast Unload®

- Unicenter® Fast Load

- CA’s Migration Suite

- Unicenter® RC/Migrator

- Unicenter® RC/Compare

- Unicenter® RC/Merger

- Unicenter® RC/Extract

- Unicenter® Fast Unload®

- Unicenter® Fast Load

- Database Security

- Unicenter® RC/Secure®


Backup and Recovery Solutions for DB2 z/OS

Unicenter® Quick Copy

Secure and Full Backups

Fast backups with minimal impact to availability

Provide fastest recovery possible

Incremental

Backups

Backups

Unicen

ter

Log C

ompre

ss

Unicenter®Log Compress

FullConsistent

Backup

Unicenter® Merge/ModifyTM

Complete Analysis and Recovery

Unicenter® Recovery Analyzer®Unicenter® Fast Recover®Unicenter® Fast Check®

Application Recovery

Unicenter® Log Analyzer®


CA DB2 “Value Pack” - Included when you license any one of the CA DB2 Products

- Script processing (Batch Processor)- Interface into JES, processes data sets containing SQL to dynamically call DB2 utilities and

application programs, execute DB2 (DSN) commands

- Thread termination/Online ZPARMS- Terminates problem DB2 threads safely without disrupting applications or end users- Can perform dynamic DSNZPARM updates & set DSNZPARMS without recycling DB2

- RI management- Tracks, organizes, manages DB2 system-and application-enforced RI relationships

- Utility job generation- Convenient and efficient facility for submitting on demand utility requests

- Interactive SQL processing (ISQL)- Test SQL statements without pre-compiling and executing the entire program

- DB2 command processor- Scrollable, offers command syntax help, stores last 15 commands

- Alternate catalog mapping (ACM)- Redirects catalog queries to shadow tables, or to views defined over the system catalog tables

- Explain Table Conversions- Convert the PLAN_TABLE, DSN_STATEMNT_TABLE, DSN_FUNCTION_TABLE explain tables on a

specific DB2 subsystem to the DB2 V8 format by generating ALTER statements to add or alter columns as necessary


Distributed DB Management Tools for DB2 LUW, Oracle, SQL Server, Sybase

- Unicenter® Database Performance Management Suite- Unicenter® Insight for Distributed Databases

- Unicenter® Database Performance Management- Unicenter® NSM Database Performance Management Option

- Unicenter® Database Analyzer- Unicenter® TSreorg

- Unicenter® Database Administration Suite- Unicenter® Enterprise DBA

- Advanced database administration- Scalable and high-performance

- Unicenter® SQL-Station- Innovative GUI-based application-development environment- Create, view, run, develop, maintain, and interact with database objects- Also supports DB2 for z/OS!

- Unicenter® Fast Unload- for Oracle, DB2 LUW

- Unicenter® Database Backup/Recovery Suite- Unicenter® Log Analyzer- BrightStor® Enterprise Backup


Database Management Solutions for IMS- Release r11 = IMS 9.1 toleration and exploitation

- Unicenter® Database Performance Management Suite- Unicenter® Database Analyzer for IMS – Pointer Checker / Analyzer / Pointer Fixer / Control

Block Validator for FF and DEDBs- Includes Unicenter® Randomizer Analysis Program for HDAM, DEDBs, HALDB DBs

- Unicenter® Database Organizer - Unload / Reload / Format / Extract of/from FF and DEDBs- Includes Unicenter® High Performance Online Reorg

- Unicenter® DC Monitor Extension - Monitor Extension for FP- Brightstor® Compress for IMS – Data compression product

- Unicenter Database Administration Suite- Unicenter® Secondary Index Builder - Index Builder of FF databases- Unicenter® Secondary Index – Create / maintain secondary indexes Builder of FP databases

- Unicenter Database Backup/Recovery Suite- Unicenter® Database Copier - Image Copy of FF and DEDBs- Unicenter® High Performance Recovery – Recovery and/or Change Accumulation of FF and

DEDBs


Data Modeling Solutions

- AllFusion® Data Modeling Suite- AllFusion® ERwin® Data Modeler

- Heterogeneous database and data warehouse design and generation

- Supports many different databases!- AllFusion® Process Modeler

- Integrated functional, work-flow and dataflow modeling- AllFusion® Model Manager

- Collaborative model access and version management- AllFusion® Data Model Validator

- Automated schema validation and diagnostics- AllFusion® Saphir Option for ERP

- Metadata discovery and ERwin model generation for PeopleSoft, PeopleSoft OneWorld, SAP R3/BW, and Seibel CRM

- AllFusion® Model Navigator- Read only process/data model viewing and analysis


Unicenter Database Command Center

- A single database command center- Browser based – “BUI”- For all CA database management products- Supports major database types

- DB2 LUW & z/OS, Ingres, Oracle, SQL Server, IMS…- On major server platforms

- z/OS, Linux, UNIX, Windows- Intelligently automates database admin tasks, regardless of platform

- Catalog queries- Data queries- Alterations- Comparisons

- Common services integration and automation technology - Enables self management capabilities- Enables integration and communication across CA technologies- Enables integration to third-party product technologies

- Free!

- http://www3.ca.com/Solutions/Product.aspx?ID=5714


Unicenter® DCC – a Central Point of Control


Efficient Advanced Search Filters


Easily Perform Database Administration Tasks

- In context menu

- Cross Platform Support

- Consistent look and feel

DB2 and Oracle


CA DB2 z/OS Tools Licenses at State of CA Prior to February 2006

Teale FTB HHSDC

DATABASE ANALYZER

DATABASE ANALYZER DATABASE ANALYZER

DETECTOR

FAST UNLOAD FAST UNLOAD FAST UNLOAD

PLAN ANALYZER PLAN ANALYZER PLAN ANALYZER

RC/COMPARE RC/COMPARE RC/COMPARE

RC/MIGRATOR RC/MIGRATOR RC/MIGRATOR

RC/QUERY RC/QUERY RC/QUERY

RC/UPDATE RC/UPDATE RC/UPDATE

RC/SECURE RC/SECURE

RECOVERY ANALYZER RECOVERY ANALYZER

GOVERNOR FACILITY

INSIGHT FOR DB2

RC/EXTRACT


RC/Migrator for DB2 for z/OS - Overview

- Unicenter® RC/Migrator® for DB2 for z/OS automates the movement of DB2 objects from one DB2 environment to another (such as from test to production), relieving administrators from having to perform complex, time-consuming and error-prone tasks.

- Unicenter® RC/Migrator® allows you to:- shape the migration or alteration to fit specific requirements

- decide what will be included- determine when the migration or alteration should be performed

© 2006 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Advantages of Using RC/Migrator

ProvidesProvidesDDL BackupDDL Backup

IncreasesIncreasesProductivityProductivity

PerformsPerformsImpact AnalysisImpact Analysis

Maintains DB2 Maintains DB2 System IntegritySystem Integrity

FacilitatesFacilitatesGlobal ChangesGlobal Changes

PreservesPreservesReferential IntegrityReferential Integrity

ProvidesProvidesRecovery OptionRecovery Option

AutomatesAutomatesSubsystem andSubsystem and

File ComparisonsFile Comparisons


Using RC/Migrator, you can: - Create, update, delete, display, copy, analyze, and execute a “strategy”

- Permit migration of DB2 objects, security, and data between DB2 subsystems or within the same DB2 subsystem

- Alter the definition of one or more DB2 objects with all changes automatically propagated to dependent objects, including views and indexes

- Process strategies and produce executable output to perform the requested migration, alteration, or comparison

- Execute the output from the processed strategies in online or batch mode and produce a complete audit trail

- Track the execution of analysis and execution runs - Merge DDL files and check them for syntactical errors or

compare and execute DDL files in batch mode- Integrate with RC/Compare to compare and synchronize

DB2 structures and related dependent structures- Integrate with RC/Extract to perform analysis on

referentially intact subsets of data, and create related objects


RC/Migrator – Auxiliary Product Components

- Unicenter® RC/CompareTM

- A Compare Type strategy (‘c’) allows RC/Migrator to compare and synchronize DB2 structures, including dependent structures such as indexes, views, synonyms, aliases

- Comparison options include:- Subsystem : Subsystem (same or different subsystems; local and/or remote)- Subsystem : DDL- DDL : Subsystem- DDL : DDL- Automapping - compare a logical design with a physical design

- Unicenter® RC/Merger®

- With an RC/Merger “Move” Analysis, RC/Migrator can move or copy objects (tablespaces and indexes) from one DB2 subsystem to another without incurring the overhead of unloading and loading the data

- Unicenter® RC/ExtractTM

- An Extraction Type strategy (‘r’) allows RC/Migrator to extract referentially-intact subsets of data from one or more DB2 objects on one system to other DB2 objects on the same or different systems.

- The tables you designate, the associated databases, tablespaces, and any dependent indexes, views, and aliases will all be created

- Unicenter® RC/Migrator® migrates the objects- Unicenter® RC/ExtractTM handles the data


RC/Compare - Terminology / Features

- MASK SET- RULES SET- GLOBAL CHANGES- ICL- COPY GROUP- UPDATE OPTIONS- MERGE DDL- Xclude OPTIONS (for TARGET)- Batch Compare Automapping (Only DDL-DB2) - Group Migration as opposed to ICL Group


MASK Set

BLANK has same meaning as ”=”

RENAME Objects :DO use ”=” or ” ” prior to rename

Determines SOURCE and TARGET object PAIR’s.

In other words – HOW to MAP Source and Target if different CREATOR and/or OBJECT NAME – BEFORE COMPARE


RULES

The Easy method :

Y=Source attribute will be used and applied on TARGET

N=Target KEEPs its value no matter what attribute SOURCE has.

Official description :

Must COMPARE be done on the ATTRIBUTE ? – Happens AFTER MASK-SET has MAP’ed Source and Target


GLOBAL CHANGESAre applied for NEW objects – objects which do not exist on TARGET


ICL

Incremental Change Language:

Pseudo DDL , describes shortly WHAT is being changed.

It is possible to CREATE ICL statements yourself. Syntax in RCM Guide.


COPY GROUP – 2 themes

•Copy Group Analysis – ICL being analysed against one or more TARGET’s

•Copy Group Migration – Like an ordinary Migration Strategy but can have more than ONE TARGET (see last foil for details)

- A couple of differences between the two:- Migrations have their OWN Global Change Set for ATTRIBUTE

changes- Migration Targets can reside on different LPAR’s (controlled

via .CONNECT commands) – manually port to remore loacations necessary.

- TARGET-DB2 is NOT accessed for Migration – for ICL Group Analysis TARGET IS accessed


ICL COPY GROUP Analysis ONE to MANY

ANALYSIS

A number of TARGET DB2’s in one analysis.

DB2’s must be on same LPAR.

COPY-ID : 4 byte – you pick a name.

Global Changes specified for each COPY-ID / TARGET – ONLY CREATOR + NAME !!!!!!

Utility Options can also specified to be TARGET specific.

OPTION 7 from

RCM Profile


Merge DDL

Concattenate DDL files to ONE member

–

Result – ordered by OBJECT TYPE, but individual sequence in DDL-members are maintained.


EXCLUDE OPTIONS

Overtype

”A” with ”X” and you can exclude......


Batch Compare Automapping


ICL , Copy Group and Global Changes

- Global Changes will within a COPY GROUP be apply’ed for INCOMING ICL.

- Global changes specified WITHIN the COPY GROUP apply to INCOMING ICL only and applies to OBJECT NAME and CREATOR only.

- This means - RENAME happens BEFORE any other attribute changes take place to Target objects (eg. Column changes, additional Index columns,......)


ICL , Copy Group and Global Changes

- How does it WORK now with ICL ?

- For ALTER+DROP – Object existence is checked PRIOR to apply of Global changes

- For CREATE – objects NON existence is checked PRIOR to apply of Global changes


ICL - Global Changes

NEW DDL

OLD DDL

COMPARE

ICL Statement

s

GLOBAL CHANGES for ATTRIBUTES

ANALYSE

DDL etc. To be executed in TARGET-env.

DB2 TARGET(s)

GLOBAL CHANGES in COPY GROUP will ONLY be applied for CREATOR and OBJECT NAME.

--------------------------------

Only one set of Global Changes can be specified for Attribute changes. Attribute changes can NOT be specified within a Copy Group – and will be applied to ALL Copy-ID’s in the Copy Group.

--------------------------------

Utility Options can be different for every COPY-ID within a COPY GROUP.

GLOBAL CHANGES for NAME/CREATOR in COPY GROUP

MASK-

SET

SeeNextPage

please

RULES-SET


G(roup) analysis for ICL

GLOBAL CHANGES for ATTRIBUTE’s

GLOBAL CHANGESfor NAME and CREATOR

Do NOT mix NAME and CREATOR

Glbl. Chg. InBOTH places.

You can do it but it is NOT

Recommended.


Analysis Output

- When Analyzing strategies within RCM, you can choose between :

- PDS – output goes to a PDS-member- Managed Output – output goes to a DB2-table

- In general – Managed output makes sure you have output from EVERY analysis.

- Using COPY-GROUP analysis – it is highly recommended to use managed Output, since Analysis output PDS-members will be generated as the FIRST 4 byte of STRATEGY concattenated with the COPY-ID.


Copy Group Migration

Group Migration

Group has 3 Targets/Copy-ID’sEach with own GlobalChange Set

Each COPY-ID

get its ownWorklist/Output.


How do you use RC/Compare?

- Click on me and I'll walk you through the process of creating a compare strategy

- (of course, this will only work on Greg’s PC)

- Refer also to your handout


NOW… Let’s discuss RC/Extract…

- First… Do you agree with this ?

- Extracting referentially-intact data is a challenging and cumbersome process- First you need to obtain a data sample from a parent table, then use this

parent data for foreign key column values to extract data from child tables- This is further complicated by complex parent/child relationships that cascade

down many child tables and refer back up to parent tables at higher levels

- This leads to enormous amounts of time dedicated to data extraction tasks, and increased error rates!


Extracting Related Subsets of Data

- Need to move database object definitions

- Need to move related subsets of data

- Need to maintain relationships

- Enormous amount of work

- Databases are complex

- Multiple migrations normally required

- Don’t want to re-specify relationships



Moving database definitions and data is time consuming and error prone.The complexity of today’s databases requires a smart

and automated tool.

Production Test

Reporting

Objects and Data

Objects and Data


Without automation, the user must know the relationships and then manually get the data.

Unicenter RC/Extract automates this process!!

Without automation, the user must know the relationships and then manually get the data.

Unicenter RC/Extract automates this process!!


CustomerTable

OrderTable

ShippingTable

Cust 4661

Ord 1193

Ord 0192

Ship LB01

Ship LB02

Objects

Data


RC/Extract for DB2 for z/OS

- When a subset of production data is causing problems, it needs to be isolated and tested without creating additional problems with your production system

- With RC/Extract, all referentially-related problem data can be easily isolated, selected, and copied to a test subsystem for further analysis.

- RC/Extract can isolate and test as little as a single instance of a problem!


RC/Extract for DB2 for z/OS- Automatically determines related objects and extracts the data - Easy to use - designed to be used by both DBAs and Developers

- Multiple interfaces- Command Center provides detailed control

- Designed for the Advanced User- Contains more functionality- Very similar to a Strategy Services screen

- Wizards provide simplicity- Can be used by those familiar with the database design and those not- Uses referential integrity relationships

- System defined RI- Application defined RI

- RI Manager component of the CA Value Pack for DB2 is part of the extract engine

- Advanced rules base- Correctly handles duplicates - Deals with overflow conditions- Does not require primary keys


Sophisticated Extraction Engine

- Reduces time and error rates

- Advanced rules base handles many conditions that would require user intervention

- Efficiently extracts both large and small sets of data

- SQL based extraction for small sets

- Utility based extraction for large sets

- Extracted data can be encrypted to mask sensitive information


Archival Solution

- Remove unneeded DB2 data to save space and improve performance

- Extract related data and object definitions and save to a file

- Delete data from source tables

- If data is needed in the future, can restore complete related set even if table definitions have changed


Building Block Approach

Extract/Load Interface

Command Center Interface

RC/Migrator Interface

Integration

Extract Engine (SQL, Fast Unload)

Source/Target and Extract Object

Services

SQL Engine ( ease of use) RC/Object


Integrated Solution…

- Integrated with Unicenter RC/Migrator- Reduces time and error rates- Plan the object and data move- RC/Migrator offers RC/Extract strategies

- RC/Extract is a stand-alone product, but can also be invoked directly from RC/Migrator!

- One process that manages…- Object selection- Object migration- Data selection- Data extraction

- (Also integrated with RC/Update, Fast Unload, Fast Load)


RC/Extract - RC/Migrator Integration

- “R” Strategy type in RC/Migrator- similar to a table level Migration Strategy

- Merges the power of an RC/Migrator Analysis with the referential extraction intelligence of RC/Extract!

- RC/Extract Source Definition is embedded in RC/Migrator’s strategy

- RC/Extract Source Definition determines the tables and handles the data

- RC/Migrator handles the DDL and other Utilities DDL only generation Impact Analysis Enhanced Global changes Recovery


RC/Extract - RC/Migrator Integration(cont’d)

- RC/Migrator not only creates the tables you designate, but also creates the associated databases and tablespaces as well as any dependent indexes, views, and aliases

- This creates a powerful one-two combination, with RC/Migrator migrating the objects, and RC/Extract handling the data


RC/Extract Process

Extract Functions

1. Define Extract In this step, you create a Source Definition, which defines the objects

to extract data from and the rules for extracting the data. The Source Definition is stored in the RC/Extract Registry.

2. Perform Extract This step initiates the extraction process.

The inputs to the extraction process are a Source Definition and the name of a dataset that will be used to contain the Extract Object.

The output of the Extract Process is the Extract Object, which contains control information and the extracted data.


RC/Extract Process (cont’d)

Load Functions3. Define Targets

In this step, you create a Target Definition, which defines the target subsystem and the objects in which the data will be loaded.

The target definition maps each object from the source to an object on the target subsystem.

Target Definitions are stored in the RC/Extract Registry.

4. Perform LoadThis step initiates the load process. The inputs to the Load process are an Extract Object, which

contains the data to be loaded, and a Target Definition, which defines the target subsystem and the objects in which to load the data.


Creating an Extraction StrategyGet into RC/Migrator Strategy Services…


Choose a Start table…


Can select related tables

Note sampling and, Extended

query cabability

Can limit rows


Selecting related tables


Once related tables selected, f3 to save strategy


Analyze your Extraction strategy


Update your options…


Note the inclusion of “RC/Extract Options”


At this point, you can update RC/Extract options


RCX Options

• RC Extract Profile Toggle Wizard DDL extraction Automatic entire RI select Auto create target object Load IBM / Fast Load

SQL Load• Empty target before load• Update existing rows• Commit frequency

Fast Load• Resume / Replace• SYSERR/SYSMAP• Ignore marked errors during load

IBM Load• Resume / Replace• Inline Copy• Log DATA• Enforce Constraints• Sortkeys• SYSERR/SYSMAP• SYSDISC


Might also want to update Global Changes…


We want to create a new target database mirrored from our source


Analyze the strategy (in Online or Batch) to create extract cards and DDL


Analysis DDL

- Click me to see Analysis DDL created- (of course, this will only work on Greg’s PC)


Fast Unload Integration

–Fast Unload (PFU) Support –allows for fast data extraction– for large extractions–batch processing only–ability to extract from a full Image Copy –ACCESSMETHOD parameter allows extraction via either

SQL or PFU–KEYSMODE parameter used to determine storage

technique used for keys (RCX maintains a list of keys for rows that have already been extracted)

–Can create a Split Extract Object consisting of multiple data sets

–Can prevent multiple writing of duplicate rows of the extract object


“SQL” (Default) or “PFU”

“NO” (Default) “YES” or “*”


Detector for DB2 for z/OS - overview

-Detector is a powerful, comprehensive DB2 application performance analysis solution that:

- provides unprecedented insight into DB2 application workload and resource use

- helps to accelerate the cumbersome task of identifying poorly performing application components

- allows you to view low overhead DB2 accounting information for DB2 activity


Detector helps you to…

– Identify Most Resource Intensive SQL

– Monitor performance and resource usage down to the SQL level by

– Identifying the most resource intensive SQL statements quickly and inexpensively

– Enabling continuous monitoring of static and dynamic SQL

– Providing historical and real-time analysis of application performance

– Dynamic SQL collection for monitoring SAP, Peoplesoft environments

– Focus your tuning efforts where they’re needed most


- Detector can watch entire DB2 subsystems at an affordable cost of 5% - 3% overhead

- Detector quickly shows you your 10 worst DB2 SQL statements, packages, DBRMs and plans that are executing in your enterprise

- Detector tracks both dynamic and static DB2 SQL statements

Detector


Detector

- Detector Capabilities

Current or historical intervals can be viewed

Any interval length may be selected

All major accounting values are displayed

Screen displays at any level of granularity, profile, plan, DBRM/package, even right down to the individual SQL statement level

View Current Activity Too ....

SQL Trace Capabilities

Sort any display on any value desired to find the most expensive or resource intensive items


Detector

- Dynamic SQL Support (Current and Historical)

Collect and store SQL text and userid

Performance thresholds for retention

- SQL Error Analysis (Current and Historical)

Collect and store SQLCODE/SQLCA

View by userid or by SQLCODE

- Reporting Flexibility

Externalizes data to flat file to load to DB2 table

Detail line command to get formatted panel of all data on a line


Detector

- Let’s do a quick live demo…


DB2 9 and Beyond… r12

- CA is an IBM Business Partner- Deeper DB2 V8 exploitation across the products

- As V8 is the largest release ever, feature support is being prioritized based upon customer input www.ca.com/db2

- Products getting ready for web-based UI – aka “BUI”- Continue to deliver on advanced technology across our products- Continue to improve quality and installation experience

- r12 in development, will support DB2 9- We have been gathering requirements from ESP sites and our beta

sites and development is being prioritized using this input

http://www.ca.com/db2


Major Releases – r12

- Unicenter Database Management r12 for DB2 for z/OS

- Any DB2 for z/OS v8 items still remaining

- Exploitation support for DB2 9

- Integration of some DB2 for z/OS products with the Database Command Center

- Wide ranging targeted enhancements across the product line based upon prioritized feedback from customers and CA field personnel


CA’s Commitment to DB2 for z/OS

- The Mainframe as a platform is strategic to CA and Enterprise Systems Management (ESM) and we continue to invest heavily in this space

- Database Management is one of the core competencies for ESM

- Database management across all of IT is at the heart of CA’s corporate strategy of Unify and Simplify IT Management

- Continued strong growth in the mainframe and DB2 enables us to continue to have a solid and healthy business

- As a result, we are increasing our investment in the team and in mainframe resources to improve upon our time to market with database support and new product features

- See http://www3.ca.com/Files/SupportingPieces/statement_of_support.pdf for commitment of support for DB2 9

http://www3.ca.com/Files/SupportingPieces/statement_of_support.pdf

http://www3.ca.com/Files/SupportingPieces/statement_of_support.pdf


CA Database Management Vision- Complete

- Database support is critical- DB2, IMS, Oracle, SQL Server- Distributed and z/OS

- Suites for comprehensive database management- Autonomic database management

- Integrated- Unified database management from a browser interface

- Across all database management products- Oracle, DB2 for LUW & z/OS, SQL Server, IMS, …- Cross-platform — Linux, UNIX, Windows, z/OS

- Launch in context into other tools- Cross product integration via the MDB and launch in context

- Open- Support for other vendor tools wherever possible

- Examples: Unicenter RC/Migrator, Unicenter Database Analyzer for DB2, Unicenter Recovery Analyzer

- Utilize partners as needed to fill in gaps


CA Database Management Strategy

- Advanced technology, integration and automation for large complex databases

- Stand alone or integrated offering extended functionality and value

- Multi-platform support for

- DB2 for z/OS, DB2 for Linux, Unix, Windows, IMS, Oracle, MS SQL Server databases

- For more information visit

- www.ca.com/databasemanagement

- Your local CA sales representative


For More Information- SupportConnect

- eNews signup http://supportconnectw.ca.com/enews.asp - Product news and PTFS downloads - Contact your Customer Advocate for further information

- New database management whitepapers- ca.com/db

- Multi-Platform support and trial downloads- Database Command Center - supports DB2 LUW & z/OS, Ingres,

Oracle, SQL Server, IMS on z/OS, Linux, UNIX, Windows- Intelligently automates database admin tasks, regardless of

platform- Unicenter Database Performance Management - supports DB2

LUW, DB2 for Linux for z/OS, Oracle, MS SQL Server, Sybase- Unicenter SQL-Station v7 release - supports DB2 z/OS, DB2 LUW,

Oracle, MS SQL Server, Sybase- To obtain

- The Unicenter® Database Management trial CD, DB2 for z/OS v8 poster or DB2 for z/OS v8 reference guide, contact your local CA sales representative or call 1-866-573-3435

84

Thank You…..

• Your participation is very much appreciated!

• Please don’t forget to complete and hand in your evaluation surveys.

αíß

Documents

Transcript of αíß

*αí*ß

Documents

Transcript of *αí*ß

αíß

Transcript of αíß