Enable Analytical Extensions/NPATH and SESSIONIZE in Teradata

SMP001-01:~ # dbscontrol

 _______

    |                                |              |

    |    ___     __     ____         |    ____    __|__    ____

    |   /      |/  \    ____|    ____|    ____|     |      ____|

    |   ---    |       /    |   /    |   /    |     |     /    |

    |   \___   |       \____|   \____|   \____|     |__   \____|

 

Release 15.10.07.11 Version 15.10.07.11

DBSControl Utility (Dec 99)

The current DBS Control GDO has been read.

Enter a command, HELP, or QUIT:

mod systemfe=T

The SystemFE field has been modified from FALSE to TRUE.

WARNING: Running DBSControl in SystemFE mode may result in

         inconsistent system behavior!

Are you sure you want to do this (Y/N)?

Y

Enter a command, HELP, or QUIT:

DISPLAY INTERNAL

.

.

.

  314.  AnalyticsExtensionsPurchased = FALSE

.

.

Enter a command, HELP, or QUIT:

modify internal = true

The Internal field has been modified from FALSE to TRUE.

Enter a command, HELP, or QUIT:

modify internal 314 = true

The AnalyticsExtensionsPurchased field has been modified from FALSE to TRUE.

NOTE: This change will become effective after the DBS Control Record

       has been written.

Enter a command, HELP, or QUIT:

modify internal = false

The Internal field has been modified from TRUE to FALSE.

Enter a command, HELP, or QUIT:

mod systemfe=F

The SystemFE field has been modified from TRUE to FALSE.

Enter a command, HELP, or QUIT:

write

Locking the DBS Control GDO...

Updating the DBS Control GDO...

Enter a command, HELP, or QUIT:

QUIT

Exiting DBSControl...

SMP001-01:~ # cnsterm 6

Attempting to connect to CNS...Completed.

Hello

Input Supervisor Command:

> start dip

start dip

Started 'dip' in window 1

 at Fri May 25 10:04:36 2018

Input Supervisor Command:

> ^C

SMP001-01:~ # cnsterm 1

_______

    |                                |              |

    |    ___     __     ____         |    ____    __|__    ____

    |   /      |/  \    ____|    ____|    ____|     |      ____|

    |   ---    |       /    |   /    |   /    |     |     /    |

    |   \___   |       \____|   \____|   \____|     |__   \____|

 

    Release 15.10.07.11 Version 15.10.07.11

    DIP Utility (Jul 13)

Type the password for user DBC or press the Enter key to quit:

Type the password for user DBC or press the Enter key to quit:

> DBCPassword

DBCPassword

*** 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. 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

21. DIPAEXT    - Analytical Extensions

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

> 21

21

Executing DIPAEXT at Fri May 25 10:07:10 2018

Please wait...

DIPAEXT is complete at Fri May 25 10:07:10 2018

Please review the results in /var/opt/teradata/tdtemp/dip21.txt on node 1- 1

 

Would you like to execute another DIP script (Y/N)?

 

> N

N

Exiting DIP...

^C

SMP001-01:~ #

The dip script creates the following functions:

  •          TD_SYSFNLIB.SESSIONIZE ()
  •        TD_SYSFNLIB.NPATH ()


This function has been removed from dbscontrol and is now enabled by default in TD16.20

Comments