I guess the great irony is how will we ever get it right if we scramble the data, when we can't even get it right when it is unscrambled. Of course I suppose, one could always argue that the production data is already scrambled. :-)
On Tue, Jun 15, 2010 at 12:31 PM, Donald Johnson <[email protected]> wrote: > One thing to remember is that production data may not always be the best > test, as it may not contain all possible combinations of values in the > various fields. Just because it is production does not mean it is > comprehensive. > > * Don * > > On Tue, Jun 15, 2010 at 12:28 PM, George Henke <[email protected]> wrote: > > > There are over 5000 indexes to Tables in my clients production DB2 > > system which is a relatively small by industry standards. > > > > But I must admit, I can't imagine how, in a mainframe environment, > > sensitive > > data could be scrambled without losing "referential integrity" or how > > anyone > > could cost effectively reproduce this data from scratch and then have any > > confidence in the test results. > > > > Of course I suppose, one could argue that the production data is already > > scrambled. :-) > > > > On Tue, Jun 15, 2010 at 12:17 PM, Staller, Allan <[email protected] > > >wrote: > > > > > Yes to both, but no details available. Check the Payment Card Industry > > > (PCI) materials. > > > > > > <snip> > > > 1) Does anyone know of developers being prevented from using production > > > data > > > and being required to create their own test data completely from > > > scratch? > > > > > > 2) Does anyone know of a software tool that will scramble production > > > data > > > like SSNs while maintaining "referential integrity" ( DB2, IMS, etc) to > > > prevent developers from having access to sensitive production data? > > > </snip> > > > > > > ---------------------------------------------------------------------- > > > For IBM-MAIN subscribe / signoff / archive access instructions, > > > send email to [email protected] with the message: GET IBM-MAIN INFO > > > Search the archives at http://bama.ua.edu/archives/ibm-main.html > > > > > > > > > > > -- > > George Henke > > (C) 845 401 5614 > > > > ---------------------------------------------------------------------- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to [email protected] with the message: GET IBM-MAIN INFO > > Search the archives at http://bama.ua.edu/archives/ibm-main.html > > > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > -- George Henke (C) 845 401 5614 ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
