enumerate contents of sbspace?

Posted in 2019

DAVID GROVE — Fri, 09 Aug 2019 23:17:16 — source: IIUG Forums & Mailing Lists

IDS 12.10FC12 Solaris 10 1/13 How might it be possible to exhaustively enumerate all objects within a given sbspace? That is, for each object in the specified sbspace, list the database, table, and column which is associated with that object? Thank you. DG

↪ replying to DAVID GROVE

DAVID GROVE — Fri, 09 Aug 2019 23:46:53 — source: IIUG Forums & Mailing Lists

P.S. In a related thread a couple years ago, we discussed going "the other way". So, I guess I could go through every database, and find all tables that have a column that "lives" in the specified sbspace. Sort of "brute force", but should work.

Glossary

sbspace
IDS (Informix Dynamic Server)