Can I store data in encrypted form in database?



IBM's flagship relational database management system

Can I store data in encrypted form in database?

Postby 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?
pearl
 
Posts: 21
Joined: Fri Mar 15, 2013 12:55 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Can I store data in encrypted form in databa

Postby 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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

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

Postby 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
pmartyn
 
Posts: 42
Joined: Thu Feb 28, 2013 7:11 pm
Has thanked: 5 times
Been thanked: 3 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post