Check if Access logging is enable or disable: show macro DBC.AccLogRule; *** Text of DDL statement returned.
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. |