Articles & Content

Archives

Do you really want NOT to LOG ? (A09)

Topic: DB2 for z/OS

Subtopic: 2010



DATE: 2010-5-13 (08:30 AM - 09:30 AM)
SPEAKERS: Steen Rasmussen (CA)

Not logged tablespaces in DB2 9 looks very interesting, but there are a number of issues which need to be considered prior to exploiting this feature. We will look into the syntax changes, where this new feature can / should be used as well as the alternatives. Application / SQL processing implications need to be considered prior to exploiting this new feature, and the same goes for backup and recovery procedures. These two topics will be covered in detail and recommendations outlined when considering NOT LOGGED tablespaces.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Syntax changes implementing Not Logged tablespaces

Impact on applications and SQL when dealing with Not Logged tablespaces

Backup and recovery considerations

Performance case study

Recommendations based on usage and performance



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.