Generating the schema for the entire CMS database

Last Updated : Oct 14, 2022 |
Prolog information
To generate the CMS database schema:
  1. Log in to the system as root.
    ADDITIONAL INFORMATION:
    Important:
    You cannot directly log on as root from a remote connection. You must log on using an administered CMS user ID, then use su - root to log on with root privileges.
  2. Enter the following command to set the Informix environment:
    ADDITIONAL INFORMATION:
    . /opt/informix/bin/setenv
  3. Enter cd /tmp.
    ADDITIONAL INFORMATION:
    Note:
    You can use a different directory to contain your database schema with one exception. Never use the root (/) directory to store a database schema. A database schema can be very large and will use up all the disk space allocated to the root directory. If the root directory does not have enough disk space, CMS will not function correctly.
  4. Enter dbschema -d cms cms.sql.
    ADDITIONAL INFORMATION:
    The system saves the CMS database schema in the /tmp directory as a file named cms.sql.
    Note:
    You can use different options to modify the dbschema command used in Step 4. For more information, see Modifying the dbschema command.