DB2 9 for z/OS Performance Features by Dave Beulke

Hi DB2 user,

Dave Beulke published several posts about DB2 9 for z/OS performance features on his Blog: http://davebeulke.com:

- DSNZPARM parameters
- ORDER BY and FETCH FIRST n ROWS in a Sub-Select
- Skip Uncommitted Inserts zParm
- Universal Tablespace
- FETCH WITH CONTINUE SQL
- DB2 Version 9 for z/OS Logging enhancement
- Performance improvement for IBM DB2 utilities
- Data Warehousing and Reporting features
- Minimizing the number of SQL call
- Too Many Performance Features in DB2 Version 9 for z/OS



More information

- Improving Performance with DB2 V9 for z/OS

- Java DB2 Performance with Data Studio and PureQuery

- pureQuery-JLINQ Examples to Improve Your Java Application Performance

- Data Warehouse Design and Performance

- How to do your own Performance Review

- Performance for SOA DB2 Java Applications



Regards,

DB2usa.

Robert Catterall's presentations

Hi DB2 user,

Here are several DB2 z/OS presentations of Robert Catterall, available on IDUG website and other websites:

- Get Up: DB2 High Availability & Disaster Recovery
by Robert Catterall

- What DB2 People Should Know About SOA
by Robert Catterall

- Ultra-Availability – How Far Can You Go?
by Robert Catterall

- DB2 for z/OS Data Warehouse Performance
by Robert Catterall

- DB2 Stored Procedures - Trends and Technology
by Robert Catterall


More information

- DB2 Data Warehouse Performance, Part 1
by Robert Catterall

- DB2 Data Warehouse Performance, Part 2
by Robert Catterall

- Robert's Blog
by Robert Catterall

Regards,

DB2usa.