I have a scenario that I need explained so here goes.

We have a bunch of tables that were created not logged initially, we had
to do a database restore to a point in time yesterday and now a group of
tables are unusable such is the case with tables that you do a load
nonrecoverable or not logged initially.

The question is when the table is created not logged initially is that
the default behavior for all transactions that happen to this table?

If that were the case in this example a unit of work would have to have
been running on these tables at the time the disks were yanked out from
under the database (thank you very much Aix admin) and that work was
never commited.

Jeremy Schleicher
ERP Database Administrator
Florida State University



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