Articles & Content

Archives

DB2 Hidden treasures - new posibilities (F09)

Topic: DB2 for z/OS

Subtopic: 2010



DATE: 2010-11-10 (09:45 - 10:45)
SPEAKERS: Per Woldike (Jyske Bank)

Have you ever thought that a disaster would hit you on your 60 TB database and you have to restore it all before you can use it for customer access. Come and hear a solution that helps you handle this problem.Existence checking on a very large tables can be expensive and cost a lot of time when you are using singleton select. Do it another way, using the parallel mechanisms and not often used parameter in the DB2 bind.Using LIKE in SQL all know can be expensive but sometimes it is not possible commercially to avoid it. Through new facilities in DB2 9 can LIKE coded differently and significantly faster and sometimes cheaper.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Learn a method to make the most important of large amount of operationel data highly available also after a disaster.

Learn to make existence check with join instead of using singletom select.

Learn to extract data from large tables very effective

Learn how expensive LIKE statements can be avoided

Learn to use new DB2 9 indexes in another way and how to tune many indexes



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.