How to enable access logging in Teradata
Check if Access logging is enable or disable:
show macro DBC.AccLogRule;
Output if access Logging is enable:
*** Text of DDL statement returned.
*** Total elapsed time was 2 seconds.
---------------------------------------------------------------------------
REPLACE MACRO DBC.AccLogRule AS (;);
Output if access Logging is disable:
show macro DBC.AccLogRule;
*** Failure 3824 Macro 'DBC.AccLogRule' does not exist.
Statement# 1, Info =0
*** Total elapsed time was 1 second.
# cnsterm 6
Attempting to connect to CNS...Completed.
Hello
Input Supervisor Command:
> start dip
start dip
Started 'dip' in window 3
at Tue Feb 12 15:28:00 2019
Input Supervisor Command:
> ^C
# cnsterm 3
Attempting to connect to CNS...Completed.
Hello
===================================================================
End of session state report
Please enter a logical host id (? for help):
QrySession has terminated
_______
| | |
| ___ __ ____ | ____ __|__ ____
| / |/ \ ____| ____| ____| | ____|
| --- | / | / | / | | / |
| \___ | \____| \____| \____| |__ \____|
Release 16.20.24.01 Version 16.20.24.01
DIP Utility (Jul 13)
Type the password for user DBC or press the Enter key to quit:
> *********
*********
*** Logon successfully completed.
Select one of the following DIP SQL scripts to execute:
(Press the Enter key to quit)
1. DIPERR - Error Messages
2. DIPDB - System Databases
3. DIPDEM - UDF/UDT/XSP/SPL Macros
4. DIPRSS - ResUsage Tables
5. DIPVIEWS - Legacy System Views
6. DIPVIEWSV - Unicode System Views
7. DIPDBCCMT - DBC Table Comments
8. DIPACR - Access Rights
9. DIPSYSFNC - System Functions
10. DIPRUM - ResUsage Views/Macros
11. DIPOLH - Online Help
12. DIPSYSFE - System FE Macros
13. DIPCRASH - CrashDumps Database
14. DIPCCS - Client Character Sets
15. DIPOCES - Cost Profiles
16. DIPPWRSTNS - Password Restrictions
17. DIPUDT - UDT Macros
18. DIPARR - ArrayVec Data Type
19. DIPGEO - Geospatial Data Type
20. DIPXML - XML Data Type
21. DIPJSON - JSON Data Type
22. DIPDATASET - DATASET Data Type
23. DIPDSCSV - DATASET CSV Data Type
24. DIPAEXT - Analytical Extensions
25. DIPCAL - Calendar Tables/Views
26. DIPSQLJ - SQLJ Views/Procedures
27. DIPSYSUIF - SYSUIF Views/Procedures
28. DIPJDBC - JDBC Functions
29. DIPRCO - Reconfig
30. DIPSTATS - Automated Stats Mgmt
31. DIPBAR - BAR Databases/Views
32. DIPPOST - Post commands
35. DIPMAPS - Multiple Hash Maps
36. DIPTDWM - TDWM Configuration
37. DIPANSI - ANSI Functions
38. DIPALL - All of the above
39. DIPMIG - Scripts for Migration
40. DIPPDCR - PDCR Tables/Views
41. DIPACC - Access Logging
42. DIPPATCH - Stand-alone patches
44. DIPRTBLOP - R Table Operator
> 41
41
Executing DIPACC at Tue Feb 12 09:25:55 2019
Please wait...
DIPACC is complete at Tue Feb 12 09:26:05 2019
Please review the results in /var/opt/teradata/tdtemp/dip37.txt on node 1- 1
Would you like to execute another DIP script (Y/N)?
> n
n
Exiting DIP...
^C
# tpareset -f enable accesslogging
You are about to restart the database
on the system
'localhost'
Do you wish to continue (default: n) [y,n] y
Note: DIPALL won't turn on Access Logging.