Encrypting AS400 database file

125 pts.
Tags:
AS/400
AS/400 Database File
QC3ENCDT
I need to encrypt a database file residing on the as400 and FTP to a destination. Can I use QC3ENCDT to do this?

Software/Hardware used:
AS400, iSeries, system I

Answer Wiki

Thanks. We'll let you know when a new response is added.

Thats a good question. I was asked to research encrypting a file so it can be FTP’d. I will get a hold of the receiver on Monday to find out the answer to your question.

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Splat
    Is it the file that needs to be encrypted or is it the communication that needs to be secured?
    6,905 pointsBadges:
    report
  • TomLiotta
    You can use the QC3ENCDT API to encrypt data. Whether it's appropriate to "encrypt a database file" is a different kind of question, though. Data stored in a database file can be meaningful to encrypt -- it may be necessary to store encrypted data in spaces larger than the unencrypted data which can mean using variable-length fields. Splat's question is appropriate. Exactly what needs to be encrypted? Is this going to be restored/decrypted in another AS/400 with similar capabilities? Or is this only for secure off-site storage? Tom
    125,585 pointsBadges:
    report
  • Jeffm
    We have third party software that produces a file that is currently uploaded to a bank via their web page. The concern from the auditors is that the file may be manipulated by one of our users. Since a set of users needs to have permissions to update it (Ap Department) and another set needs read permission to be able to upload it to the bank. They want us to automate the process utilizing ftp instead of the web page. They also want the data encrypted as it resides on our system after it is created.
    125 pointsBadges:
    report
  • Splat
    FTP to your bank can be secured either through SSL or SFTP (BTW, I suspect the bank's web page is secure (https). As for limiting and/or controlling access, encryption is a cumbersome process. You would be better served - and, I believe, your auditor's goals achieved - by securing the file object, either through explicit grants of authority to a user or through an authorisation list.
    6,905 pointsBadges:
    report
  • Jeffm
    Thanks Splat. Thats the road I am going down. If I can secure the file so that the users jobs won't blow up with not enough authority but also not allowing them to change the data once it has been written. Then secure FTP it. Our users want to get away from uploading via banks web site as it takes their interaction. I can automate secure FTP. Thanks again Jeff
    125 pointsBadges:
    report
  • Jeffm
    Is SFTP cababilities on the iSeries something that has to be purchased and licensed from IBM or is it just available? Our iSeries os is V6R1. Thanks Jeff
    125 pointsBadges:
    report
  • TomLiotta
    Is SFTP cababilities on the iSeries something that has to be purchased and licensed from IBM or is it just available? The sftp utility is part of the 5733SC1-IBM Portable Utilities product. The product should be on your install media (if it's not already installed on your system.) It's no-charge. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following