Re: Developers' Use of Prod Data For Testing

2010-06-30 Thread Galambos, Robert
and then destroy it. From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of George Henke Sent: Tuesday, June 15, 2010 12:11 PM To: IBM-MAIN@bama.ua.edu Subject: Developers' Use of Prod Data For Testing 1) Does anyone know of developers being prevented from using

Re: Developers' Use of Prod Data For Testing

2010-06-25 Thread Morrie Meyer
Hello George, Scrambling of production data is very common these days. In addition to the IBM and Compuware tools, Macro 4's InSync can provide the type of data privacy functionality you're looking for. If cost is a factor than InSYnc is definitely worth a look. Regards, Morrie Meyer

Re: Developers' Use of Prod Data For Testing

2010-06-18 Thread Ed Gould
From: Rick Fochtman rfocht...@ync.net To: IBM-MAIN@bama.ua.edu Sent: Tue, June 15, 2010 3:04:06 PM Subject: Re: Developers' Use of Prod Data For Testing --snip--- One thing to remember is that production

Re: Developers' Use of Prod Data For Testing

2010-06-17 Thread Rob Barbour
George, BCV5 copies and masks / scrambles production data for a test environment. The product can do this while the data is being copied which saves quite a bit of time. BCV5 is part of the BCV4, BCV5, BCV6 line of fast clone / copy / refresh solutions for the DB2 z/OS environment. The

Re: Developers' Use of Prod Data For Testing

2010-06-16 Thread Mark Zelden
On Tue, 15 Jun 2010 12:10:32 -0400, George Henke gahe...@gmail.com wrote: 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? My

Re: Developers' Use of Prod Data For Testing

2010-06-16 Thread HUTCHISON Gregory
...@odot.state.or.us -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of George Henke Sent: Tuesday, June 15, 2010 9:11 AM To: IBM-MAIN@bama.ua.edu Subject: Developers' Use of Prod Data For Testing 1) Does anyone know of developers being prevented from using

Re: Developers' Use of Prod Data For Testing

2010-06-16 Thread Rod Steffens
Another product to check out is Testbase, from Softbase. We have had good success with this product. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET

Developers' Use of Prod Data For Testing

2010-06-15 Thread George Henke
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

Re: Developers' Use of Prod Data For Testing

2010-06-15 Thread Staller, Allan
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

Re: Developers' Use of Prod Data For Testing

2010-06-15 Thread Ken Porowski
etc. and software compliance . -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of George Henke Sent: Tuesday, June 15, 2010 12:11 PM To: IBM-MAIN@bama.ua.edu Subject: [IBM-MAIN] Developers' Use of Prod Data For Testing 1) Does anyone know

Re: Developers' Use of Prod Data For Testing

2010-06-15 Thread George Henke
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

Re: Developers' Use of Prod Data For Testing

2010-06-15 Thread Donald Johnson
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

Re: Developers' Use of Prod Data For Testing

2010-06-15 Thread Richards, Robert B.
: Tuesday, June 15, 2010 12:25 PM To: IBM-MAIN@bama.ua.edu Subject: Re: Developers' Use of Prod Data For Testing Testing with a full copy of production data is always best as well as testing with a created set of data to test all possibilities (invalid data tests too). I have head

Re: Developers' Use of Prod Data For Testing

2010-06-15 Thread Sam Siegel
On Tue, Jun 15, 2010 at 10:28 AM, George Henke gahe...@gmail.com 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

Re: Developers' Use of Prod Data For Testing

2010-06-15 Thread Thomas Kern
Part of what I look for in a good test is catching errors in the data. I always try to put some errors into the input data to make sure they don't get all the way through into production. I still catch errors in real production data because the developers were lazy on data validation, always

Re: Developers' Use of Prod Data For Testing

2010-06-15 Thread Thomas Kern
Look for a product from Voltage Security. Look for Phil Smith III. /Tom Kern George Henke wrote: 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

Re: Developers' Use of Prod Data For Testing

2010-06-15 Thread George Henke
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

Re: Developers' Use of Prod Data For Testing

2010-06-15 Thread Alan Brown
IBM Optim can privatize production data for a test environment while maintaining your application referential integrity. It works natively on z/OS to create privatized complete clones or subsets of production data. There is also a version for the distributed world.

Re: Developers' Use of Prod Data For Testing

2010-06-15 Thread Ed Finnell
In a message dated 6/15/2010 11:58:54 A.M. Central Daylight Time, gahe...@gmail.com writes: 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

Re: Developers' Use of Prod Data For Testing

2010-06-15 Thread Phil Smith
Alan Brown wrote: IBM Optim can privatize production data for a test environment while maintaining your application referential integrity. It works natively on z/OS to create privatized complete clones or subsets of production data. There is also a version for the distributed world. Voltage

Re: Developers' Use of Prod Data For Testing

2010-06-15 Thread Itschak Mugzach
And you have Camouflage (datamasking.com) , 1st on Gartner and forrester. ITschak On Tue, Jun 15, 2010 at 8:28 PM, Phil Smith p...@voltage.com wrote: Alan Brown wrote: IBM Optim can privatize production data for a test environment while maintaining your application referential integrity. It

SV: Developers' Use of Prod Data For Testing

2010-06-15 Thread Thomas Berg
   Specialist   A M   SWEDBANK -Ursprungligt meddelande- Från: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] För Richards, Robert B. Skickat: den 15 juni 2010 18:33 Till: IBM-MAIN@bama.ua.edu Ämne: Re: Developers' Use of Prod Data For Testing Take a look at Compuware

Re: Developers' Use of Prod Data For Testing

2010-06-15 Thread Rick Fochtman
--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

Re: Developers' Use of Prod Data For Testing

2010-06-15 Thread Rick Fochtman
--snip--- 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.