Finding dbspace from system catalog tables
Posted in 1998
James Richardson — — source: Informix-list mailing list archive (1991-1998)
I am currently attempting to write a dbschema-alike program, which analyses the information contained in the sys* tables, which will compare differences between two different database schemas, and , later, will generate the SQL to convert one database to be the same as another. Things are going fairly well so far, however I have found no information about how to determine which dbspace a table is in from the system catalog. If anybody could tell me where the information is, that would be great. TIA James Richardson PS: The next step is determining how to reconstruct fragmentation information, so if you have any tips......