Catalog performance generally isn't any kind of problem if you are using Enhanced Catalog Sharing, or, better, Record Level Sharing on the catalogues. Having said that, catalogues shouldn't get so large that they use more than one index level.
Ant. -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Jake Anderson Sent: Saturday, 9 May 2015 2:49 AM To: [email protected] Subject: Re: [DB2-L] - ICF catalog management for a new DB2 subsystem Hi Liz I thought have different component of DB2 in different user catalog might improve the performance. Jake On 8 May 2015 20:22, "Lizette Koehler" <[email protected]> wrote: > Jake, > > We use one HLQ for most of the DB2 data sets on z/OS. ICFCATALOGs are > only defined once for all DB2 environments. We do not define a new > catalog with upgrades or new installs. Only one Usercat. An ICF Cat > belongs to SMS and not DB2 environment. I would expect it to > following the same standards that your shop currently uses for any product > that has an HLQ. > > > > I think this will depend more one your recovery and DR processes at > your shop. > > > > Please let us know what your understanding of IC F Catalogs and their > usage. > > > > Lizette > > > > > > From: jake anderson [mailto:[email protected]] > Sent: Friday, May 08, 2015 6:47 AM > To: [email protected] > Subject: [DB2-L] - ICF catalog management for a new DB2 subsystem > > > > Hello, > > Cross Posted in IBM MAIN > > Could you please let me know on how you use the ICF catalog to manage > the > DB2 install ? Like do you maintain a seperate ICF for BSDS, LOGCOPY ? > > Any best practises followed on managing the ICF catalog during any DB2 > installs ? > > Any advises or suggestion are highly appreciated. > > > > Regards, > > Jake > > _____ > > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, send > email to [email protected] with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
