I worked with Ingres on an OpenVMS system.
Tables are stored in files. Large tables can be stored in files on several locations.
All database meta-data is in the iidbdb database.
Table definitions are in .IDX files. Location, storage structure and indexes are in here.
- isql <dbname>
- Nice interface to the database.
CTRL-L for scrolling to the right, CTRL-H for scrolling to the left. - SQL> set lockmode session where readlock=nolock;
- Avoid database locks, always do this while running large queries.
- SQL> help <tablename>*
- Show definitions of all tables with names starting with <tablename>
- SQL> help procedure <procname>
- Show definition of all procedures with names starting with <procname>
- SQL> select table_name,location,file_name,file_ext from iifile_info where table_name = <tablename>
- Get the filename in which the table is stored.
- $ OPTIMIZEDB -zss10 -zv -zk ppasdb -rbilo_batch_install_log
- Optimize the table based on the current situation in 10% of the table
- SQL> modify <tablename> to reorganize with location=(<location> [,<location>] )
- Rewrite the tables files to the locations given, this reclaims unused space in the files and returns it to the filesystem.