By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,287 Members | 1,309 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,287 IT Pros & Developers. It's quick & easy.

Encryption question - please help

P: n/a


Hello

We are in the process of evaluating the IBM encryption tool in db2 v8
on z/os. Does anyone know whether the editproc used in the IBM
encryption tool inhibits the use of index while running selects? We
have large tables - over a few 100 millions.

Thanks

Joey

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Joey Jackson" <jo*************@yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Hello

We are in the process of evaluating the IBM encryption tool in db2 v8
on z/os. Does anyone know whether the editproc used in the IBM
encryption tool inhibits the use of index while running selects? We
have large tables - over a few 100 millions.

Thanks

Joey

I am not sure if you can index an encrypted column, but if you can then you
can only search on the encrypted data (VARCHAR FOR BIT DATA) so it would not
do you any good.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.