Previous Topic

Next Topic

usermod Command—Modify Tables to Currently Defined Storage Structure

The usermod command modifies the user-defined tables of a database to their currently defined storage structure and recreates any secondary indexes that are currently defined.

Similar to the sysmod command for system catalogs, usermod is a useful utility for maintaining user tables. Running the usermod utility on a regular basis or when the table has excess overflow pages improves the performance of query processing.

You can run usermod on the whole database or on specified tables. If no specific tables are specified, all the tables belonging to the user are modified. The usermod command writes its files to the II_TEMPORARY directory.

The usermod command has the following format:

usermod dbname |vnode::dbname[/server_class] [-uusername] [tables] [-online]
[-noint] [repmod [+w|w]]

© 2007 Ingres Corporation. All rights reserved.