Page 1 of 1

Can I store data in encrypted form in database?

PostPosted: Sun May 05, 2013 12:14 am
by pearl
I do not whether this is the right section for this question. I am accepting input form the user(cics) and I want to store this data in protected/encrypted form in the database table. Is there a simple logic for this?

Re: Can I store data in encrypted form in databa

PostPosted: Sun May 05, 2013 1:56 am
by enrico-sorichetti
Can I store data in encrypted form in database?

Yes if You know how to write/deploy the appropriate encryption algorithm
and Your organization has in place the proper procedures for <key> management

Is there a simple logic for this?

depends on Your proficiency in encryption techniques

the best thing to do is To speak to Your audit and legal department for the implications

Re: Can I store data in encrypted form in database?

PostPosted: Sat May 11, 2013 2:15 am
by pmartyn
Please listen to Enrico and contact appropiate personnel. The reason for this is not only legal, et.al. but that you are going to require an 'exit routine' for the encryption. Additionally you are adding to the System Programmers maintenance because after you use SMP/E to apply maintenance, you must re-create the encryption exit routine.
Here is the manual : IBM Data Encryption for IMS and DB2 Databases User's Guide, Version 1 Release 1 (SC18-95499-07).
Here is the link: http://pic.dhe.ibm.com/infocenter/dzich ... rames=true

Best of luck,
pm