Listdb7
Utility: listdb7.ec Synopsis: Enhanced version of listdb5.ec that uses the SMI and system tables. Lists databases and optionally their tables. An option prints additional information such as dbspace, owner, logging mode, create date, and NLS status for databases and similar information for tables/fragments/detached indexes. Author(s): Art S. Kagel Version(s) supported: 7.xx, 9.xx Revision: 1.19 File(s): listdb7.ec Comments: Great for tracking down which databases/tables reside in what dbspaces or for a quick table extent report. By specifying -d'*' and -ttablename you can search all databases for a specific tablename. Linking with GNU getopt() improves usability and is now automatic. Release Notes: Fixed compilation problem in getopt.c on Linux. Thanks to Jim Kenedy for pressing the issue until I found it. Revisions 1.18 - 1.19 fix a problem reporting extent information for the last table listed for each database. Revision 1.17 resolved problems compiling on Linux due to missing prototypes in strings.h that are in string.h instead. Revision 1.16 added an error message if the selected database does not exist. Previous versions were silent. Revisions 1.12 - 1.15 add an extent report if -D and -t are specified. Also made -t work correctly with or without GNU getopt. If linking with GNU getopt add -DHAVE_GNU_GETOPT=1 to the compiler commandline. Commandline syntax for -t differs depending on which getopt you are using but the Usage printout is adjusted accordingly. Revision 1.11 adds a -V option to print version and copyright info. Revision 1.10 added long name support. Revision 1.9 extends the portability fix in 1.8 to table level calculations also. Revision 1.8 replaces bit field code for determining dbspace numbers with division by 0x100000. The bit fields do not mapp properly on Intel compilers.