Re: Tablespace tablespace hackery

}From: gaffer@ibmpcug.co.uk (Andrew Beattie) }Subject: Tablespace tablespace hackery }Date: Fri, 22 Apr 1994 10:32:16 GMT }X-Informix-List-Id: <news.6439> } }I would like to be able to access the tablespace tablespace (and other hidden }tables) through a database, just like any regular table. } }My plan of action would be something like: } }Create a database, with a table with the same structure as the tablespace }tablespace, go into systables and change the partition number to point at }the real tablespace tablespace. } }Anyone done this before? Anyone got schemas? } }Yes, I know - I could do no end of damage this way... I think you're looking for the SysMaster database which comes as standard with OnLine DSA (Version 6.0). This handles exactly that sort of information. Of course, you don't have extensive update privileges, so you can't do much damage. If you want to play with a non-working, non-supported version of this, you can play with $INFORMIXDIR/*ps.sql -- but if it takes your OnLine system down (or out), that is your problem. This is rather like telling you there's a jar of nitro-glycerine over in the corner; you can go and pick it up and play with it if you want to, but I don't advise doing it. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>