jssitemstoredbexpand.bat (expands an Item storage database)

Description

This command expands the size of the Item storage database. Both the Item storage area and attached file storage area in the Item storage database can be expanded. To execute this command, in the Start menu, click Programs, JP1_Service Support, and then JP1_SS Command Prompt.

To Page Top

Format

jssitemstoredbexpand.bat {-i name-of-the-configuration-file-for-expanding-an-Item-storage-database [-c online] | -c standby} 
                         [-q]

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

#

If the return value is 2, correct the cause of the error, recover the environment according to the following procedure, and then re-execute the command:

1. Stop the services in the following order:

   - JP1/Service Support - Task Service service

   - JP1/Service Support - Web Service service

   - JP1/Service Support service

2. Initialize the databases of JP1/Service Support.

   Execute the jssdbinit.bat (initializes databases) command to initialize the Item management database and the Item storage database. For details about the jssdbinit.bat (initializes databases) command, see jssdbinit.bat (initializes databases) in Chapter 12. Commands.

3. Set up the Item storage database.

   Execute the jssitemstoredbsetup.bat (sets up an Item storage database) command to set up the Item storage database. For details about the jssitemstoredbsetup.bat (sets up an Item storage database) command, see jssitemstoredbsetup.bat (sets up an Item storage database) in Chapter 12. Commands.

4. Expand the database so that the database will be in the same environment as when the backup file was created.

   Execute the jssitemstoredbexpand.bat (expands the Item storage database area) command to expand the Item storage database area to set up the same environment before the backup was made. For details about the environment when the backup file was created, see dbpath.txt stored in the directory to output the backup files to.

5. Recover the databases of JP1/Service Support.

   Execute the jssdbrecovery.bat (recovers a database) command to recover the Item management database and Item storage database from the backup file that was made before executing the jssitemstoredbexpand.bat command. For details about the jssdbrecovery.bat (recovers a database) command, see jssdbrecovery.bat (recovers a database) in Chapter 12. Commands.

To Page Top

Managing the expanded status of the Item storage database

The jssitemstoredbexpand.bat command collects the status of the Item storage database, and then expands the database size based on the status of the Item storage database. The expanded status of the Item storage database is managed by the Item management database, as follows:

• Number of expansions

  When the jssitemstoredbexpand.bat command is executed, the number of expansions of the Item storage database is checked. If the number has not reached the upper limit, the Item storage database is expanded, and the number of expansions of the Item storage database managed by the Item management database is updated. If the number has reached the upper limit, an error occurs, and the Item storage database is not expanded.

  The number of times the Item storage database can be expanded for each storage area is as follows:

  Item storage area: 7 times

  Attached file storage area: 7 times

• File path for expansion

  When the jssitemstoredbexpand.bat command is executed, you can change the configuration file for expanding an Item storage database to specify the location that stores the expanded area of the Item storage database. The Item management database manages the location that stores the expanded area of the Item storage database. The path to this location becomes necessary if a failure occurs.

To Page Top

Prerequisites for executing the command

• For details about the status of services when commands are executed, see Status of services when commands are executed in Chapter 12. Commands.

• Each time an area in the Item storage database is expanded, required memory size becomes larger. For details about the required memory size, see the release notes.

• One expansion of the Item storage database by executing the jssitemstoredbexpand.bat command requires 64 GB of available space in the folder that stores the Item storage database to be expanded, which is specified in the configuration file for expanding an Item storage database. For details about the configuration file for expanding an Item storage database, see Configuration file for expanding an Item storage database (jssitemstoredbexpandinfo.bat) in Chapter 13. Definition Files.

• Before you execute the jssitemstoredbexpand.bat command, set up the Item storage database. For details about how to set up the Item storage database, see 11.2.10 Setting up the Item storage database.

• For details about commands that cannot be executed at the same time with the jssitemstoredbexpand.bat command, see Commands that cannot be executed at the same time.

To Page Top

Remarks

• Before executing the jssitemstoredbexpand.bat command, back up the data in the Item management database and Item storage database for failure recovery for when execution of the jssitemstoredbexpand.bat command fails. For details about the backup, see 11.2.14 Backup procedure when the Item storage database is used.

• Do not use Ctrl+C to cancel the jssitemstoredbexpand.bat command during execution. If you happen to do so, recover the environment in the same way as when the return value is 2.

• Do not specify a UNC path for the -i option. If you happen to do so, the command might terminate abnormally due to a communication error or some other reason.

• When the Item storage database is recovered, the recovered environment must be the same environment as when the backup file was created. Therefore, in an environment in which the Item management database or Item storage database is set up again, you need to expand the Item storage database again so that the same environment is set up. For details about recovery of the Item storage database, see 11.2.15 Recovery procedure when the Item storage database is used.

• The execution result of the jssitemstoredbexpand.bat command is output to the log file open to users. For details, see the description about the JP1/Service Support logs and folders that are open to users in A.2 List of log files output by JP1/Service Support.

• Make sure that the input file you specify is created with a character encoding that is compatible with the system locale of the machine on which JP1/Service Support is installed. The character encodings that can be used are as follows:

  • In a Japanese environment: UTF-8

  • In an English environment: UTF-8

  • In a Chinese environment: UTF-8

To Page Top

Examples

Example 1

When you use the configuration file for expanding an Item storage database (c:\setup\jssitemstoredbexpandinfo.bat) to expand the Item storage database area:

jssitemstoredbexpand.bat -i c:\setup\jssitemstoredbexpandinfo.bat

Example 2

When you use the configuration file for expanding an Item storage database (c:\setup\jssitemstoredbexpandinfo.bat) to expand the Item storage database on the primary server in a cluster environment:

jssitemstoredbexpand.bat -i c:\setup\jssitemstoredbexpandinfo.bat -c online

Example 3

When you expand the Item storage database on the secondary server in a cluster environment:

jssitemstoredbexpand.bat -c standby

To Page Top