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 management 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 2 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 2-installation-folder\mgr\temp
Storage location
JP1/IT Desktop Management 2-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 2.
Notes
-
Execute this command when the management server setup is completed and the management server is stopped.
-
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 exportupdatelist
-
ioutils importasset
-
ioutils importexlog
-
ioutils importfield
-
ioutils importfilter
-
ioutils importpolicy
-
ioutils importtemplate
-
ioutils importupdategroup
-
ioutils importupdatelist
-
startservice
-
stopservice
-
updatesupportinfo
-
deletenwgroup
-
distributelicense
-
-
The argument -s cannot be specified in a cluster environment. 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 was in the process of starting when the command was 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. |
53 |
The management server is not stopped. |
54 |
The management 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 services on the management server, reorganize the database, and automatically start the services on the management server.
reorgdb -s
Related Topics: