17.27 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 exportassetassoc

  • ioutils exportdevice

  • ioutils exportdevicedetail

  • ioutils exportfield

  • ioutils exportfilter

  • ioutils exportoplog

  • ioutils exportpolicy

  • ioutils exporttemplate

  • ioutils exportupdategroup

  • ioutils exportupdatelist

  • ioutils importasset

  • ioutils importassetassoc

  • ioutils importexlog

  • ioutils importfield

  • ioutils importfilter

  • ioutils importpolicy

  • ioutils importtemplate

  • ioutils importupdategroup

  • ioutils importupdatelist

  • startservice

  • stopservice

  • updatesupportinfo

  • deletenwgroup

  • deletepackage

  • distributelicense

• The argument -s cannot be specified in a cluster environment. If you specify this argument, the command fails.

• When executing database reorganization, if the database are being accessed from Remote Install Manager or JP1/IT Desktop Management 2 - Asset Console, the database reorganization may fail. The following measures should be taken before executing database reorganization.

  • Terminate the remote installation manager.

  • Check whether the command of the distribution function using the Remote Install Manager is not running.

  • Check whether JP1/IT Desktop Management 2 - Asset Console is not acquiring management information.

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:

• 17.1 Executing commands

To Page Top