Encrypt data in DB

sun_job · New User Joined: 18 Sep 2007 Posts: 73 Location: Bangalore

Hi All,

Request all veterans help in the below case.

The requirement is to encrypt confidential data in the Db2 tables. The confidential would include:
PO Number
Customer
Amount

Just wanted to know , is there any JCL or process to do the same.

I understand that DB2 table data cannot be encrypted directly.

gylbharat · Posted: Fri Sep 05, 2014 1:32 pm

Please check ENCRYPT_TDES and DECRYPT_BINARY, DECRYPT_BIT, DECRYPT_CHAR, and DECRYPT_DB functions.

sun_job · New User Joined: 18 Sep 2007 Posts: 73 Location: Bangalore

Thanks will check and keep posted

sun_job · New User Joined: 18 Sep 2007 Posts: 73 Location: Bangalore

One more question :

Would the above listed functions encrypt/decrypt data which is already in the table?

enrico-sorichetti · Posted: Fri Sep 05, 2014 6:20 pm

does anybody realise that encryption/decryption is more than plain functions calls!

for example ...
encryption/decryption need a KEY ...
what plans are in place for key management ???

just to state one of the problems to be solved

Nic Clouston · Posted: Fri Sep 05, 2014 11:55 pm

No JCL will be able to do it as that is not the function of JCL. The L may stand for Language but the JC stands for Job Control which means telling the OS what programs you want to run, in what sequence and the resources required. I do not see how you think Job Control could have anything to do with your requirement apart from telling the OS to run whatever you decide needs to be run to satisfy your requirement.
And, as you are enquiring about DB2 encryption why not post i the DB2 part of the forum - that is what it is there for!

prino · Posted: Sat Sep 06, 2014 1:43 pm