2007-03-13 10:31 AEST by Arthur Barrett - UDB/DB2 Audit uses CLOB field - can it be VARCHAR instead?

Customer asks:
------------------------------------------------------------------------
We are in the process of turning on database auditing for our CVSNT 
implementation.  Our provider must be DB2 (it works very well) and our DBA's 
now have a question about the necessary schema. 

3 of the 4 tables use a CLOB field (for messages) that allocates 1 Meg of space 
using logging, no compaction.  

1) Is there any chance that we could alter the schema to instead use a smaller 
data type?  VARCHAR instead of CLOB? 

2) Can we tweak the CLOB to use no logging with compaction? 
------------------------------------------------------------------------

The Audit trigger uses quite a simple insert statement, so if you alter the 
table definition it will very likely work - however I'd suggest a little 
testing first.  You can certainly disable logging and enable compaction.


The field definitions of the Audit schema for UDB / DB2 should be looked at in 
terms of optimisation.