Transcript Unicenter Database Management for DB2 for z/OS

New from the CA
Database Management
Labs
1
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Agenda






Database Management
Technology Drivers
CA’s Database Management Vision
Immediate future plans
… and later….
Summary
2
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Committed to Database Management
 Major/maintenance releases
 Past 12 months - 60+ products, mainframe & distributed
 Product Advisory Councils (PACs)
 Support of national and regional user groups
– CA is on the Board of Directors…
 IDUG, IOUG, PASS
– Supports regional user groups
 Sponsorships, speakers, facilities, etc
 Partner of major database vendors
– IBM, Oracle, Microsoft
3
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
CA Database Management Vision
 Single management console — GUI, browser
– Across all DB Mgmt products
– Oracle, DB2 LUW & z/OS, SQL Server, IMS, …
– Cross-platform — Linux, UNIX, Windows, z/OS
 Autonomic database management
 Integrated across brands
 Complete solutions
– Suites for comprehensive management
4
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
CA Database Management 2004
 Unicenter Database Management – Feb - April
–
–
–
–
IMS for z/OS
DB2 for z/OS V8 – Beta
CA Productivity Pack for Oracle
DB2 UDB management
 Distributed – Beta August ’04
 Priority Enhanced Oracle 10g and DB2 LUW




Integrated SQL Server offering beyond June
Sybase - maintain
CA Productivity Packs
First browser based console
– Subset of tools…more in 2005
5
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Performance/Reliability/Management
Database Technology and Management
Multiple Organizations
DBAs
Single Organization
DBAs
Very Large Databases
Multiple
Databases/Platforms
Single Database
Rows
Columns
Unified
DBAs
Object Relational
Capabilities
Unstructured Data
HTML, XML, Images
High Availability
Time
6
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Database Management Drivers





Very large databases
Increasing complexity
Cross-database/cross-platform management
24 x 7 x 365 availability
Total cost of ownership
7
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Very Large Databases
Competitive
Environments
Cost Reductions
of Storage
Future
Driving Increase
Internet Transaction Rates
Detailed Data
Historical Analysis
Partner Information
Present
Competitive pressures are
driving companies to capture
significantly more detailed data
that in turn is feeding the
tremendous database growth
Past
x
10x
8
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
20x – 50x
Database Complexity
ERP Applications
SAP
PeopleSoft
BAAN
Database Objects
Complex Relationships
Partners
Legacy Systems
Data Warehousing
Coordinated Systems
Multiple Databases
Multiple Platforms
Advances in DBMS
Technology
Unstructured Data
Database
Complexity
9
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Cross-Database/Cross-Platform
Over 90 percent of organizations are using two or more
database types. Single DBA organizations are now managing
multi-database and multi-platform environments.
Database Administration
organizations are
unifying across
databases and platforms Oracle
DB2
SQL Server
Linux
Database
Administrators
UNIX
Ingres®
Sybase
z/OS
Advantage CA-IDMS®
Advantage CA-Datacom®
10
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
CA Database Management Value Proposition
 Unified database management
– Multi-database support
 Oracle, DB2, SQL Server, IMS, …
– Cross-platform — Linux, UNIX, Windows, z/OS
 Advanced technology
– Integrate within database management
– Leverage across brands
– Complete automation
 Complete solutions
– Comprehensive management from one vendor
11
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Database Management
Strategy
12
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Unified Database Management
 One console
– Browser based, thin client – where appropriate
 SQL Tuning/Debugging UI intensive - not appropriate
 Multi-database
– Oracle, DB2, SQL Server, Ingres, IDMS, Datacom
 Multi-platform
– Unix, Windows, Linux, z/OS
 Product consolidation
– Market/integration is driving comprehensive tools
– Incorporating multiple tools into single products
13
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
14
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Database Support
 Supporting database versions
– New releases will support the current databases versions
– Sybase not a focus
 Oracle
– 10g support being delivered
– Older Oracle versions will not be supported
 MS SQL Server
– Multiple products delivered in last 9 months
 DB2 family
– New cross platform capabilities – z/OS and LUW
– DB2 UDB LUW
 V8.x development – new products/features/enhancements
 Linux support – Intel and z/OS
– DB2 z/OS
 Unicenter Database Management r11 for DB2 V8 z/OS beta
 IMS V9 Early Support program
15
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Unicenter Database
Management for
Distributed Databases
16
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
CA Productivity Packs
 Most comprehensive solution for managing Oracle
– Modeling
– Database Administration
– Performance Management
 CA Productivity Pack for Oracle
–
–
–
–
–
–
AllFusion ERwin Data Modeler
Unicenter Database Performance Management
Unicenter TSreorg
Unicenter SQL-Station
Unicenter Fast Unload
Unicenter Enterprise DBA
 Cost effective and simple packaging
17
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
New Releases
 Unicenter Database Management Portal
– Distributed products first to implement
 Unicenter DBA
– Basic management for databases
– Cross platform
– Oracle, DB2 LUW, DB2 z/OS, Sybase, SQL Server
 Unicenter Enterprise DBA
– Advanced database administration
– Scalable and high-performance
– Multi-database – Oracle, DB2 LUW
18
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
New Releases
 Unicenter SQL-Station
–
–
–
–
Comprehensive SQL development and tuning
Oracle, DB2 LUW, DB2 z/OS, SQL Server, Sybase
Virtual Index analysis
Integration with Unicenter Database Performance
Management v4.5
– Usability enhancements
 2004
–
–
–
–
Unicenter TSreorg
Unicenter Fast Unload
Unicenter Log Analyzer
Multiple new products
19
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Integration
 Integration - tremendous strength
– Will continue to be a focus – cross platform/brand
– Leverage inter-product integration to increase
productivity of staff
 In-context integration
– Increases productivity
– Base for autonomic management
– Supports on-demand
 Integration with cross brand technology
– ERwin, Harvest, BrightStor
20
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Unicenter Database
Management for
DB2 for z/OS
21
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
DB2 Performance Management Products
 Proactive and reactive DB2 performance management
– Low impact to high performance databases
 Unicenter TNG Agent and Integration
 Drill down capabilities
– Dynamic and Static SQL
– Host based or web based
 Expert recommendations via SQL Plan Analysis
– Improve SQL performance before you go to production
– Existing PLANS or PACKAGES or newly developed SQL
 Complete, lights out automation for DB2 object maintenance activities
– Run only the jobs necessary
– Object size trending and forecasting
 Index recommendations based upon actual application metrics
– Index Suite Recommendations
– What indexes to eliminate
 Increase availability with comprehensive reorg
– Offline and Online reorg in one tool
22
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
DB2 Database Administration Products
 Catalog Query based command center for DB2 object management
 Schema Create, Alter, Migration, and Comparison
– Global Changes
– Catalog to Catalog, DDL to DDL, DDL to Catalog
– Swiss Utility support
 Table Browse and Edit
– Individual table/view
– RI Subsets
 Security Administration
– Grant and Revoke Services
– User and App domain
 RI complete data movement
– RI Sets for test systems
– Row Archival
 High Speed Load of user data
 High Speed Unload of user and catalog data
23
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
DB2 Backup and Recovery Products
 High Speed Tablespace and Indexspace backup
– Shark and Symmetrix exploitation
– Wildcarding and dynamic allocation of image copy datasets
 Change Accumulation of DB2 logs for faster recovery
 Image Copy creation without accessing the actual tablespace or
indexspace and maintaining full object availability
 Full and complete DB2 Disaster Recovery Automation
 High Speed DB2 object recovery
–
–
–
–
From “normal” image copies
Full pack backups
Lost DASD devices
Concurrent Index Rebuild
 Transaction backout and replay
 Concurrently check RI data relationships during recovery
 Log Auditing to analyze who is changing and looking at data
24
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
DB2 Performance - Highlights
 Full DB2 V8 toleration support
 V8 64-bit support above the bar
–
–
–
–







Bufferpools
EDM pools
DBDs
Compression Dictionary
Unicode Support across the board
Extended Addressability support for Detector collection data store
Unload End user and host variable data
FastSwitch Support on Online Reorg
999 Parts in Database Analyzer
LOBs in Online Reorg
Ability to create compression dictionary in Online Reorg
25
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
DB2 Administration - Highlights





Full DB2 V8 toleration
Unique Constraints – Migrator, Compare, Update
Comment on Index
LOB Support across that board including LOBs > 32K
Trigger Support
– RCQ Firing Sequence Report
– RC/Update and RC/Migrator






Improved Stored Procedure Support in Migrator
Dynamic Allocation of work files during Load
MQT Support within Load
Real Time Statistics within Load
Comma Delimited input in Load
RCX
– External Key File
– Parallel Load
26
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
DB2 Backup and Recovery - Highlights





DB2 V8 toleration support
LOB support in Copy and Recover
SYSLGRNX Update
Faster SNAP in PQC for RAID exploitation
Log Analyzer
–
–
–
–
93 Active Logs
10,000 Archive Logs
Online Schema
Long Names
 Recovery Analyzer
– Multi-Volume Archive Logs
– ERP DR Performance Improvements
27
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
and later….
 DB2 V8 exploitation across the products – a large part of
our effort for the next year
 As V8 is the largest release ever, feature support is being
prioritized based upon customer input – next slide for
what our customers have told us thus far
 Beta later in calendar 2004
 Customer survey link being placed on our web site
 We have been gathering requirements from ESP sites
and our beta sites and development is being prioritized as
such
 Products getting ready for web Based UI
 Continue to deliver on advanced technology across our
products
 Continue to improve quality and installation experience
28
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
V8 Feature Priority







64-bit storage constraint relief
Online Schema
> 254 parts
Unicode Catalog
Unicode Parsing
Long Names
All of that new SQL





Materialized Query Tables
Long Index Keys
Padded Indexes
2Mb SQL statements
Data Partitioned Secondary
Indexes
We would like to hear from you
on this – complete our
customer survey on
ca.com/db2
29
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
DB2 Products Miscellaneous
 Value Pack items continue to be enhanced
 Install process without SDM – native SMP/E
based install process
 Support Connect availability
 Continue to focus on queue reduction and
optimizing support
 New Education offerings for products
30
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Questions & Answers
31
© 2004 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.