activate Nontemporal operations with DBS CONTROL or Teradata Administrator

Teradata Applications
Teradata Employee

activate Nontemporal operations with DBS CONTROL or Teradata Administrator

Hi there! I'm quite new by teradata.

After researching i understood that DBS CONTROL is an Utility that can be also executed wit Linux command, so i searched for such a directory it in the terminal of my

virtual machine but  i wasn't able to find it.

My goal is to find it and change the flag to activate the "nontemporal operations" .Considering in tools such bteq or sql assitent i'm getting the error 9240:" Nontemporal operation are disabled" i'm starting to think that we're talking about "Teradata Database configuration settings" which have to be changed in DBS CONTROL  and not about GRANTS which can be granted also in tool such TERADATA administrator

  Can anyone  explain me and tell me how, where to chage/grant them?

thanks in advance

P.S.I also tried with Teradata admistrator as DBC granting myself or childs "nontemporal grants" but i get the message 3524: the user does not have NONTEMPORAL WITH GRANT OPTION access to database DBC

2 REPLIES

Re: activate Nontemporal operations with DBS CONTROL or Teradata Administrator

Hi Fabrizio.

You can find it for yourself:

(better as root): find / -name dbscontrol

I find it easier to work with dbscontrol from xdbw, but you can use it from the command line too.

The field you are looking for is EnabNonTempoOp (in 'GENERAL').

HTH.

Cheers.

Carlos.

Teradata Employee

Re: activate Nontemporal operations with DBS CONTROL or Teradata Administrator

At Linux command prompt, enter tdatcmd to establish the environment for Teradata utilities and add them to the default search path.

Then you can run dbscontrol.