Archives of the TeradataForum

Message Posted: Wed, 18 Mar 2009 @ 14:29:13 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Mark,

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.

Cheers,

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )

	<Prev	Next>		<<First	<Prev	Next>	Last>>