Articles & Content

Archives

Hash Access to DB2 Data - Faster, Better, Cheaper (A10)

Topic: DB2 for z/OS

Subtopic: 2010



DATE: 2010-11-10 (11:00 - 12:00)
SPEAKERS: Karelle Cornwell (IBM Corp.)

DB2 10 for z/OS introduces Hash Access to DB2 Data, a feature that is designed to vastly improve response time and significantly reduce CPU usage for some applications. This presentation will provide in-depth information on when and how to use Hash Access to your best advantage. The DBAs and System Programmers will be especially interested in the information on space usage and space management with hash access. Hints on optimizing space usage, monitoring and tuning the data base for best performance, as well as pit falls to avoid, will be shared.

EXP. LEVEL: Intermediate

OBJECTIVES:

What is Hash Access to Data in DB2 for z/OS.

What type of applications can benefit by using hash access.

How does it affect disk space usage.

What are the advantages and disadvantages of using Hash Access.

How can one use hash access on existing DB2 tables.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.