Linux, AIX, Windows only

I need to learn about the DB2 data encryption. Where do I start ? Also, I have a couple of question:

1- Is there a limitation on column encryption ? Can a primary key or an indexed column be encrypted ?

2- Any ideas about the performance hit ?

3- Is there a documentation about how to implement it ?

Thanks for any help.

Go to the DB2 online help site:

http://publib.boulder.ibm.com/infoce.../v8//index.jsp

and search for "encryption".

HTH

Andy

If the corresponding foreign key columns are encrypted as well, I don't see a problem for DB2 performing the join before the decryption.