tag:blogger.com,1999:blog-18371456.post6199945800015541231..comments2024-03-26T00:07:20.400-05:00Comments on The Db2 Portal Blog: VOLATILE: A Useful Little KeywordCraig S. Mullinshttp://www.blogger.com/profile/17077237739217901780noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-18371456.post-22394164685886032232010-01-14T21:33:03.264-06:002010-01-14T21:33:03.264-06:00Excellent post - VOLATILE is good medicine for tab...Excellent post - VOLATILE is good medicine for tables that fluctuate so wildly and frequently that no runstats rate can keep up. I've had good and bad experiences with it; some documented on <a href="http://derekwilliams.us/?p=131" rel="nofollow">my blog</a>.<br /><br />There have been quite a few issues/APARs with it, so stay current on fixpacks. Searching the <a href="http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21412439" rel="nofollow">APAR lists</a> with the word "VOLATILE" will reveal many of these.Derek Williamshttps://www.blogger.com/profile/00413149909189815401noreply@blogger.comtag:blogger.com,1999:blog-18371456.post-77934821919541521182009-01-19T03:33:00.000-06:002009-01-19T03:33:00.000-06:00@ ajay singh:tryALTER TABLE creator.name NOT VOLAT...@ ajay singh:<BR/><BR/>try<BR/>ALTER TABLE creator.name NOT VOLATILE ;Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18371456.post-87034639121770977332009-01-07T01:33:00.000-06:002009-01-07T01:33:00.000-06:00Hi Craig,How to undo the volatile property of the ...Hi Craig,<BR/><BR/>How to undo the volatile property of the tableajay singhhttps://www.blogger.com/profile/00443897626131798585noreply@blogger.com