Archives of the TeradataForum
Message Posted: Wed, 24 Jul 2002 @ 15:44:14 GMT
| Subj: | | Re: Access Logging and changing the log table |
| |
| From: | | Walter, Todd A |
Don't do that! It will not be pleasant.
There is a reason for the PI on the table. It causes all the rows for a session to go to the same AMP which in turn allows the
implementation of FIRST, LAST and BOTH logging. Otherwise it would be difficult or impossible to identify the log rows that should be
tossed. FIRST, LAST and BOTH were were requirements from the security folks.
Just to make clear, the hot amp issues on access log occur only when a very large number of requests are submitted on the same
session. It is not clear that these requests should be logged in the first place (eg TPump, BTEQ import or Bulkload sessions).
Good news is... In V2R5 there will be a Query Log. It will do the things people have been trying to do with Access Logging (but
which it was never designed for) and the A.L. can go back to being for the security administrator. The QL has fixed these issues and
added a bunch of stuff y'all have wanted for some time (like response time for instance).
| 
