Overview
IBM DB2 Utilities Suite for z/OS is a comprehensive set of tools for managing all DB2 data maintenance tasks.
DB2 Utilities Suite helps you to minimize downtime associated with routine DB2 data maintenance while ensuring the highest degree of data integrity. What’s New in Version 9.1?
- Full support for the significant enhancements in DB2 9 for z/OS such as universal table spaces, not-logged table spaces, clone tables, new data types (DECFLOAT, BIGINT, and VARBINARY), new rounding modes, and pureXML© storage. In addition, the DB2 Utilities Suite includes enablement for IBM System z Integrated Information Processors (zIIP).
- Reduction in utility CPU consumption particularly for CHECK INDEX, LOAD, REORG, REBUILD INDEX and RUNSTATS
- Improved data availability with for utilities such as CHECK DATA, CHECK LOB, REBUID INDEX and REORG
- RUNSTATS in DB2 V9 is able to collect range distribution statistics to assist the optimizer in better access path selection
- Program number: 5655-N97
- Operating systems: z/OS
Presentation
Product framework
Family overview
See the complete family of DB2 Tools for z/OS
See how other Data Management Tools can help drive your business
See the DB2 for z/OS page for all your DB2 needs
Additional products, services and solutions
Products
Allows users to easily set up reoccurring DB2 utility jobs for conditional and routine maintenance tasks
Solutions
Back up and restore your critical data assets
We're here to help
Easy ways to get the answers you need.
Or call us at:
877-426-3774
Priority code:
104CBW60
Want more zIIP from DB2 Utilities?
IBM DB2 for z/OS Version 8 or DB2 9 utilities now offers additional zIIP processing for utilities sorting fixed-length in-memory records.