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).
| 
