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
