Test information:
Number of questions: 30
Time allowed in minutes: 60
Required passing score: 60%
Languages: English, Japanese
If you are knowledgeable with DB2 10.5 and are capable of performing the intermediate to advanced skills required in the day-to-day administration of DB2 instances and databases, you may benefit from this certification role.
Section 1 – DB2 Server Management (17%)
Demonstrate the ability to configure DB2 workload for analytics system
DB2_WORKLOAD=ANALYTICS
DB CFG DFT_TABLE_ORG COLUMN
DB CFG DATABASE PAGE SIZE = 32K
DB CFG DFT_DEGREE=ANY
DB CFG DFT_EXTENT_SZ=4
Importance of UTIL_HEAP_SZ CFG for COLUMN ORGANIZED tables load
Demonstrate the ability to use autonomic features in DB2 10.5 BLU Acceleration
AUTO_RUNSTATS is not supported for COLUM ORGANIZED tables
Automatic Space Reclaims in BLU acceleration tables
Demonstrate knowledge of Data Studio 4.1
Demonstrate the ability to use Automated workload management when workload set to ANALYTICS
Section 2 – Physical Design (37%)
Demonstrate the ability to understand industry leading DB2 10.5 BLU Acceleration 7 big ideas
Simple to Impement and Use – No Indexes, No MDC, No MQT, No Partitioning, No Statistical Views
Friendly Huffman encoding – More frequent the values, the fewer bits in dictionary and packed registers. Performing most operations on encoded values.
Usage of SIMD Instruction Sets
Maximize CPU cache
Column Store – Minimal IO / Work performed directly on columns / Improved memory density / Cache efficiency
Memory Caching Facility – Leave the interesting data instead of traditional LRU or MRU algorithms
Data Skipping through SYNOPSIS Tables
Demonstrate the ability to understand and implement compression features
Table Compression – Data Compression / Value Compression / Adaptive Compression / COLUMN ORGANIZED table compression
Database backup compression
Demonstrate the ability to use expression based indexes and the statistics on those expression based indexes
Using RUNSTATS
Using Statistics Profiles
Automatic Statistics Collection
Knowledge of Oracle Migration and Compatibility Features in DB2 10.5
Demonstrate the ability to use Information Uniqueness Constraints
Knowledge of SQL compatibility enhancements
Extended row size support
Exclude null keys support
Section 3 – Monitoring DB2 Activity (17%)
Demonstrate the ability to use new monitor elements
Demonstrate the ability to use new monitor elements to monitor dynamic prefetch requests for data in column-oriented tables.
Demonstrate the ability to use new new monitor elements to measure column data size.
Demonstrate the ability to use new monitor elements to measure time spent in Columnar Data Engine (CDE)
Demonstrate knowledge of the new EXPLAIN enhancements Knowledge of SQL compatibility enhancements
Demonstrate the ability to understand new CTQ (Column Table Queue) Operator in the explain
Knowledge of new monitoring function – MON_GET_ROUTINE
Demonstrate knowledge of HADR monitoring enhancements
HEARTBEAT_MISSED
HEARTBEAT_EXPECTED
STANDBY_SPOOL_PERCENT
STANDBY_ERROR_TIME
Section 4 – High Availability (17%)
Knowledge of enhancements to pureScale
Understand the ability to use Online REORG in pureScale
Knowledge of replay member in pureScale standby cluster
Knowledge of HADR setup in a pureScale cluster environment
Demonstrate the ability to undestand Rolling Fix Pack Updates in pureScale
Demonstrate the ability to undestand STMM Multi-Tenancy Feature in pureScale
Demonstrate the ability to understand Explicit Hierarchical Locking Multi-Tenancy in pureScale system
Knowledge of DB2 Advanced Copy Services customized scripts
Section 5 – Utilities (13%)
Demonstrate the ability to use IBM Optim Query Workload Tuner
The Workload Table Organization Advisor
Support for comparing access plans before and after
Access Plan Explorer and in access plan graphs for the new CTQ operator
Demonstrate the ability to use DB2 10.5 Utilities
db2convert
LOAD Command – Additional ANALYZE phase for COLUMN ORGANIZED tables
Default AUTOMATIC STATISTICS COLLECTION in LOAD command for COLUMN ORGANIZED tables
IBM Certified Database Administrator – DB2 10.5 DBA for LUW Upgrade from DB2 10.1
Job Role Description / Target Audience
If you are knowledgeable with DB2 10.5 and are capable of performing the intermediate to advanced skills required in the day-to-day administration of DB2 instances and databases, you may benefit from this certification role.
This exam covers only the new features and functionality of DB2 10.5 for Linux, UNIX and Windows – you must possess the DB2 10.1 DBA for Linux, UNIX and Windows certification in order to qualify for the upgrade exam.
C2090-311 IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1
QUESTION 1
How is the Query Workload Tuner license installed and enabled?
A. With Data Studio, using the license activation kit.
B. By executing the db2licm command after data server installation.
C. With the Optim Performance Manager Server, using the license activation kit.
D. By running the Query Workload Tuner license activation command on the appropriate
WebSphere server.
Answer: A
Explanation:
QUESTION 2
If the DB2_WORKLOAD registry variable has not been set which database manager configuration
parameter must be modified, before a query that accesses a column-organized table can be
executed?
A. INTRA_PARALLEL
B. QUERY_HEAP_SZ
C. MAXIMUM DEGREE
D. SHEAPTHRES SHR
Answer: A
Click here to view complete Q&A of C2090-311 exam
Certkingdom Review
Best IBM C2090-311 Certification, IBM C2090-311 Training at certkingdom.com
