Re: Question on use of CLI and table privileges

Scott Black wrote: > I'm going through the same process, > } You will have to define access privileges on a user-by-user and > } table-by-table basis. > We have done this only to end up with 60 or 70 extents > on the syscolauth, etc tables. This obviously kills engine > performance... There doesn't appear to be a better solution other > than being less stringent with our permissions (something by boss > says is unacceptable ;-) Your boss is right. I've seen the same problem with "overflow" of the system tables and the only solution I can think of of is to do a "tbunload" of your database (to tape or file), drop the database and then do a "tbload" of the database. This is supposed to append all extents of a table into one, regardless of the original first and next extent sizes. Beware: I have never myself actually used this solution, so I cannot really tell if it works. YMMV. Regards, Richard -- +--------------------------+------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | GSM : +49-172-8933578 | +--------------------------+------------------------------------------+