I am a bit confused. Dose the term 'DB2 catalog' in the original posting refer to the ICF catalog that points to data sets of any type or the special set of objects in DB2 that contains DB2 system information.
I fankly assumed it was the second case ... There is nothing uniquely DB2 about the ICF catalog that points to DB2 data sets. It is the same sort of catalog that points to any other data set. In most shops it may not even ve a seperate user catalog, often the DB2 system data sets like SDSNLOAD share the same catalog as DB2 database objects with names like hlq.DSNDBC.DSNDB06.**. This particular pattern happens to be the one used by the DB2 Catalog. hlq.DSNDBC.DSNDB01.** is used by the DB2 directory. DB2 catalog usually means those datasets named hlq.DSNDBC.DSNDB06.** and DB2's internal use of them. For the thing that points to any dataset the term DB2 people use is "System Catalog" The thing that opens and closes DB2 database objects is the *DBM1 address space only. User address spaces do not open close DB2 database objects it uses the allocations in *DBM1. DB2 tends to keep data sets allocated and opened forever. This is true of most data base systems. There are some controls MAX Datasets usually set in the 10s of thousands, and operator commands to take a object off line for rare activities like realocating the under lying structure. High access thends to happen at DB2 start up time See APAR PQ02028 Tech note 1161909 Redbook SG24-6129 (DB2® for z/OS® and OS/390® Version 7 Performance Topics), section 4.2 Parallel data set open. etc ---------------------------------------------------------------------- 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
