Find Database Names from a Script
The DBA sometimes needs to be able to run scripts or programs that will take an action on every database in an OnLine instance. An example would be if the DBA wanted to do some reports of space utilization by database. Another example would be running an UPDATE STATISTICS command in SQL for all databases. OnLine does not make it easy to do this. The information is readily available, since isql asks you to choose a database before you do any work from the menu, but there is no simple and straightforward way I know to do this from a script.
In this case, we need to take the brute force approach. This information is available in the tbcheck -pe output as part of the fully qualified table names. The following script, ...
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.
