Question

Where are the DB scripts in v6 onwards for TN and the auditing?

Answer

In the webmethods top level install directory, under common/db/scripts.
There are appropriate create, delete and upgrade scripts named according to database.

It is recommended that you consult your DBAs and perform DB stress testing and capacity testing with typical production expected loads. Adjustments to tablespaces and indexing may be required.