[DB2 z/OS] USER CATALOG - Rules of Thumb and best practices

2011-11-11 Thread Rodney Krick
Thank you very much for the valuable pieces of information! Here the points I've noted from your posts, in order to help others that may search for the same topic. The original question: I'm looking for some DB2 specific recommendations regarding User Catalogs, specially if there are any rules

Re: [DB2 z/OS] USER CATALOG - Rules of Thumb and best practices

2011-11-11 Thread Paul Peplinski
One exception to that would be if you intend to use system backup and system restore. Each subsystem needs two dedicated catalogs, BSDS, LOGS and ARCHLOGS in one, and all other stuff in another (at least that was the guidance given to us). Paul

Re: [DB2 z/OS] USER CATALOG - Rules of Thumb and best practices

2011-11-11 Thread Ted MacNEIL
Why? --Original Message-- From: Paul Peplinski Sender: IBM Mainframe Discussion List To: IBM Mainframe Discussion List ReplyTo: IBM Mainframe Discussion List Subject: Re: [DB2 z/OS] USER CATALOG - Rules of Thumb and best practices Sent: 11 Nov 2011 17:26 One exception to that would

[DB2 z/OS] USER CATALOG - Rules of Thumb and best practices

2011-11-10 Thread Rodney Krick
Hi, I'm looking for some DB2 specific recommendations regarding User Catalogs, specially if there are any rules of thumb as a start point for defining the infrastructure for DB2 (like each member has its own catalog or something like that). I've searched the forum and asked daddy google, but

Re: [DB2 z/OS] USER CATALOG - Rules of Thumb and best practices

2011-11-10 Thread Wayne Driscoll
/Development wdrisco(AT)us.ibm.com === From: Rodney Krick r...@aformatik.de To: IBM-MAIN@bama.ua.edu Date: 11/10/2011 12:56 PM Subject: [DB2 z/OS] USER CATALOG - Rules of Thumb and best practices Sent by: IBM Mainframe Discussion List IBM-MAIN@bama.ua.edu Hi

Re: [DB2 z/OS] USER CATALOG - Rules of Thumb and best practices

2011-11-10 Thread Clark, Kevin
to avoid extents. Kevin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of Rodney Krick Sent: Thursday, November 10, 2011 1:43 PM To: IBM-MAIN@bama.ua.edu Subject: [DB2 z/OS] USER CATALOG - Rules of Thumb and best practices Hi, I'm

Re: [DB2 z/OS] USER CATALOG - Rules of Thumb and best practices

2011-11-10 Thread Ed Finnell
Part of it is nomenclature. DB/2 catalog vs MVS catalog. I put each DB/2 catalog in a separate UCAT. It's all part of the installation process for DB/2. Also specify SYSVOLs or SMS managed for tables and indices and matching SSI. Still want to buggy whip whomever picked DSN as DB/2 hlq!

Re: [DB2 z/OS] USER CATALOG - Rules of Thumb and best practices

2011-11-10 Thread Rick Fochtman
---snip--- I don't have any DB2 specific advice regarding user catalogs, but when you ask about each member having its own catalog, if you mean member in the sense of DB2 data sharing, that really won't work, since DB2 treats