Access Production From non-Production Subsystems

Steve Runtsch

Access Production From non-Production Subsystems
We currently do not generally allow access to production DB2 z/OS
subsystems from non-production subsystems or vice versa (via three-part
names or CONNECT, for example). We do have a couple of exceptions which
DBAs have become accustomed to using, and this ability does simplify some
database maintenance activities. For example, extracting DDL from one
subsystem and using it to create objects in a second subsystem can be done
in a single job step. Now we have been asked to provide that convenience
on all subsystems.

I think we understand the benefits of providing DBAs the access that they
have requested. My question is, for what reasons should this access not
be allowed? Do other shops not allow non-production to production
subsystem access and why? Do you have policies in place that you use to
help enforce restricting this type of access?

Any information or thoughts that you provide about this will be greatly
appreciated.

Steve Runtsch
Assurant, Inc.
This e-mail message and all attachments transmitted with it may
contain legally privileged and/or confidential information intended
solely for the use of the addressee(s). If the reader of this
message is not the intended recipient, you are hereby notified that
any reading, dissemination, distribution, copying, forwarding or
other use of this message or its attachments is strictly
prohibited. If you have received this message in error, please
notify the sender immediately and delete this message and all
copies and backups thereof. Thank you.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L