Oninit cdi / Archive
Talk to an expert →

Which tables are in which dbspace?

Posted in 1999

Topics: Storage & Space Management, Platform-Specific Issues

Surfer! — — source: Informix-list mailing list archive (1991-1998)

How can we find out which tables are in which dbspaces, with SQL or onstat or whatever! Of course it should be documented somewhere but there's a gap between theory and practise. Using OL 7.30 on SOLARIS 2.6. -- Surfer!

↪ replying to Surfer!
Vic Glass — — source: Informix-list mailing list archive (1991-1998)

One way: oncheck -pe "Surfer!" wrote: > How can we find out which tables are in which dbspaces, with SQL or > onstat or whatever! > > Of course it should be documented somewhere but there's a gap between > theory and practise. > > Using OL 7.30 on SOLARIS 2.6. > > -- > Surfer!

↪ replying to Surfer!
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)

Surfer! wrote: > > How can we find out which tables are in which dbspaces, with SQL or > onstat or whatever! > > Of course it should be documented somewhere but there's a gap between > theory and practise. > > Using OL 7.30 on SOLARIS 2.6. Get my listdb7.ec utility from the IIUG Software Repository in the package named utils2_ak. Even if you do not have the ESQL/C or 4GL 7.20+ needed to compile it the source to it and the other utilities you will get will provide much insight. Art S. Kagel

Glossary