3.20.1 Using commands to work with the Item management database

The following figure shows an overview of command-driven updating of the Item management database.

Figure 3‒49: Overview of command-driven updating of the Item management database

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

Table 3‒61: Commands for operating the Item management database
Type	Command	Description
Setup	`jsssetup.bat`^#1	Sets up the Item management database.
	`jssunsetup.bat`^#1	Undoes Item management database setup.
	`jsshasetup.bat`^#1	Sets up the Item management database for a cluster environment.
	`jsshaunsetup.bat`^#1	Undoes Item management database setup for a cluster environment.
	`jsschauthorityserver`	Switches the authentication server used for JP1/Service Support.
	`jssrefaclsetup`	Allows you to set view permission for individual Items.
	`jssauthusersetup`	Sets the user ID and password for authentication (at sending of email and Item registration by email) in the email definition file.
Defining Item forms	`jssformdef`	Registers the Item form settings customized according to users' operational requirements.
Defining Item forms	`jssformcustomizer`	Starts the GUI tool that can be used to edit Item forms.
Adding, editing, deleting, and outputting 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.
	`jssitemedit`	Edits an Item registered in Item management database.
	`jssitementry`	Registers an Item in the Item management database.
	`jssitementrybymail`	Registers an Item in the Item management database via email.
	`jssitemexportEx`	Outputs Item information for Items registered in JP1/Service Support.
	`jssitemimport`	Registers multiple Items in the Item management database.
	`jssitemimportEx`	Registers multiple Items, including the related information and attached files, in the Item management database.
	`jssitemdeletion`	Places multiple Items in the Item management database in Waiting to be deleted status.^#2
	`jssrev`	Releases multiple Items in the Item management database from Waiting to be deleted status.
	`jssdelrec`	Completely deletes the following from the Item management database: Items that are placed in Waiting to be deleted status by using a window or the `jssitemdeletion` command, and the target systems or process work boards that are placed in Waiting to be deleted status by using a window.^#2
Sending alerts by email	`jssinformperiod`	Checks the deadline of an Item, and notifies the person in charge if the deadline is near.
Sending alerts by email	`jssinformleave`	Checks the processing status of an Item, and notifies the person in charge if the Item is assumed to be left unprocessed for a long time.
Accumulating Items	`jsscollectdata`	Registers or updates Item accumulation data in the Item management database.
Adding, editing, deleting, and outputting information about users, role members, and access permissions	`jssuserlist`	Outputs a listing of user information.
	`jssuseredit`	Allows the user to edit user information.
	`jssuserimport`	Registers information about multiple users.
	`jssrolelist`	Outputs a listing of role information.
	`jssmemberlist`	Outputs a list of members who belong to a role.
	`jssmemberdelete`	Removes members from a role.
	`jssmemberimport`	Adds multiple members to a role.
	`jssroleimport`	Adds roles.
	`jssaclexport`	Outputs the information about access permissions and the initial person in charge of status.
	`jssaclimport`	Executes batch registration of the information about access permissions and the initial person in charge of status.
Maintaining the Item management database	`jssdbinit.bat`^#1	Initializes the Item management database and the Item storage database.
	`jssdbrorg.bat`^#1	Reorganizes the Item management database.
	`jssdbreclaim.bat`^#1	Reclaims the free space in the Item management database.
	`jssdbbackup.bat`^#1	Backs up the Item management database and the Item storage database.
	`jssdbrecovery.bat`^#1	Recovers the Item management database and Item storage database from a backup.
	`jsshadbinit.bat`^#1	Initializes the Item management database and Item storage database on a shared disk in a cluster environment.
	`jsscreatesysandpwb`	Creates a master system and temporary receipt process work board.
	`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.
	`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.

#1: This command must be executed from JP1_SS Command Prompt, which is provided by JP1/Service Support.
#2: Deletion of entries in a window means that the information about the entries is hidden or operations on the entries are restricted in the window. The Items deleted by the jssitemdeletion command are only placed in Waiting to be deleted status, and remain in the Item management database. To delete these Items from the database completely, execute the jssdelrec command.

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 these commands, see Status of services when commands are executed in Chapter 12. Commands.

To Page Top