3.20.2 Using commands to work with the Item storage database

The following figure shows an overview of using commands to work with the Item storage database.

Figure 3‒50: Overview of command-driven operation of Item storage database

The following table lists and describes the commands you can use to work with the Item storage database in JP1/Service Support.

Table 3‒62: Commands for operating the Item storage database
Type	Command	Description
Setup	`jssitemstoredbsetup.bat`	Sets up the Item storage database for a cluster environment.
Outputting and deleting Item information	`jssitemlist`	Outputs a list of Items registered in JP1/Service Support.
	`jssitemhistory`	Outputs the editing history of Items registered in JP1/Service Support.
	`jssitemexportEx`	Outputs Item information for Items registered in JP1/Service Support.
	`jssstoreitemdel.bat`	Deletes Items stored in the Item storage database at the storage area level.
Maintaining the Item storage database	`jssdbinit.bat`^#	Initializes the Item management database and the Item storage database.
	`jssdbbackup.bat`^#	Backs up the Item management database and the Item storage database.
	`jssdbrecovery.bat`^#	Recovers the Item management database and Item storage database from a backup.
	`jsshadbinit.bat`^#	Initializes the Item management database and Item storage database on a shared disk in a cluster environment.
	`jssitemstore`	Transfers Items registered in the Item management database to the Item storage database. Having stored the Items in the Item storage database, the command deletes those Items from the Item management database.
	`jssitemstoredbrotate`	Rotates the active storage area of the Item storage database.
	`jssitemstoredbexpand.bat`	Increases the size of the Item storage database.
	`jssitemcount`	Displays the number of Items registered in the Item management database and the Item storage database.
	`jssdbstatchk.bat`	Displays the status of the Item management database and the Item storage database.

#: This command must be executed from JP1_SS Command Prompt, which is provided by JP1/Service Support.

For details about the above commands, see Chapter 12. Commands. Note that the above commands include commands that require some JP1/Service Support services to be stopped before execution. For details, see Status of services when commands are executed in Chapter 12. Commands.

To Page Top