Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Db2: System Performance and Tuning

Home

distance-learning center

Distance-learning Distance-learning_Building

Professional Distance-learning

IT Training Services

MFRDB53

 Db2: System Performance and Tuning
DURATION: 4 days

FEE: $2,475

PRIVATE GROUP FEE: $
Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.

AUDIENCE:

  • Database Administrator
  • System Analyst
  • System Programmer
  • IT Professional
  
   

DATES:

 CONTENT AND OBJECTIVES:
    1. Performance and Monitoring
      • The features of the Db2 PM monitoring tool.
      • Use the Db2 Performance Monitor or another tool for generating performance reports and analyzing the results.
    2. I/O and Storage Management
      • The effects of queries and updates on I/O.
      • Use the Db2 Performances Monitor for generating reports and analyzing the EXCPs, TCB, cache hit ratios, and wait times.
    3. CPU
      • The effect of queries and updates on CPU processing.
      • Use the Db2 Performances Monitor for generating reports and analyzing the CPU supervisor and application time, wait time, and idle processing.
    4. Memory
      • The effects of queries and updates on memory.
      • Use the Db2 Performance Monitor for generating performance reports and analyzing the CPU supervisor and application time, wait time, and idle processing.
    5. Catalog and Directory
      • Examine the basic flow and structure of the catalog.
      • Perform walkthrough operations using the catalog.
    6. Physical Database Objects
      • Perform the steps for transforming a data model into a physical schema and ultimately to a set of physical database structures in Db2.
      • Determine the techniques for designing an object to achieve optimal performance.
    7. Locksize
      • Issues regarding performance and LOCKSIZE.
      • Specify LOCKSIZE ANY for all tablespaces that are not identified as 'read-only'. There is an exception to this standard; this occurs when a determination has been made that all updates to the table are performed in batch by a single job and accordingly LOCKSIZE table is then recommended.
      • As a result of the additional overhead associated with maintaining row-level locks, the use of LOCKSIZE ROW is permitted when a high level of application concurrency is necessary.
    8. General Application Design
      • Gather information to examine application requirements: size of the Db2 objects, throughput of the application, and frequency and type of processes.
      • Review common logical and physical table design cases to understand the performance implications when designing tables with Db2. There is no single solution which is common to all requirements.
      • The solutions must be implemented which best fit a problem, business, or website.
    9. Locking and Concurrency
      • The effects of locks on resource consumption.
      • Monitor and record the locks and associated resources with running a progression of queries and updates.
    Virtual Classroom   Blended Learning    

↓
Synchronous
Instruction		 Asynchronous
Instruction

Effective February 27, 2012, the course dates listed on the CETi schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. CETi makes no representation regarding ownership in any of the software products that we train on.

CETi courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the CETi course and that the employer has a licensed version of the software.

Certain courses only should be taught by the source software company training company and open source purveyor.