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.

Comments