DB2 Logging - Can it be turned off ?

[JFK40]

I need to to turn logging of for a Data Warehouse project that I am involved with. I seem to remember that this was possible in Oracle but can't find a(n obvious) way of doing this in DB2 UDB v8.1 on Windows 2000 Server. Any ideas, suggestions ?

 

[blom0344]

Very good question indeed. Would like to turn it off too, but I think that the best you can get is the circular logging which means that logfiles are re-used. This effectively means that you cannot roll-forward , which is just what you would like for datawarehousing (cause individual transactions are not in order) If you find a way to turn off logging altogether , please post it here, cause that will be an interesting option.

T. Blom
Information analyst
tbl@shimano-eu.com