jssdbrorg.bat (reorganizes the Item management database)

Description

This command reorganizes the Item management database by incorporating the free space that is defragmented when data is added to or deleted from the database. To run this command, go to the Start menu and click Programs, JP1_Service Support, and JP1_SS Command Prompt. Then execute the command.

To Page Top

Format

jssdbrorg.bat -sys

To Page Top

Required execution permission

Administrator permissions

To Page Top

Storage folder

JP1/SS-path\tools\

To Page Top

Arguments

To Page Top

Return values

To Page Top

Prerequisites for executing the command

• For details about which services need to be active or inactive when this command is executed, see Status of services when commands are executed in Chapter 12. Commands.

• Before you execute the jssdbrorg.bat command, execute the jssdbbackup.bat command with the -maint option to make a backup of the data in the Item management database. For details about the jssdbbackup.bat command, see jssdbbackup.bat (backs up databases) in Chapter 12. Commands.

• While the jssdbrorg.bat command is being executed, do not execute other JP1/Service Support commands.

• When you execute the jssdbrorg.bat command, temporary files are created. For this reason, the installation folder for JP1/Service Support requires the following available space depending on the size of the Item management database:

  • When the Item management database is size S: 2.8 gigabytes

  • When the Item management database is size M: 16.5 gigabytes

  • When the Item management database is size L: 40.5 gigabytes

  • When the Item management database is size LL: 80.0 gigabytes

  • When the Item management database is size XL: 80.0 gigabytes

To Page Top

Remarks

• When you execute the jssdbrorg.bat command, multiple child processes start within the system. Even if you cancel the jssdbrorg.bat command by using Ctrl+C, the child processes continue running. For this reason, do not cancel the jssdbrorg.bat command during execution by using Ctrl+C. If you happen to do so, make sure that the pdrorg process is inactive. Wait for a while and re-execute the command.

• If you cannot secure sufficient space for reorganizing the database on the disk where JP1/Service Support is installed, perform the following procedure to change the output destination folder for the temporary files that are created when the database is reorganized:

  1. Open JP1/SS-path\conf\setup\jssdbrorgpath.bat.

  2. In the file, on the 6th line, after @set CHANGEPATH=, use an absolute path to specify the folder to which temporary files are to be output.

  3. Delete @rem at the beginning of the 7th line.

  4. Save the file.

  If you do not change the output destination folder for the temporary files, the path for the folder is either of the following by default:

  • For the basic configuration: JP1/SS-path\log\command

  • For the cluster configuration: folder-containing-shared-files-on-shared-disk\log\command

• If a KNAB26105-E error message appears after you change the output destination folder for the temporary database reorganization files and execute the jssdbrorg.bat command, the cause might be one of the following:

  • The drive containing the output destination folder has insufficient space.

  • A file was specified as the output destination folder.

  • The output destination folder is immediately under a disk drive.

  • The drive containing the output destination folder is a network drive.

  • The output destination folder name contains multi-byte characters or characters that are not allowed by the OS.

  • The output destination folder name contains characters other than the following:

    - Half-width alphanumeric characters

    - Half-width space characters

    - Half-width symbols

    - \, @, #, ., ( )

  • The drive containing the output destination folder does not exist.

  • A UNC path was used to specify the output destination folder.

  • The output destination folder name consists of 180 bytes or more.

  If any of the above causes apply, recover the data in the Item management database using the backup file that you created before you executed the jssdbrorg.bat command. Eliminate the cause of the error and re-execute the jssdbrorg.bat command.

• If you execute the jssdbrorg.bat command when the database is nearly full, database reorganization might fail. If this occurs, execute the jssdelrec command to delete unnecessary Items, and then re-execute the jssdbrorg.bat command.

To Page Top