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
