Community

Do You Want to Ignore Clustering? [DB2 9 for z/OS]

(Craig Mullins) 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 are accustomed to it operating. That is, when rows are inserted or loaded DB2 will attempt to sequence them based on the clustering index key.

Read More - Register for Free Membership

Tags: