Any or all of the following can improve performance of the catalog. ECS especially will dramatically reduce the enqueues.
1) Increase the STRNO to 5 or 7. 2) Add to VLF. 3) Implement ECS (Enhanced Catalog Sharing). 4) Remove IMBED. Terry Traylor charlesSCHWAB TIS Mainframe Storage Management tis-mfs-storage (602) 977-5154 WARNING: All email sent to or from this address will be received by the Charles Schwab corporate e-mail system and is subject to archival and review by someone other than the recipient. -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of DMR-Qualitas Outsourcing Sent: Wednesday, November 30, 2005 1:42 AM To: IBM-MAIN@BAMA.UA.EDU Subject: STRNO in DB2 catalog Hi folks, I'm revising catalog parameters to improve performance and I have found that DB2 catalog has STRNO=2 (concurrent read request). This catalog was created in 1991 and perhaps this value could be increased to decrease SYSZRPLW enqueues. Thanks in advance ---------------------------------------------------------------------- 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 ---------------------------------------------------------------------- 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
