Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

what kind of encryption DB2 is offering

hi,

what kind of encryption DB2 is offering? what tier are they doing to protect?
ASKER CERTIFIED SOLUTION
Avatar of Kent Olsen
Kent Olsen
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of marrowyung
marrowyung

ASKER

I think the question is how many type of encryption DB2 offering? that link seems saying how to install it.
"how many types" -- I don't know what you're asking there.
I mean how many diff type of encryption for DB2 , .e.g TDE, SSL and ... ?
TDE and SSL are different products that work well together, but aren't really different types of encryption.  SSL is an encryption technique (the math and routines for encryption/decryption).  TDE is an encryption management and would use something like SSL to do the actual encryption.  

I haven't heard the term TDE used with DB2, but DB2's encryption/decryption is transparent to the user.  If you can use some bullet points about about DB2's encryption tools, this might help:

  https://www.ibm.com/developerworks/community/blogs/5things/entry/5_things_to_know_about_db2_native_encryption?lang=en

Kent
"TDE and SSL are different products that work well together, but aren't really different types of encryption.  "

yes. SSL more on network side and TDE more on physical file side.
also, will Column level encryption -create high performance impact ?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
hi Tomas,

"DB2 offers encryption over the network"

Does this kind of encryption has any thing related to the DML inside ? it decrypt data at both client and server end ?

is it SSL network encryption ?
Hi,

Yes, I was talking about SSL network encryption and no it has nothing to do with DML.
SSL makes sure that data transfer between client/server is encrypted regardless of other encryption methods used.
Data encryption can be done via UDF or SP and data is encrypted/decrypted at it's execution time.

Regards,
   Tomas Helgi
"Data encryption can be done via UDF or SP"

user defined function and Store procedure inside DB2 ?
tks both