News, views, and items of interest on IBM's Db2 database management system and mainframes.
Friday, June 29, 2007
Implicitly Created Database Objects [DB2 9 for z/OS]
›
Today we continue our series on new features in DB2 V9 with a quick discussion of implicitly created database objects. To understand what th...
Monday, June 18, 2007
Skipping Locked Rows [DB2 9 for z/OS]
›
In DB2 9 it is possible for a transaction to skip over rows that are locked. This can be accomplished by means of the SKIP LOCKED DATA optio...
2 comments:
Wednesday, June 13, 2007
Do You Want to Ignore Clustering? [DB2 9 for z/OS]
›
DB2 9 for z/OS offers a new DDL parameter for your tables: APPEND. If you specify APPEND NO, which is the default, DB2 will operate as you a...
Monday, June 04, 2007
Reordered Row Format [DB2 9 for z/OS]
›
If you’ve worked with DB2 for awhile, especially as a DBA, you’ve probably heard the advice to re-arrange the columns of your tables to opti...
3 comments:
Tuesday, May 29, 2007
INSTEAD OF Triggers [DB2 9 for z/OS]
›
DB2 9 for z/OS introduces a new type of trigger: the INSTEAD OF trigger. The primary usage of INSTEAD OF triggers is to enable views that wo...
‹
›
Home
View web version
