AS400 complete File encryption with the Criptographic Card
I am looking for help with encrypting a complete as400 file with my Criptographic card that is installed. I have a process to encrypt a file record by record but i want to encrypt a complete file with out sending multiple encryption requests to my encryption card. There has to be an API or something to connect to the criptographic card and send a file in order to be encrypted or decrypted by that card in one request with my secret key.
Software/Hardware used:
AS400 QCCA with the criptographic card
Software/Hardware used:
AS400 QCCA with the criptographic card
ASKED:
August 29, 2012 3:28 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
Please define “file”. Since you say “encrypt a file record by record”, I’d normally assume that you mean a DB2 database file. But your request makes it sound more like a streamfile.
I don’t think I’ve heard of anyone encrypting a database file in a single operation on iSeries, but may be possible at i 7.1. It can introduce very tricky problems. Assuming it’s really a SQL table and not a DDS PF, and it doesn’t have numeric and/or date/time columns (which generally don’t encrypt/decrypt easily), table-level can possibly be effected with ALTER TABLE, though the individual columns would still be specified in a long statement.
See the Enable Transparent Encryption with DB2 Field Procedures article for a discussion by Kent Milligan. Once the possibilities are more clear, see if you need to continue this discussion.
Tom