18.2.2 Reorganizing the asset management database using commands
This subsection describes the function, format, options, and return values of jamemb_reorganization.bat, which reorganizes the restored asset management database. It also provides notes on its execution, followed by an execution example.
jamemb_reorganization.bat is stored in the following folder:
Asset-Console-installation-folder\exe
If reorganization fails, the asset management database can no longer be used. In such a case, restore the backup data of the asset management database.
- Organization of this subsection
(1) Function
jamemb_reorganization.bat reorganizes the asset management database.
(2) Format
jamemb_reorganization.bat port-number user-ID password -o result-file-path [-y]
(3) Options
- port-number
-
Specifies the database connection port number that was specified when Asset Console was installed. To identify the port number that was set, check PDNAMEPORT in the HiRDB.ini file, which is stored in Asset-Console-installation-folder\aimdb\conf\emb. Specification of this option is mandatory.
- user-ID, password
-
Specifies the values that were set in Login ID in Database Information in the Server Setup dialog box. Specification of this option is mandatory.
- -o result-file-path
-
Specifies the full path of the file to which the execution results are to be output. Specification of this option is mandatory.
- -y
-
If this option is specified, the command starts the reorganization processing without waiting for a key response.
If this option is omitted, the command waits for a key response. To cancel execution, press the Ctrl + C keys.
(4) Return value
Returns one of the following return values:
Return value |
Description |
---|---|
0 |
Normal termination. You can check the result file for the details of reorganization. |
11 |
Invalid option format. |
101 or greater |
Terminated with another error. |
(5) Notes on command execution
-
Before you execute jamemb_reorganization.bat, stop all Asset Console services, commands, and tasks.
Stop the Asset Console services in the following order:
-
World Wide Web Publishing Service or World Wide Web Publishing
-
Asset Console commands and tasks
When you use Asset Console after having executed jamemb_reorganization.bat, start the services in the reverse of the order in which they were stopped.
-
-
Execute jamemb_reorganization.bat as a user with administrator permissions.
(6) Execution example
jamemb_reorganization.bat 31022 admin admin -o C:\temp\backup\kekka.log -y