Articles & Content
Topic: 2010 EMEA
Subtopic: DB2 for z/OS
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
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
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.