Example: sysmod
As the database administrator, you modify all system catalogs in distributed database mystardb. (This is the most common usage of sysmod.) Note that you do not use the /star suffix on the distributed database name:
sysmod mystardb
As the database administrator, you modify the Ingres Star catalogs iidbcapabilities, iiddb_tree, and iiddb_objects in distributed database herstardb:
sysmod herstardb iidbcapabilities iiddb_tree iiddb_objects
As the database administrator, you modify just the catalogs for the Vision product on database mystardb:
sysmod mystar -f vision