Articles & Content


To Log or Not to Log - please don’t dig yourself a too deep hole. (B03)

Topic: 2009 NA

Subtopic: DB2 for z/OS

DATE: 2009-5-12 (01:30 PM - 02:30 PM)
SPEAKERS: Steen Rasmussen (CA)

The attendee will get an A-Z walk through of the DB2 9 NOT LOGGED tablespaces feature and what the impact is for applications as well as for backup / recovery and change propagation. The presentation will also describe the performance impact for SQL statements when NOT LOGGED is used compared to logged tablespaces.

EXP. LEVEL: Beginner,Intermediate,Advanced


DDL 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.