Transcription
MIBMIBMIBMIBMIBMIBMIBMIBMIBMIBMIBMIbYour IBM Passport to DB2 Tools——IBM DB2 Tools for z/OSFor zSeries
ContentsIntroduction1Database Management Tools6Performance Management Tools18Data Governance Tools24Database Backup and Recovery Tools28
IntroductionThe IBM DB2 Tools for z/OS portfolioplays a significant role in the overall IBMdata management solution. They provideefficient management of DB2 resources,performance optimization, and reduction ofIT expenses.1
How can you best make useof your enterprise resources,industry information, applications,and infrastructure?概述2
3
Database Management Tools1. DB2 Administration Tool2. DB2 Object Comparison Tool3. DB2 High Performance Unload4. DB2 Utilities Suite5. DB2 Sort6. DB2 Automation Tool7. DB2 Utilities Enhancement Tool8. DB2 Cloning Tool9. DB2 Bind Manager / Path Checker1. Tivoli OMEGAMON XE for DB2Performance Expert2. Tivoli OMEGAMON XE for DB2Performance Monitor3. DB2 Buffer Pool Analyzer4. DB2 Query Monitor5. DB2 SQL Performance Analyzer6. Optim pureQuery Runtime7. Optim Query Workload TunerPerformance Management Tools4
Data Governance Tools1. Guardium for z2. DB2/IMS Audit Management Expert3. IBM Data Encryption for DB2 and IMS Databases1. DB2 Recovery Expert2. DB2 Log Analysis Tool3. DB2 Change Accumulation Tool4. DB2 Object Restore ToolDatabase Backup and Recovery Tools5
6
Still get headaches from huge andcomplicated data management issues?IBM DB2 Tools for z/OS make your lifeeasy!7
DB2 Database Management ToolsDB2 Administration Tool - Helps users easily alter schema for both batch andonline changes- Helps manage your DB2 subsystems, like displayingand modifying ZPARM parameters, etc.- Allows users to navigate the DB2 catalog quicklyand easily- Builds and executes dynamic SQL statementswithout knowing the exact SQL syntax- Helps build DB2 commands to execute againstdatabases and tables- Integrated with DB2 utilities to simplify the creationand execution of DB2 utility jobs- Helps to easily migrate objects, such as existingtables to hash accessValue to you:DB2 Administration Tool for z/OS enables the day-today tasks that are associated with managing a DB2database efficiently. It simplifies the complex tasksassociated with safely managing DB2 objects andschema throughout the application lifecycle with theleast possible impact to availability. Whether you'rea DB2 novice or an experienced professional, you'llappreciate the easy-to-use comprehensive featuresthat increase your productivity and the reliability ofyour DB2 objects.8
DB2 Database Management ToolsDB2 Object Comparison Tool - Compares and synchronizes DB2 structures fromdifferent sources- Generates reports showing compared objects- Creates jobs that apply or reverse changes- Offers a comprehensive, easy-to-use changemanagement process that provides an audit trail- Increases the efficiency with which users canaddress complex activities- Allows groups of users to work collaborativelyusing changes stored in one change managementdatabase- Supports application upgrades and enhancementsby keeping multiple database sources in syncValue to you:DB2 Object Comparison Tool for z/OS, used inconjunction with DB2 Administration Tool, simplifiesthe complex tasks associated with safely managingDB2 objects and schema throughout the applicationlifecycle with the least possible impact to availability.9
DB2 Database Management ToolsDB2 High Performance Unload - Creates multiple output files during a single unloadat minimal cost- Runs outside of DB2, so does not consumecompeting resources- Supports efficient migration from non-IBM tools- Can be launched from IBM DB2 Administration Toolfor z/OS- Increased support for image copies using partitions,including one output file per partition when using aglobal full image copyValue to you:DB2 High Performance Unload for z/OS is a flexible,easy-to-use product that provides a fast and efficienttool to unload and extract data for movement acrossenterprise systems or for in-place reorganizations.10
DB2 Database Management ToolsDB2 Utilities Suite - Data set level flashcopy suppor t to improveavailability and reduce CPU- Increased availability and consistency for CHECKDATA and CHECK LOB utilities- When used with DB2 Sort, significant CPU andelapsed time reductions during sort processing- Increased support for LOB and XML data, increasingavailability and removing restrictions- Toleration, exploitation and support of new DB2features from day one- Continued focus on performance enhancementsthat also reduce complexity and improve productivityValue to you:IBM DB2 Utilities Suite for z/OS is a comprehensiveset of tools for managing all DB2 maintenance tasks.They help you minimize downtime and reduce costs,while ensuring the highest degree of data integrity.11
DB2 Database Management ToolsDB2 Sort - Significant savings in elapsed time and CPU duringutility sort processing, especially LOAD, REORG, andRUNSTATS- Relief from application constraints of large volumesof data in highly-transactional workload performingnumerous insert, update and delete operations- Increased application availability by reducing thebatch window for utility maintenance- Continued commitment from IBM to deliver a DB2solution to reduce total cost of ownership (TCO)Value to you:DB2 Sort for z/OS provides high speed utility sortprocessing for data stored in DB2 for z/OS. It helpsyou improve sort performance, providing significantreductions in elapsed time and CPU usage, whileoptimizing overall system efficiency by exploiting theadvanced facilities of the z/OS operating system andSystem z.12
DB2 Database Management ToolsDB2 Automation Tool - Automates the execution of DB2 utilities such asCOPY, REORG, and MODIFY with space reallocationbased on user-specified thresholds- Allows staff to know what maintenance has beenapplied to which objects without manually checking- Consume less system resources such as DASD andCPU by automating routine maintenance utilities foronly objects that meet defined criteria- Provides control over utility job generation,including the order of execution of utility tasks tomeet application criteria- Referential Integrity (RI) capabilities that make iteasier to select objects for utility consideration andensure that related objects are includedValue to you:DB2 Automation Tool for z/OS automates commonDB2 maintenance tasks as well as generates JCLfor more complex tasks on one or more objects,reducing the use of system and staff resources.13
DB2 Database Management ToolsDB2 Utilities Enhancement Tool - Transparently cancel active threads and block newthreads on DB2 objects- Automatic sizing and creation of mapping tablesand mapping-table indexes for REORG TABLESPACEutility- A policy rule can block additional threads fromaccessing an object to avoid contention, allowing amaintenance utility to complete- Increased usability of IBM REORG, LOAD and CHECKDATA utilities by providing additional options thatincrease productivity and improve availability- Ability to establish and maintain company-wideDB2 utility syntax standardsValue to you:DB2 Utilities Enhancement Tool for z/OS helps DBAsto improve the usage of DB2 utilities and bettermanage threads.14
DB2 Database Management ToolsDB2 Cloning Tool - Clones DB2 subsystems, table spaces, or indexspaces to create up-to-date test environments- Automates the cloning process- Quickly copies DB2 data sets within a subsystem orto a different subsystem- Uses storage aware flashcopy technologyto minimize system outage and save on CPUconsumption by moving unload processes to thestorage processorValue to you:DB2 Cloning Tool for z/OS enables you to cloneDB2 systems or table spaces quickly and easily. Itautomates the cloning process to provide usableDB2 clones within minutes, boosting efficiency andfreeing up DBA time.15
DB2 Database Management ToolsDB2 Bind Manager / Path Checker - DB2 Bind Manager for z/OS automatically eliminatesunnecessary binds and processes only necessary DB2binds- DB2 Path Checker for z/OS enables you to identify,analyze and document in advance potential accesspath changes, without initiating bind processing- Path Checker and Bind Manager assist in allphases of migration to new versions of DB2 forz/OS including providing a performance baselineand identifying functionality changes that affectapplications prior to productionValue to you:DB2 Bind Manager for z/OS helps you minimize bindoperations, thus saving resources. DB2 Path Checkerfor z/OS helps you avoid costly performance issuesrelating to access path changes before they occur.Together, these products enable a smooth migrationfrom one DB2 version to another.16
17
18
Make your business an onDemandbusiness by using DB2 PerformanceManagement Tools that improveserviceability and availability.19
DB2 Performance Management ToolsT ivoli OMEG AMON XE for DB2 Performance Expert- Provides end-to-end response-time measurementcapability for SQL metrics as a component of the DB2application- Monitors, analyzes and tunes the performance ofDB2 subsystems- Improves productivity with robust views ofperformance- Identifies performance bottlenecks quickly andeasily by using predefined rules of thumb- Provi de s su bstan t i a l b re a d t h a n d d e p t h ofmonitoring DB2 environments by combining batchreporting capabilities with real-time monitoring andhistorical tracking functions- Supports an enterprise-wide integrated systemsmanagement strategy activated by the IBM TivoliOMEGAMON XE family- Stores performance data and analysis tools in aperformance warehouseValue to you:IBM Tivoli OMEGAMON XE for DB2 PerformanceExper t is the single most comprehensive DB2application performance assessment tool in themarketplace. It helps you assess the efficiency ofDB2 and optimize its performance, combiningsophisticated reporting, monitoring, and buffer poolanalysis features, as well as expert database analysisfunctions.20
DB2 Performance Management ToolsDB2 Buffer Pool Analyzer - Monitors the performance of buffer pools andgroup buffer pools- Optimizes use of buffer pools by aligning bufferpool size and object placement- Simulates buffer pool behavior to test the impact ofchanges before they are applied- Long-term analysis of factual performance forimproved prediction of future performance andresource needValue to you:DB2 Buffer Pool Analyzer for z/OS helps DBAs analyzeand monitor the usage of buffer pools and groupbuffer pools. It helps optimize database performanceby helping buffer pools function at their highestefficiency.21
DB2 Performance Management ToolsDB2 Query Monitor - Monitors SQL activities and provides automaticalerts to exceptional events on a monitored DB2subsystem in real time- Monitors DB2 commands, Host variables, SQL CAand SQL Code in real time- Provides user-friendly ISPF, GUI and Web interfaceswith SQL statistics of multiple DB2 subsystems- Integrates with other DB2 tools to reduce resourceconsumptionValue to you:DB2 Query Monitor for z/OS can identify problemSQL activity with low resource consumption, providerobust statistics for SQL tuning, and give users theability to efficiently customize and tune the SQLworkload and DB2 objects to ensure the effectivenessof DB2 subsystems and improve overall performance.22
DB2 Performance Management ToolsDB2 SQL Performance Analyzer - Provides performance analysis andrecommendations for DB2 plans, packages, DBRMs,and SQL without executing them- Provides several interfaces: Batch, TSO, ISPF andQMF- Offers "what-if" scenarios to help determine theperformance for various database design alternatives- Supplies professional performance report- Analyzes economic cost for each query statementValue to you:DB2 SQL Performance Analyzer for z/OS providesDBAs and application developers with an extensiveanalysis of SQL queries without executing them.This analysis aids them in tuning queries to achievemaximum performance. It can also reduce theescalating costs of database queries by estimatingtheir cost prior to execution.23
DB2 Data Governance Tools addressa broad spectrum of needs, coveringInformation Quality, InformationProtection and Information Lifecycle.24
They are fundamental to the successof your Data Serving, DW, BI andAnalytics solutions. The portfolioof high value tools provides thefoundation to help lower operationalcosts and risks, while increasingopportunities for new business.25
DB2 Data Governance ToolsGuardium for z - Provides real-time, automated database auditingand activity monitoring- Allows users to define flexible audit policies- Gives you visibility into all activity occurring on yourdatabaseValue to you:IBM Guardium for z helps alert you to potentialthreats based on user-defined policies, helping youstay one step ahead.IBM Data Encryption for DB2 andIMS Databases - Provides customizable encryption exists for DB2rows and IMS segments- High performance and low overhead by using thecrypto hardware available on the platform- Fast implementation, no changes required to yourapplicationsValue to you:IBM Data Encryption for DB2 and IMS Databasesprovides proven technologies to encrypt and protectsensitive data, keeping your company on the rightcompliance track.26
DB2 Data Governance ToolsDB2/IMS Audit Management Expert - Realizes the segregation of duties. Auditors cangather the auditing information independently toensure complete integrity- Auditors do not need to be the privileged userson the audited systems, so the database security ispreserved- Centralization of all data to be audited, eliminatingthe difficult and time consuming collection of datafrom other systems- User-friendly and easy-to-use interfaces eliminatingm a n u a l a u d i t i n g p ro c e s s w h i c h c a n b e t i m econsuming and error prone- Selective auditing policy, in-depth auditing andcomprehensive report provide auditors undisputedproof of who, what, where, when, why and how- Integrates with DB2 Query Monitor for z/OS andshares the same data collector in order to minimizeoverheadValue to you:DB2/IMS Audit Management Expert for z/OS is anauditing solution that enables customers to segregateduties in an easy, centralized environment. It providescomplete automation of the auditing processes,which reduces fraud exposures, and the high costsassociated with any manual auditing methods.27
28
DB2 Database Backup and RecoveryTools provide an automated solutionto restore lost data and recoverdamaged databases, minimizing lossfrom disaster.29
DB2 Database Backup and Recovery ToolsDB2 Recovery Expert - Supports many types of objects and databasebackup and recovery- Recommends multiple recover y options toselect the fastest, least costly method that is mostappropriate to your business- Supports disaster recovery by building assets thatcan be moved to a disaster site for rebuilding DB2- Provides the ability to back up and recover datausing DASD flashcopy technology- Extends the capabilities of the DB2 V8, DB2 9, andDB2 10 backup and restore system utilities- Clear, straightfor ward and easy-to-use userinterfacesValue to you:DB2 Recovery Expert for z/OS is streamlined for easeof use and manageability. It also offers powerfulanalytical features to protect against data loss orcorruption. In light of the constant increase of dataentrusted to an organization's data center, this is theideal tool to get the job done quickly and efficiently.30
DB2 Database Backup and Recovery ToolsDB2 Change Accumulation Tool - Provides the fastest recovery of database objectsand most current data for recovery processes- Allows users to create one to four image copies perexisting image copy- Creates mini-logs for specified objects from the DB2log, and reduces the frequency of creating imagecopies- Offers support for LOBs and XML objectsValue to you:DB2 Change Accumulation Tool for z/OS provides thefastest recovery for DB2 objects by defining objectsthat you are interested in and operating on imagecopies to protect your data and lessen the negativeimpact on your business.31
DB2 Database Backup and Recovery ToolsDB2 Object Restore Tool - Restores dropped objects and relateddependencies even if they no longer exist in DB2catalog- Supports dropped databases, table spaces, tables,indexes and data, as well as table authorizations- Supports DSN1COPY, DB2 Log Analysis Tool andother methods to restore dataValue to you:DB2 Object Restore Tool for z/OS is an affordable,flexible, easy-to-use tool that provides fasterrecovery of data assets and ensures lower databasemaintenance costs.32
33
Learn roducts/db2-zos-tools.html
Performance Monitor 3. DB2 Buffer Pool Analyzer 4. DB2 Query Monitor 5. DB2 SQL Performance Analyzer 6. Optim pureQuery Runtime 7. Optim Query Workload Tuner 4. Data Governance Tools 1. Guardium for z 2. DB2/IMS Audit Management Expert 3. IBM Data Encryption for DB2 and IMS Databases Database Backup and Recovery Tools 1. DB2 Recovery Expert
