Archives of the TeradataForum
Message Posted: Wed, 18 Mar 2009 @ 14:29:13 GMT
Here are the contents of the default clispb.dat file (this is from TTU 13 but I think it's probably the same for most current TTU versions).
req_buf_len=1024 resp_buf_len=8192 max_num_sess=300 i_dbcpath=dbc change_opts=Y keep_resp=N loc_mode=N wait_for_resp=N parcel_mode=Y resp_mode=R use_presence_bits=N msg_security=N var_len_req=N var_len_fetch=N wait_across_crash=N tell_about_crash=Y two_resp_bufs=N save_resp_buf=N ret_time=N req_proc_opt=E
Note that "data_encryption" is not listed here.
On a Windows system with TTU installed the default locations are: TTU 13: C:\Program Files\Teradata\Client\13.0\CLIv2\clispb.dat TTU 8.1 (and probably most others): C:\Program Files\NCR\Teradata Client\CLIv2\clispb.dat
For the definitive answer to where it is on a system, look in the environment variables for an entry called COPLIB. This will point to a folder name. That folder contains the clispb.dat file.
I don't think you can really answer the question "is data encryption turned on or not" because any individual program can override the default setting (which is what will be shown in clispb.dat). For data encryption to be allowed then both the DBMS and TTU have to be at a minimum required level (which are probably fairly old by now) but that doesn't mean it's being used. I don't know of a way of forcing each program to use data encryption. Having said that I doubt if the standard utilities will specifically change it themselves, they'll probably only change it in response to any user supplied setting.
For ODBC apps there is a "use data encryption" setting at the DSN level, presumably this is again a default and individual programs can override that - I don't know.
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|