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

Comments