DB2 for z/OS

Reduced costs

• DB2 reduces CPU usage by optimizing processor times and memory access, and by using the latest processor improvements, larger amounts of memory and other IBM z/OS enhancements.
• Virtual storage improvements deliver up to 10 times more scalability for better performance, reduced complexity and greater cost savings.
• Pre-migration guidance lets you create settings for the routines and programs supplied by your DB2 for z/OS server. These automated processes reduce the time and cost of installation and configuration.
• You can migrate directly from DB2 for z/OS Version 8 to the current version, DB2 10 for z/OS.

Support for resilience

• Schema evolution and enhancements to query performance can help you improve availability of your systems. Take action to reduce outages.
• IBM pureXML and extended SQL help you manage security and compliance. Data security features help you manage access to a table at the level of a row, a column or both. Define and create audit policies to address the specific security requirements of your business.
• DB2 10 for z/OS delivers virtual storage relief, improved vertical scalability and availability by moving memory to 64-bit storage.
• Cross-platform SQL and XML support can improve productivity and performance for pureXML.
• DB2 for z/OS supports the binary XML format, XML schema validation as a built-in function, XML date and time data types and functions, and XML parameters in routines.

Improved productivity for administrators and developers

• You can make changes to data definitions without disrupting online performance with DB2 for z/OS. Keep applications available.
• Porting can be much easier for application developers with DB2 for z/OS. Enhancements to SQL and pureXML are designed to create compatibility between DB2 for z/OS and other applications.
• Built-in data visualizations and graphical page-based reports extend DB2 Query Management Facility Version 10 (QMF 10) usage from the traditional technical user to a broader community of business end users.
• The new metadata layer in DB2 QMF 10 simplifies the underlying data model, empowering non-technical users with self-service reporting. It extends access to DB2 for z/OS across the enterprise, helping to further increase the return on your investment.
• You can use simple SQL statements to manage multiple versions of data. Temporal time management capabilities are built into the DB2 for z/OS database. Track dates more effectively when business conditions change such as dates that determine insurance coverage, product prices, medical prescriptions or interest rates.