DTS Introduction - PowerPoint PPT Presentation

Loading...

PPT – DTS Introduction PowerPoint presentation | free to download - id: 242eac-NDYzN



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

DTS Introduction

Description:

( CA) ... CA Database Management for DB2 z/OS. Mature technology ... Enables integration and communication across CA technologies ... – PowerPoint PPT presentation

Number of Views:204
Avg rating:3.0/5.0
Slides: 84
Provided by: jak955
Learn more at: http://www.dts.ca.gov
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: DTS Introduction


1
(No Transcript)
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/

3
Todays Agenda
130 - 135 Welcome and Orientation (Alisa
Claypool, DTS) 135 - 245 RC/Migrator
Compare Extract Options (Greg Parrish,
CA) 245 250 BREAK 250 - 310 Detector
for DB2 - Overview 310 - 315 Insight
Performance Monitor for DB2 (All) 315
330 DTS DB2 V8 Migration Effort (All)
4
CA Database Management Solutions for DB2 for
z/OS
RC/Migrator for DB2 z/OS Compare Extraction
Strategies and Detector for DB2 z/OS
Greg Parrish, Senior Consultant gregory.parrish_at_ca
.com
5
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

6
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

7
CA Database Management for DB2 z/OS
Unicenter
  • 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

Enterprise Management Portal
Database Management
Database Performance Management
Database Administration
Database Backup and Recovery
CA COMMON SERVICES
8
Performance Management Solutions for DB2 z/OS
Application Performance
Unicenter CA-Insight?
Unicenter Subsystem Analyzer?
Unicenter Index Expert?
Unicenter Data Compressor
Unicenter? Detector?
Unicenter Database Analyzer?
Database Performance
Unicenter Rapid Reorg
9
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
  • CAs 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

10
Backup and Recovery Solutions for DB2 z/OS
11
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

12
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

13
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

14
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

15
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!

16
Unicenter DCC a Central Point of Control
17
Efficient Advanced Search Filters
18
Easily Perform Database Administration Tasks
  • In context menu
  • Cross Platform Support
  • Consistent look and feel

DB2 and Oracle
19
CA DB2 z/OS Tools Licenses at State of CA Prior
to February 2006
20
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

21
Advantages of Using RC/Migrator
Provides DDL Backup
PerformsImpact Analysis
FacilitatesGlobal Changes
Maintains DB2 System Integrity
PreservesReferential Integrity
IncreasesProductivity
ProvidesRecovery Option
AutomatesSubsystem andFile Comparisons
22
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

23
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

24
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

25
MASK Set
Determines SOURCE and TARGET object PAIRs. In
other words HOW to MAP Source and Target if
different CREATOR and/or OBJECT NAME BEFORE
COMPARE
BLANK has same meaning as
RENAME Objects DO use or prior to rename
26
RULES
Official description Must COMPARE be done on
the ATTRIBUTE ? Happens AFTER MASK-SET has
MAPed Source and Target
The Easy method YSource attribute will be
used and applied on TARGET NTarget KEEPs its
value no matter what attribute SOURCE has.
27
GLOBAL CHANGES
Are applied for NEW objects objects which do
not exist on TARGET
28
ICL
It is possible to CREATE ICL statements yourself.
Syntax in RCM Guide.
Incremental Change Language Pseudo DDL ,
describes shortly WHAT is being changed.
29
COPY GROUP 2 themes
  • Copy Group Analysis ICL being analysed against
    one or more TARGETs
  • 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 LPARs
    (controlled via .CONNECT commands) manually
    port to remore loacations necessary.
  • TARGET-DB2 is NOT accessed for Migration for
    ICL Group Analysis TARGET IS accessed

30
ICL COPY GROUP Analysis
ONE to MANY ANALYSIS
A number of TARGET DB2s in one analysis. DB2s
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
31
Merge DDL
Concattenate DDL files to ONE member Result
ordered by OBJECT TYPE, but individual sequence
in DDL-members are maintained.
32
EXCLUDE OPTIONS
Overtype A with X and you can exclude......
33
Batch Compare Automapping
34
ICL , Copy Group and Global Changes
  • Global Changes will within a COPY GROUP be
    applyed 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,......)

35
ICL , Copy Group and Global Changes
  • How does it WORK now with ICL ?
  • For ALTERDROP Object existence is checked
    PRIOR to apply of Global changes
  • For CREATE objects NON existence is checked
    PRIOR to apply of Global changes

36
ICL - Global Changes

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-IDs in the
Copy Group. -------------------------------- Utili
ty Options can be different for every COPY-ID
within a COPY GROUP.
RULES-SET
NEW DDL
OLD DDL
COMPARE
ICL Statements
MASK- SET
See Next Page please
GLOBAL CHANGES for NAME/CREATOR in COPY GROUP
ANALYSE
DB2 TARGET(s)
GLOBAL CHANGES for ATTRIBUTES
DDL etc. To be executed in TARGET-env.
37
G(roup) analysis for ICL
Do NOT mix NAME and CREATOR Glbl. Chg. In BOTH
places. You can do it but it is NOT Recommended.
GLOBAL CHANGES for ATTRIBUTEs
GLOBAL CHANGES for NAME and CREATOR
38
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.

39
Copy Group Migration
Group Migration
Group has 3 Targets/ Copy-IDs Each with own
Global Change Set Each COPY-ID get its
own Worklist/ Output.
40
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 Gregs PC)
  • Refer also to your handout

41
NOW Lets 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!

42
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
  • Dont want to re-specify relationships

43
Extracting Related Subsets of Data
Moving database definitions and data is time
consuming and error prone. The complexity of
todays databases requires a smart and automated
tool.
44
Extracting Related Subsets of Data
Without automation, the user must know the
relationships and then manually get the
data. Unicenter RC/Extract automates this
process!!
45
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!

46
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

47
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

48
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

49
Building Block Approach
Extract/Load Interface
Command Center Interface
RC/Migrator Interface
Integration
Source/Target and Extract Object Services
Extract Engine (SQL, Fast Unload)
SQL Engine ( ease of use)
RC/Object
50
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)

51
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/Migrators 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

52
RC/Extract - RC/Migrator Integration(contd)
  • 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

53
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.

54
RC/Extract Process (contd)
  • Load Functions
  • 3. 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 Load
  • This 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.

55
Creating an Extraction StrategyGet into
RC/Migrator Strategy Services
56
Choose a Start table
57
Can select related tables
Can limit rows
Note sampling and, Extended query cabability
58
Selecting related tables
59
Once related tables selected, f3 to save strategy
60
Analyze your Extraction strategy
61
Update your options
62
Note the inclusion of RC/Extract Options
63
At this point, you can update RC/Extract options
64
RCX Options
  • RC Extract Profile
  • Toggle Wizard
  • DDL extraction
  • Automatic entire RI select
  • Auto create target object
  • Load IBM / Fast Load

65
Might also want to update Global Changes
66
We want to create a new target database mirrored
from our source
67
Analyze the strategy (in Online or Batch) to
create extract cards and DDL
68
Analysis DDL
  • Click me to see Analysis DDL created
  • (of course, this will only work on Gregs PC)

69
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

70
SQL (Default) or PFU
NO (Default) YES or
71
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

72
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 theyre needed
    most

73
Detector
  • 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

74
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

75
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

76
Detector
  • Lets do a quick live demo

77
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

78
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

79
CAs 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 CAs 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/stat
    ement_of_support.pdf for commitment of support
    for DB2 9

80
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

81
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

82
Questions?
83
For More Information
  • SupportConnect
  • eNews signup http//supportconnectw.ca.com/enews.a
    sp
  • 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 dont forget to complete and hand in your
    evaluation surveys.
About PowerShow.com