How to check Which DIP script has been Installed in Teradata

# ls -lrt /var/opt/teradata/tdtemp/dip*

-rw-rw-r--+ 1 teradata tdtrusted 20462654 Jan 17 2014 /var/opt/teradata/tdtemp/dip23.txt

-rw-rw-r--+ 1 teradata tdtrusted 882861 Mar 12 2016 /var/opt/teradata/tdtemp/dip26.txt

-rw-rw-r--+ 1 teradata tdtrusted 1695229 Feb 18 2017 /var/opt/teradata/tdtemp/dip36.txt

-rw-rw-r--+ 1 teradata tdtrusted 251069 May 13 2017 /var/opt/teradata/tdtemp/dip38_old.txt

-rw-rw-r--+ 1 teradata tdtrusted 115336 Jun 10 2017 /var/opt/teradata/tdtemp/dip2_old.txt

-rw-rw-r--+ 1 teradata tdtrusted 114771 Jun 10 2017 /var/opt/teradata/tdtemp/dip2.txt

-rw-rw-r--+ 1 teradata tdtrusted 417359 Nov 18 2017 /var/opt/teradata/tdtemp/dippatch.txt

-rw-rw-r--+ 1 teradata tdtrusted 9886 Feb 1 2018 /var/opt/teradata/tdtemp/dip40.txt

-rw-rw-r--+ 1 teradata tdtrusted 314054 Feb 10 2018 /var/opt/teradata/tdtemp/dip38.txt

### Obviously, inspecting dip log is as simple as running "cat /var/opt/teradata/tdtemp/dip38.txt"

### Number in dip script log file are actually related with option number in DIP menu.

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. DIPACR - Access Rights

8. DIPSYSFNC - System Functions

9. DIPRUM - ResUsage Views/Macros

10. DIPOLH - Online Help

11. DIPSYSFE - System FE Macros

12. DIPCRASH - CrashDumps Database

13. DIPCCS - Client Character Sets

14. DIPOCES - Cost Profiles

15. DIPPWRSTNS - Password Restrictions

16. DIPUDT - UDT Macros

17. DIPARR - ArrayVec Data Type

18. DIPGEO - Geospatial Data Type

19. DIPXML - XML Data Type

20. DIPJSON - JSON Data Type

22. DIPCAL - Calendar Tables/Views

23. DIPSQLJ - SQLJ Views/Procedures

24. DIPSYSUIF - SYSUIF Views/Procedures

25. DIPJDBC - JDBC Functions

26. DIPRCO - Reconfig

27. DIPSTATS - Automated Stats Mgmt

28. DIPBAR - BAR Databases/Views

29. DIPPOST - Post commands

32. DIPTDWM - TDWM Configuration

33. DIPANSI - ANSI Functions

34. DIPALL - All of the above

35. DIPMIG - Scripts for Migration

36. DIPPDCR - PDCR Tables/Views

37. DIPACC - Access Logging

38. DIPPATCH - Stand-alone patches

40. DIPRTBLOP - R Table Operator