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

Home

distance-learning center

Application of Classic Teaching Models Mobile Classrooms

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:

HANDS-ON TRAINING:
    1. Performance and Monitoring
      • Understand 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
      • Recognize 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
      • Understand the effects 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
      • Understand the effects of queries and updates on memory.
      • Use the DB2 Performances 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
      • Present 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.
      • Recognize the solutions must be implemented which best fit a problem, business, or site.
    9. Locking and Concurrency
      • Understand the effects of locks on resource consumption.
      • Monitor and record the locks and associated resources after running a progression of queries and updates.
 
 
    Web-based Training   Blended Learning    
Synchronous
Instruction
Asynchronous
Instruction
Value Added Service

Common Questions


Website

 

Effective February 27, 2012, the course dates listed on the SYS-ED 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. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED 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 SYS-ED course and that the employer has a licensed version of the software.