Re: Finding busy tables

Posted in 1998

Art S. Kagel — Fri, 25 Sep 1998 11:09:54 -0400 — source: Informix-list mailing list archive (1991-1998)

Marco Greco wrote: > > Can't do with SE. Online 4.x, I wouldn't know. What do I know is that on OL5 > you can have a sort of sysmaster database: to create it, just pass makeps.sql > (it's in $INFORMIXDIR/etc) thru dbaccess. NO NO NO! DO NOT EVER RUN THAT SCRIPT! Remove it now before you are tempted! I did that once. The server became VERY WEIRD! Tech support had me drop the database in the hopes that things would get back to normal, they did not. I had to bounce the engine as the memory data structures had become unstable. The script was a remnant of early experiments that ultimately lead to SYSMASTER and somehow the script got into some distributions (after 5.04 I think) and remained but it should not be run. Art S. Kagel