DB2 V8 New Keyword for Create/Alter Table

Barbara Nigh

DB2 V8 New Keyword for Create/Alter Table
Does anyone have any experience with the new table option VOLATILE with
DB2 z/OS Version 8? If so, has the experience been positive or negative?
I am in the process of defining
the control tables for IBM's Q Replication product and the job included
comments about using this new parameter when defining tables that have
indexes.

Barbara J Nigh
=====
CONSULTANT DATABASE MGMT | HSBC Technology Services (HTS)
1441 Schilling Place
Salinas, CA 93901
______________________________________________________

Phone 831 754 1400 2048
Fax 831-759-7073
Mobile 831-776-6194 Pager [login to unmask email]
Email [login to unmask email]
Web Site http://www.hsbc.com
______________________________________________________

-----------------------------------------
******************************************************************
This E-mail is confidential. It may also be legally privileged. If
you are not the addressee you may not copy, forward, disclose or
use any part of it. If you have received this message in error,
please delete it and all copies from your system and notify the
sender immediately by return E-mail.

Internet communications cannot be guaranteed to be timely, secure,
error or virus-free. The sender does not accept liability for any
errors or omissions.
******************************************************************
SAVE PAPER - THINK BEFORE YOU PRINT!

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms