17.25 reorgdb (reorganizing the database)
Functionality
This command reorganizes the database. We recommend that administrators run this command regularly to maintain good database performance.
Execute this command on the following servers:
-
In a single-server configuration system: Management server
-
In a multi-server configuration system: Database server
In a multi-server configuration system, execute the commands in the following order:
-
Execute the stopservice command on the management server. Alternatively, you can go to the Windows Start menu and select Administrative Tools and then Services, to stop the following services:
-
JP1_DTNAVI_WEBCON
-
JP1_DTNAVI_AGCTRL
-
JP1_DTNAVI_MGRSRV
-
-
Execute the stopservice command on the database server.
-
Execute the reorgdb command on the database server.
Format
reorgdb[ -s][ -w work-folder-name]
Argument
- -s
-
Specify if you want to run a set of commands for stopping management server services (the stopservice command), reorganizing the database (the reorgdb command), and starting the management server services (the startservice command) automatically.
- -w work-folder-name
-
Specify the absolute path to the work folder to be used during database reorganization. Only a folder in a local drive can be specified. 30 GB or more free space is required for the drive where the work folder resides, in order to manage 10,000 devices. In a cluster configuration, specify a folder on the shared disk.
To specify a path containing a space, enclose the strings with double quotation marks ("). Specify a folder name that is 150 bytes or fewer in length, and exclude the backslash (\) at the end of the folder name. Half-width alphanumeric characters, white space, and the following special characters are allowed:
#, (, ), .(period), @, \
If any other characters than above are used for the JP1/IT Desktop Management installation folder, always specify this argument. If the specified folder does not exist, an error is returned.
When this argument is omitted, the folder below is used as a work folder.
JP1/IT Desktop Management-installation-folder\mgr\temp
Storage location
JP1/IT Desktop Management-installation-folder\mgr\bin\
You can execute this command without specifying the storage location for the executable file, by using the command prompt provided by JP1/IT Desktop Management.
Notes
-
Execute this command in the following state:
In a single-server configuration system: When the management server setup is completed and the management server is not running
In a multi-server configuration system: When the database server is completed, and the services on the management server and the database server are not running
-
This command cannot be simultaneously executed by multiple users.
-
This command cannot be executed simultaneously with any of the following commands:
-
exportdb
-
importdb
-
ioassetsfieldutil export
-
ioassetsfieldutil import
-
ioutils exportasset
-
ioutils exportdevice
-
ioutils exportdevicedetail
-
ioutils exportfield
-
ioutils exportfilter
-
ioutils exportoplog
-
ioutils exportpolicy
-
ioutils exporttemplate
-
ioutils exportupdategroup
-
ioutils importasset
-
ioutils importfield
-
ioutils importfilter
-
ioutils importpolicy
-
ioutils importtemplate
-
ioutils importupdategroup
-
startservice
-
stopservice
-
updatesupportinfo
-
-
The argument -s cannot be specified in a cluster environment or in a multi-server configuration system. If you specify this argument, the command fails.
Return value
The following table shows the return values of the reorgdb command.
Return value |
Description |
---|---|
0 |
The command finished normally. |
1 |
Reorganization of the database was successful. But a failure occurred with automatically starting the management server. |
11 |
The format for specifying the command arguments is invalid. |
12 |
The specified folder is invalid, or the folder does not exist. |
31 |
Another command is being executed. |
33 |
The disk does not have enough space. |
34 |
The starting of the database failed. |
35# |
The management server or the database server was in a start process when the command is executed. |
36 |
The database was in a shutdown process when the command was executed. |
51 |
You do not have the permissions to execute this command. |
52 |
The argument -s is specified in a cluster environment or in a multi-server configuration system. |
53 |
The management server has not stopped in a single-server configuration system The management server or database server has not stopped in a multi-server configuration system. |
54 |
The management server or database server has not been set up. |
55 |
The default work folder is not usable. |
101 |
Reorganization of the database failed. |
102 |
Failed to automatically stop the management server. |
110 |
The command execution failed due to a problem with the license. |
150 |
The command execution was interrupted due to some other error. |
#: The value to be returned when argument -s is specified
Example
The following example shows how to use this command to stop the management server services, reorganize the database, and start the management server services automatically in a single-server configuration system.
reorgdb -s
Related Topics: