jssdbstatchk.bat (checks the database status)
- Organization of this page
Description
This command can be used to check the status of the Item management database and Item storage database. Information below is output to the standard output. Note that information about the Item storage database can be checked when the size of the Item management database is XL.
-
Database size of the Item storage area and attached file storage area in the Item management database and Item storage database
-
Usage rate of the Item storage area and attached file storage area in the Item management database and Item storage database
-
Status of the storage area in the Item storage database (active or inactive)
-
Number of expansions of the Item storage area and attached file storage area in the Item storage database
-
Registration date range for the Items stored in the Item management database and Item storage database
-
Path to the directory that stores the Item management database and Item storage database
To run this command, go to the Start menu and click Programs, JP1_Integrated Management - Service Support, and JP1_IM-SS Command Prompt. Then, execute the command.
Format
jssdbstatchk.bat {-state | -dbpath}
Required execution permission
Administrator permissions
Storage folder
IM-SS-path\tools\
Arguments
-state
Checks the status of the Item management database and Item storage database.
-dbpath
Checks the directory for storing the Item management database and Item storage database.
Return values
Return value |
Meaning |
---|---|
0 |
Normal end |
1 |
Abnormal end |
2 |
Command executing |
Status of the database to be output
The status of the database to be output depends on the specified option. The following table lists and describes the output information about the status of the database.
No. |
Output information#1 |
Description |
Specified option |
---|---|---|---|
1 |
Database name (DBtype) |
The target database name is output as the header. Either of the following database names is output:
|
-- |
2 |
Database capacity (dbcapacity) |
The database capacity (GB) of the Item storage area and attached file storage area in the target database is output. If the Item storage database is not set up, N/A is output. |
-state |
3 |
Database usage rate (dbusage) |
The usage rate (%) of the Item storage area and attached file storage area in the target database is output. If the Item storage database is not set up, N/A is output. |
-state |
4 |
Status of the storage area in the Item storage database (active/inactive) |
When the target database is the Item storage database, the status of the storage area is displayed. One of the following statuses is output:
|
-state |
5 |
Number of expansions of the Item storage database (expandtime) |
If the target database is the Item storage database, the number of expansions of the Item storage area and attached file storage area in the storage area is displayed. If the Item storage database is not set up, N/A is displayed. If the Item storage database is set up but not expanded, 0 is displayed. |
-state |
6 |
Registered Items (itemrange) |
The registration date range for the Items registered in the target database is output. For the registration date range, the oldest and latest registered date are output in yyyy/mm/dd-yyyy/mm/dd format. Note that the following Items in the Item management database are not included:
|
-state |
7 |
Directory that stores the database (dbsetupdir, dbsetupdir[local], dbsetupdir[share], dbexpanddir, or dbexpanddir[share]) |
The directory that stores the target database is output. For the Item management database, the directory to which the Item management database is set up is output. For the Item storage database, information about the directory to which the Item storage database is set up and the directory to which the Item storage database is expanded is output. For an environment in a cluster configuration, information about the setup directories for the following Item management databases is output:
In a cluster environment, [share] is added to the header name of the information about the directories into which the Item storage database is set up and expanded. If the database is not set up, N/A is output. In this case, information about the directory to expand the database to is not output. |
-dbpath |
- Legend:
-
--: Not applicable.
- #1
-
Header names of the database information are enclosed by parentheses. The unit is output after some headers. If database information is divided into the Item storage area and the attached file storage area, the following information is output after the header names:
- For the Item storage area: (item)
- For the attached file storage area: (apdfile)
- #2
-
The storage area is enclosed by parentheses.
The following example shows an output result of executing the jssdbstatchk.bat command with the -state option specified:
[DBtype] itemmanageDB dbcapacity(GB)(item) : 67 dbusage(%)(item) : 70.3 dbcapacity(GB)(apdfile): 32 dbusage(%)(apdfile) : 73.3 itemrange : 2015/01/01-2016/02/24 [DBtype] itemstoreDB(A) active/inactive : inactive dbcapacity(GB)(item) : 128 dbusage(%)(item) : 90.2 expandtime(item) : 2 dbcapacity(GB)(apdfile): 64 dbusage(%)(apdfile) : 72.6 expandtime(apdfile) : 1 itemrange : 2001/04/01-2007/12/31 [DBtype] itemstoreDB(B) active/inactive : active dbcapacity(GB)(item) : 128 dbusage(%)(item) : 25.3 expandtime(item) : 2 dbcapacity(GB)(apdfile): 64 dbusage(%)(apdfile) : 10.2 expandtime(apdfile) : 1 itemrange : 2008/01/01-2014/12/31
The following example shows an output result of executing the jssdbstatchk.bat command with the -dbpath option specified:
[DBtype] itemmanageDB dbsetupdir : C:\Program Files (x86)\Hitachi\JP1SS\db [DBtype] itemstoreDB(A) dbsetupdir : D:\Program Files (x86)\Hitachi\JP1SS\itemstoredbA dbexpanddir1(item) : D:\Program Files (x86)\Hitachi\JP1SS\itemstoredbA dbexpanddir2(item) : D:\Program Files (x86)\Hitachi\JP1SS\itemstoredbA dbexpanddir1(apdfile) : D:\Program Files (x86)\Hitachi\JP1SS\itemstoredbA [DBtype] itemstoreDB(B) dbsetupdir : D:\Program Files (x86)\Hitachi\JP1SS\itemstoredbB dbexpanddir1(item) : D:\Program Files (x86)\Hitachi\JP1SS\itemstoredbB dbexpanddir2(item) : D:\Program Files (x86)\Hitachi\JP1SS\itemstoredbB dbexpanddir1(apdfile) : D:\Program Files (x86)\Hitachi\JP1SS\itemstoredbB
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 11. Commands.
-
Two or more jssdbstatchk.bat commands cannot be executed at the same time.
Remarks
-
The database capacity (dbcapacity) which is displayed when the jssdbstatchk.bat command is executed with the -state option is the size of the area that stores Item data or attached file data. The Item management database and Item storage database have areas that store Item data and attached file data, and areas used to manage those areas. Therefore, the value displayed for the database capacity (dbcapacity) is different from the file size used by the Item management database and Item storage database.
-
The database usage rate (dbusage) which is displayed when the jssdbstatchk.bat command is executed with the -state option, indicates a value that includes invalid areas. Therefore, only deleting the Items or attached files does not change the usage rate. To decrease the usage rate, delete data, and then execute the jssdbrorg.bat command to reorganize the invalid areas. For details about the jssdbrorg.bat command, see jssdbrorg.bat (reorganizes the Item management database) in Chapter 11. Commands.
Example
The following example shows how to output the status of the database:
jssdbstatchk.bat -state