Consulting Services
Design review
of databases, tablespaces, tables, and indexes with recommendations on any
needed enhancements for performance and accessibility.
Tuning of index design including identification of
indexes that can be dropped, additional indexes required, estimate of the cost
of maintaining indexes, and order of columns in a composite index.
Scheduling, frequency, elapsed and CPU time
estimates, and evaluation of the impact of parameter choices of executing
utilities including reorganization of indexes and tablespaces, RUNSTATS with
and without optional statistics, incremental and full image copies, load
replace and resume compared to using INSERT statements to populate or add rows
to a table.
Design review of SQL, online transactions, and batch
programs.
Tuning of SQL, online transactions, and batch program
to achieve cost savings, improve response time for transactions, and elapsed
time of batch programs.
Batch program design to minimize elapsed and CPU
times, and provides the required availability of data.
Identify tablespaces that should be partitioned to
achieve smaller more manageable pieces and improved availability. We design
partitioned tablespaces to provide for parallelism, limited partition scans,
reduce I/O time for online transactions accessing data at random, and batch
programs accessing data in different partitions. We address how partitions
should be spread across multiple DASD devices, channels, and control units.
Analysis of data compression savings and costs in
terms of DASD space, I/O, CPU usage, and its appropriateness for your
application system.
DB2 Estimator is used to estimate the costs of
various alternatives proposed as appropriate.
DB2 subsystem review and tuning of buffer pools, EDM
pool, RID pool, sort pools, and work database.
Home | Book | Prices and Secure Order Page | Course Offerings | Course Material | Your comments