Configuring the database in command-line mode

You can use command-line mode to configure the database.

About this task

When you save a record the changes are stored in temporary database configuration objects. Before you configure the database, you can close and reopen the Database Configuration application without losing any saved changes. A secondary table stores pending changes, which also appear in the Status field. You cannot query on Status.

Procedure

Shut down your application server and wait for one minute. The application server session timestamp updates every 60 seconds.
Open a command prompt and change the directory to install_home\tools\maximo.
To configure the database and restore the backup tables, type configdb. If you do not need to restore the backup tables, edit the configdb.bat file.
Sometimes the data in the temp tables (XX+tablename) must be modified before restoring. Perform the following steps:
1. Remove the -r parameter from the configdb.bat file.
2. Save your changes.
3. Return to the command prompt and type configdb.
If configuration errors occur, resolve the errors in the database. Open the log files for troubleshooting at install_home\tools\maximo\log.
Restart the application server. If backup tables were created, delete them before reconfiguring the database. If you ran configdb without the -r parameter, and if tables were rebuilt, you must restore the backup tables.

Feedback