Hey Michael Bell,
I used it with no problems. However, you must, I repeat, you must run
a "commit" immediately after running this statement!





Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Michael Bell
[mailto:db2udbdba-ezmlmshield-x4625798.[Email address protected]
Sent: Friday, February 23, 2007 12:47 PM
To: LazyDBA Discussion
Subject: Alter Table Not Logged - Rollforward

I've seen issues online regarding the use of ALTER TABLE NOT LOGGED
INITIALLY WITH EMPY TABLE and rollforward recovery. Does anyone know
specifically what problem this causes? I don't care about dropping and
recreating the table if needed, but I don't want to prevent the rest of
the database from coming back up.



Thank you,

Michael Bell





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

DB2 & UDB email list listserv db2-l LazyDBA home page