Encryption Through Fileaid



Compuware's data management products: File-AID for IMS, File-AID/MVS, File-AID for DB2 and DBA-XPERT for DB2

Encryption Through Fileaid

Postby gauthamnagpur18 » Wed Aug 31, 2011 9:25 am

Hi,

Can we do encryption through fileaid ? :roll:

Thanks ,
Gautham
gauthamnagpur18
 
Posts: 93
Joined: Sat Oct 23, 2010 1:28 pm
Location: Chennai, India
Has thanked: 3 times
Been thanked: 3 times

Re: Encryption Through Fileaid

Postby NicC » Wed Aug 31, 2011 9:33 am

What does the file-aid manual/help say?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Encryption Through Fileaid

Postby dick scherrer » Wed Aug 31, 2011 10:08 am

Hello,

Why does someone believe encryption is needed? I ask because most of the time it is not or the request is too generic.

What are you trying to accomplish?

I suspect that you want to use encryption to "hide" data that is to be transferred t osome other system. Why not simply compress the file with a password and then decompress it on the receiving end?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Encryption Through Fileaid

Postby gauthamnagpur18 » Wed Aug 31, 2011 2:26 pm

Hi ,

My actual requirement is :
* to transfer the data from production to development region
* the development region should contain encrypted data . (for eg ssn numbers should be encrypted in dev region )

Thats why i asked whether we have any options in fileaid .

Gautham :)
gauthamnagpur18
 
Posts: 93
Joined: Sat Oct 23, 2010 1:28 pm
Location: Chennai, India
Has thanked: 3 times
Been thanked: 3 times

Re: Encryption Through Fileaid

Postby BillyBoyo » Wed Aug 31, 2011 4:34 pm

That's not encryption.

You need to rather make them readable but not the correct data.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Encryption Through Fileaid

Postby enrico-sorichetti » Wed Aug 31, 2011 5:27 pm

I wonder why such <important> issues are taken so lightly to rely on answers from a forum!

depending on the organization core business the issue is amazingly complex,
the proper term is data obfuscation, and is a stringent requirement for (for example) financial organization
when dealing with production data transferred to the test environments and the related development outsourcing

any answer that the TS might get on a forum apart a do not do it by Yourself will be most likely <wrong>,
dealing with such an issue is usually the object of an hefty consultancy,
ant the organization willingness to spend money on consultants and products
-- the CEO will most likely be happy to sign the contracts because of his/her legal liabilities
concerning the safeguard of personal data
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: Encryption Through Fileaid

Postby Robert Sample » Wed Aug 31, 2011 6:24 pm

To add to the other responses, encryption is probably not even the right way to go, anyway. SSN is a 9-digit NUMERIC value in the U.S. If you encrypt it, depending upon the algorithm used, you may get more -- or less - than 9 character, and those characters (however many they are) are guaranteed to be non-numeric since encryption uses the entire collating sequence. So you've changed a 9-digit number into an alphanumeric field of some length -- which implies, at the least, that the processing logic used to handle the 9-digit number on your production system most likely will have to be rewritten to handle the encrypted data. This could require anything from changing a program or two, through complete system rewrite, depening upon the application and how much it relies upon the 9-digit and numeric aspects of SSN.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times


Return to File-AID

 


  • Related topics
    Replies
    Views
    Last post