Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Masking of specific DB2 columns while unload/load

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
madishpa

New User


Joined: 18 May 2007
Posts: 27
Location: Hyderabad

PostPosted: Thu Sep 02, 2010 3:07 pm    Post subject: Masking of specific DB2 columns while unload/load
Reply with quote

Hi,

Could anyone please advise regarding the masking of particular data columns while unloading DB2 tables.
My requirement is to unload DB2 tables from production environment and load into pre-production environment.
I would need to take care of things like masking information related to customer-like name, phone number etc.

Could you please advise if there is already any method for encryption/masking.Even if while loading into pre-production environment if this request is met, then also it is fine.
If not, please advise if there is any tool which can take care of this request.

Thanks in advance.

Kind regards,
Pavan.
Back to top
View user's profile Send private message

daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 660
Location: Pennsylvania

PostPosted: Thu Sep 02, 2010 6:23 pm    Post subject:
Reply with quote

There must be many products available to do this.

One I know of is Optim, from IBM (formerly a PST product).

You use this rather than an unload.

If you want to stay with unload/load then you probably need to write your own to mask the data prior to the load.

We chose to use Optim in conjunction with our own code to permform this task.

It took two people, 9 months to complete.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
Location: italy

PostPosted: Thu Sep 02, 2010 6:27 pm    Post subject: Reply to: Masking of specific DB2 columns while unload/load
Reply with quote

data masking / obfuscation is not something to be taken lightly!

if the data <obfuscated> is not related to anything else just putting random chars/numbers will be enough

if the data is involved in some kind of <logical relation> with some other tables/dataset You will need a consistent masking approach

the power of Your organization should be aware of the legal aspects of data obfuscation
the most effective approach both from a technical and legal point of view might be to rely on products designed for data masking

google for "data masking obfuscation certification" and You will find lots of hints and gotchas and solutions ( buyt not free )
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Sep 03, 2010 8:18 am    Post subject:
Reply with quote

Pavan,
Quote:
masking of particular data columns while unloading DB2 tables

If those columns are not used in the program. Why unload and load those columns ? You can skip it in the unload and load default values.

As enrico said,
Quote:
if the data is involved in some kind of <logical relation> with some other tables/dataset You will need a consistent masking approach.

That would be really interesting.

Sushanth
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 647
Location: Whitby, ON, Canada

PostPosted: Tue Jan 18, 2011 1:39 am    Post subject:
Reply with quote

Beware this pitfall of using masked data http://donleahy.blogspot.com/2009/11/masking-test-data.html icon_redface.gif
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Jan 18, 2011 8:56 pm    Post subject:
Reply with quote

Thanks Don.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Route a product's job to specific lpar vasanthz All Other Mainframe Topics 9 Thu Mar 02, 2017 2:22 am
No new posts Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm
No new posts Comparing Decimal and CHAR columns rakesh17684 DB2 7 Thu Oct 20, 2016 2:33 am
No new posts how to split records based on specifi... Venkata Ramayya DFSORT/ICETOOL 6 Wed Sep 28, 2016 3:20 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us