Re: LISTLOCKS - for OnLine 4.0

Posted in 1992

Jerry Pope — 15 Jul 92 19:27:00 GMT — source: Informix-list mailing list archive (1991-1998)

In article 13687@techmpc.csg.gss.mot.com, daves@techmpc.csg.gss.mot.com (Dave Schmitt) writes: > >CAVEATS: > > There is no way I know in 4.0 to look up a list of databases. You > have to hard code them into the script. Tablespace #2 (partition 0x1000002) in the root dbspace lists all databases in that instance of OnLine. If you log in as "informix", you can get this info by running "tbcheck -pp 0x1000002 1". I believe each entry in this tblspace gives -- tblspace # of the corresponding systables portion of the catalog date/time of creation DB owner DB name --- -- Jerry Pope Ext 6196 Bldg 4100, Floor 2