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:
- Remove the -r parameter from the configdb.bat file.
- Save your changes.
- 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.