The HTML Version of the Sysmaster Documentation
Earlier, I make a parenthetical comment in Lester's article about a method that allows the user to make a "fake" copy of the sysmaster database. You may have wondered why I did that. Since the dbschema program will not report on pseudotables, in order to get a schema generated for the sysmaster database, you have to massage the sysmaster.sql script that is used by Informix to generate the sysmaster database in the first place. Be sure and work on a copy.
If you haven't looked at this sysmaster.sql script, you might find it interesting anyway. It has documentation for most of the fields that are found in the sysmaster tables. Anyway, to create the "fakesmi.sql" script, change the "create database ...
Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
