You can modify the dbschema command using additional command options.
Procedure
Log in to the system as root.
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.
Enter the following command to set the Informix environment:
. /opt/informix/bin/setenv
Enter dbschema.
The system displays all the options that you can use to modify the dbschema command.