IBM: DB2 11 Fundamentals for z/OS. Practice Exam

This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to describe the architecture and administer the processes required to plan, install, manage, tune and secure DB2 for z/OS environments.

Proliferation of mobile and other network-connected devices is driving increases in: • transaction workloads • data volumes • 24x7 requirements • Continued focus on cost containment and resource efficiency • Competitive pressures continue to drive an increasing need for innovation, analytics, and data integration • DB2 for z/OS has leading edge capabilities to support these requirements and DB2 11 makes important improvements

Out-of-the-box CPU Savings • Improving efficiency, reducing costs, no application changes • Up to 10% for complex OLTP • Up to 10% for update intensive batch • Up to 40% for queries • Additional performance improvements through use of new DB2 11 features • Enhanced Resiliency and Continuous Availability • Making more online changes without affecting applications • Online REORG improvements, less disruption • DROP COLUMN, online change of partition limit keys • Extended log record addressing capacity - 1 yottabyte (or 1B petabytes) • BIND/REBIND, DDL break into persistent threads • Enhanced business analytics • Expanded SQL, XML capabilities • Temporal and SQLPL enhancements • Transparent archiving • Hadoop integration, NoSQL and JSON support • Simpler, faster DB2 version upgrades • No application changes required for DB2 upgrade • Access path stability improvements