Logging SYSTEMFE.

Database
Enthusiast

Logging SYSTEMFE.

In the document --> TD13 DBQL logging and maintenance.doc

It is written that to log the SystemFE user.

"If using this documented DDL, Macros, and example script, you must log SYSTEMFE as well, using the guidelines below (or substitute another userid).  This ensures that the caches are dumped prior to moving the data out of the DBC DBQL tables"

May I advantage and specific reason why we need to log the SystemFE user. ?

I can see that it has few macro that executes on the DBC.SW_Event_Log table.

Tags (1)
1 REPLY
Teradata Employee

Re: Logging SYSTEMFE.

The scripts require it.

As part of the process, the scripts included in that document will disable DBQL logging and re-enable DBQL logging on SYSTEMFE.  The sole purpose of this is to flush the DBQL cache tables.

Look lower in the script and you'll see where SYSTEMFE logging is

END QUERY LOGGING WITH SQL, OBJECTS LIMIT SQLTEXT=0 ON SYSTEMFE;

BEGIN QUERY LOGGING WITH SQL, OBJECTS LIMIT SQLTEXT=0 ON SYSTEMFE;

You should probably log it anyway.  If anyone ever logs onto that ID, you want to capture their SQL, Resource usage, etc.  Many sites reserve SYSTEMFE for the GSC to use while diagnosing issues on the system.

All users should be logged in DBQL in one way or another.