IBM Mainframe Forum

by **pearl** » Sun May 05, 2013 12:14 am

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?

by **enrico-sorichetti** » Sun May 05, 2013 1:56 am

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

by **pmartyn** » Sat May 11, 2013 2:15 am

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

IBM Mainframe Forum

Can I store data in encrypted form in database?

Can I store data in encrypted form in database?

Re: Can I store data in encrypted form in databa

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