ajsembdbstatus
- Organization of this page
Format
ajsembdbstatus
{-s [ust|prc|usta] |
-db [-d] |
-l |
-c}
[-id embedded-database-setup-ID]Format 1 (for monitoring the operating status of the embedded database 1)
ajsembdbstatus
-s ust
[-id embedded-database-setup-ID]Format 2 (for monitoring the operating status of the embedded database 2)
ajsembdbstatus
-s usta
[-id embedded-database-setup-ID]Format 3 (for monitoring the status of the processes of the embedded database)
ajsembdbstatus
-s prc
[-id embedded-database-setup-ID]Format 4 (for monitoring the database areas in the embedded database)
ajsembdbstatus
-db
[-d]
[-id embedded-database-setup-ID]Format 5 (for monitoring the system log of the embedded database)
ajsembdbstatus
-l
[-id embedded-database-setup-ID]Format 6 (for outputting embedded database configuration information)
ajsembdbstatus
-c
[-id embedded-database-setup-ID]Description
Monitors the embedded database. You can monitor the following items:
-
Operating status of the embedded database
-
Status of the processes of the embedded database
-
Database areas in the embedded database
-
System log of the embedded database
To monitor the database areas in the embedded database (by specifying the -db option) or the status of the processes of the embedded database (by specifying the -s prc option), execute the command while the embedded database is running. In other cases, you can execute the command regardless of the operating status of the embedded database.
You can execute the command regardless of the operating status of JP1/AJS3.
Execution privileges
In Windows: Administrators privileges
In UNIX: Superuser privileges
Storage directory
- In Windows:
-
JP1/AJS3 - Manager-installation-folder\tools\
- In UNIX:
-
/opt/jp1ajs2/tools/
Arguments
-s {ust|prc|usta}
Specify this option to monitor the status of the embedded database.
-
ust
Specify this option to display the operating status of the embedded database, including the start and stop status of the embedded database.
-
prc
Specify this option to display the status of the processes of the embedded database.
Use this option to check whether a command that manipulates the embedded database is accessing the embedded database. You can also use the option to acquire the name of the server or the program that you need when you want to cancel the command that is accessing the embedded database. You can then use the ajsembdbcancel command to cancel the command.
-
usta
Specify this option to display the embedded database start status related to system area restoration in addition to the information displayed by the ust option.
-db
Specify this option to monitor the database areas in the embedded database.
Use this option to check the time of maintenance or the status of the database areas.
-d
Specify this option to display detailed information about the database.
When you specify this option, you can check the number of pages that can be released by using the ajsembdbreclaim command.
-l
Specify this option to monitor the system log of the embedded database.
Use this option to check the status of the system log file when you back up or restore the embedded database.
-c
Outputs the configuration information for the embedded database.
This option is used during setup for cluster use, to check the embedded database data area directory when the embedded database is backed up or restored and to check if the settings of the primary node and the secondary node are correct. Note, however, that this option is valid only if the command is executed for a embedded database built in JP1/AJS3 version 10-00 or later. If it is executed for the embedded database built in version 09-50 or earlier, the KAVS2129-I message appears and the command ends abnormally.
-id embedded-database-setup-ID
Specify the setup identifier that identifies the embedded database in the _JFn format (n: 0-9 or A-Z). The value specified in this argument must be the same as the value specified in the -id option of the ajsembdbbuild command.
If you want to operate an embedded database created by using the jajs_setup, jajs_setup_cluster, and jajs_migrate commands, use the ajsembdbidlist command to check the setup identifier of the embedded database. For details on the ajsembdbidlist command, see ajsembdbidlist in 2. Commands Used during Setup.
If you omit this option, the system assumes _JF0.
Notes
-
This command is implemented by a script. If you specify an excessively long character string or an invalid character string or value for an option, an unexpected error might occur. You must use the number of characters allowed for a character string or a value in the option as specified in the DBMS and JP1/AJS3 specifications.
-
When you execute the ajsembdbstatus command with the -db option or the -l option specified while JP1/AJS3 is running, the output information might not be the latest information. To acquire the latest information when you execute the command, you need to execute the command while no operation (such as the definition and execution of a job) is being performed for a unit.
-
Note that if multiple ajsembdbstatus commands are executed concurrently for a single embedded database, a conflict might occur during log output processing, and the following message might be output between lines in the output result:
The process cannot access the file. The file is being used by another process.
You can ignore this message because there are no problems with the output results.
Return values
|
0 |
Normal end |
|
1 |
The embedded database is being started or stopped |
|
2 |
The embedded database is being stopped |
|
4, 8, 12 |
Abnormal end |
|
16 |
|
Actions to be taken if an error occurs
If a command error occurs, take the indicated action in the following table.
|
Message |
Cause |
Action to be taken |
|---|---|---|
|
KAVS0996-E |
The specified option contains an error. |
Check the specification of the option. |
|
KAVS2101-E |
The embedded database is inactive. |
Start the embedded database and then re-execute the command. |
|
KAVS2102-E |
The embedded database is being started or stopped. |
Use the -s ust option of the ajsembdbstatus command to check whether the embedded database is running and then re-execute the command. |
|
KAVS2104-E |
The embedded database is not set up. |
Set up the embedded database and then re-execute the command. |
|
KAVS2116-E |
The specified option contains an error. |
Check the option output in the message and then re-execute the command. |
|
KAVS2117-E |
An error occurred during execution of the command. |
Check the message output in the maintenance information. |
Output example
Checking the operating status of the embedded database
ajsembdbstatus -s usta -id _JF0 HOSTNAME : 127.0.0.1(144852) SYSTEMID : ajs2 UNITID : unt1 ENTRYHOST : 127.0.0.1 PAIRHOST : UNIT-STAT FES-STAT SETUP-STAT ONLINE ******** SETUP START-OPT : NORMAL
- HOSTNAME
-
127.0.0.1 is displayed.
The item in parentheses is the hour, minutes, and seconds (format: HHMMSS) of the time when the ajsembdbstatus command is executed.
- Cautionary note
-
If any of the conditions below is met, the host name of the embedded database installation directory is output by using no more than 32 characters. In a cluster configuration, the first host name that is set as the active server is output.
-
When JP1/AJS3 - Manager for Windows version 09-50 or earlier is used and the embedded database has been built on a logical host
-
When JP1/AJS3 - Manager for UNIX version 09-50 or earlier is used
-
When JP1/AJS3 - Manager version 09-50 or earlier is updated to version 10-00 or later, and IPv6 has not been set up
-
- SYSTEMID
-
Indicates the identifier of the embedded database with up to four characters. For JP1/AJS3, this identifier is fixed to ajs2.
- UNITID
-
Indicates the system-specific identifier with up to four characters. For JP1/AJS3, this identifier is fixed to unt1.
- ENTRYHOST
-
127.0.0.1 is displayed.
- Cautionary note
-
If any of the following conditions is met, the name of the host on which the ajsembdbstatus command is executed is output:
-
When JP1/AJS3 - Manager for Windows version 09-50 or earlier is used and the embedded database has been built on a logical host
-
When JP1/AJS3 - Manager for UNIX version 09-50 or earlier is used
-
When JP1/AJS3 - Manager version 09-50 or earlier is updated to version 10-00 or later, and IPv6 has not been set up
-
- PAIRHOST
-
Always blank.
- UNIT-STAT
-
Indicates the system status.
PAUSE: The restart of the embedded database is suspended.#
STOP: The embedded database is stopped.
STARTING: The embedded database is being started.
ONLINE: The embedded database is running.
STOPPING: The embedded database is being stopped.
- #
-
The embedded database has terminated abnormally and cannot be restored by its automatic restart function.
- FES-STAT
-
Always ********.
- SETUP-STAT
-
Indicates the setup status.
- SETUP:
-
In Windows, this indicates that execution of the ajsembdbbuild command has been completed and the embedded database service is running. In UNIX, this indicates that execution of the ajsembdbbuild command has been completed.
- UNSETUP:
-
In Windows, this indicates that the embedded database service is not running. In UNIX, this indicates that execution of the ajsembdbunset command with the -r option specified has been completed.
- START-OPT(output only if the -s usta option was specified)
-
Indicates the start status of the embedded database.
NORMAL: The embedded database is starting normally.
RECOVERY: The embedded database is starting for system area recovery (the ajsembdbstart command with the -r option specified).
********: The embedded database is not starting.
Checking the status of the processes of the embedded database
ajsembdbstatus -s prc -id _JF0 HOSTNAME : 127.0.0.1(110440) STATUS PID UID GID SVID TIME PROGRAM C-PID C-GRP L 856 0 0 ajs2 102826 ajsschd 3568(XXX.YYY...) L 1868 0 0 ajs2 102832 ajsflowd 3604(XXX.YYY...) L 2080 0 0 ajs2 102835 ajssubd 3792(XXX.YYY...) L 2116 0 0 ajs2 999999 L 2136 0 0 ajs2 999999 :
- HOSTNAME
-
127.0.0.1 is displayed.
The item in parentheses is the hour, minutes, and seconds (format: HHMMSS) of the time when the ajsembdbstatus command is executed.
- Cautionary note
-
If any of the conditions below is met, the host name of the embedded database installation directory is output by using no more than 32 characters. In a cluster configuration, the first host name that is set as the active server is output.
-
When JP1/AJS3 - Manager for Windows version 09-50 or earlier is used and the embedded database has been built on a logical host
-
When JP1/AJS3 - Manager for UNIX version 09-50 or earlier is used
-
When JP1/AJS3 - Manager version 09-50 or earlier is updated to version 10-00 or later, and IPv6 has not been set up
-
- STATUS
-
Indicates the status of the process for accessing started by the embedded database.
D: The process is being started or being terminated.
L: The process is running.
- PID
-
Indicates the process ID using a decimal number of 10 digits or less.
- UID
-
Always 0.
- GID
-
Always 0.
- SVID
-
Indicates the name of the server for the process. For the processes used by JP1/AJS3, this name is ajs2. When an embedded database operation command is executed, the information that is specified in the -u option of the ajsembdbcancel command might be output.
- TIME
-
Indicates the time when the embedded database is connected in the HHMMSS (hour, minutes, seconds) format.
- PROGRAM
-
Indicates the name of a command or a daemon of JP1/AJS3 with up to 30 characters.
When an embedded database operation command is executed, the name of a command, other than the executed command, might be output. The information you specify in the -u option in the ajsembdbcancel command is output here.
- C-PID
-
Indicates the process ID of the JP1/AJS3 daemon process or command process connected to the embedded database by using a decimal number of 10 digits or less. The item in parentheses is the IP address up to 15 characters.
This item is not output for the process that is not connected.
- C-GRP
-
Always blank.
Checking the status of the database areas in the embedded database
ajsembdbstatus -db -id _JF0
1684 hh:mm:ss unt1 _pd0dbst KFPK10300-I Pddbst started
1684 hh:mm:ss unt1 _pd0dbst KFPK10301-I Pddbst terminated, return code=0
pddbst 08-05(Object Option) ** RD Area Logical Analysis ** YYYY/MM/DD hh:mm:ss
RD Area Name : AJS2DATA
Server : ajs2
Total Segment : 301 Segment Size : 10 Pages
Unused Segment: 297 Page Size : 30720 Bytes
History1 Hold Status : Hold Code : 0 Hold Time :
History2 Hold Status : Hold Code : 0 Hold Time :
--------------------------------------------------------------
Table Name : AJS1ARROW
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
(1)Used(Full) (2)Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Table Name : AJS1BODY
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Table Name : AJS1CAL
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Table Name : AJS1ENTRY
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Table Name : AJS1GEN
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Table Name : AJS1ID
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Table Name : AJS1PERF
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Table Name : AJS1RELS
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Table Name : AJS1SCH
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Table Name : AJS1STAT
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 48 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Table Name : AJS1UNIT
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Table Name : AJSAGTEXECCNT
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 3 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Table Name : AJSEXECAGT
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 3 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Table Name : AJSEXECAGTGRP
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 3 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Table Name : AJSLINKAGT
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 3 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
3649 hh:mm:ss unt1 _pd0dbst KFPK10300-I Pddbst started
3649 hh:mm:ss unt1 _pd0dbst KFPK10301-I Pddbst terminated, return code=0
pddbst 08-05(Object Option) ** RD Area Logical Analysis ** YYYY/MM/DD hh:mm:ss
RD Area Name : AJS2DATA2
Server : ajs2
Total Segment : 100 Segment Size : 100 Pages
Unused Segment: 100 Page Size : 30720 Bytes
History1 Hold Status : Hold Code : 0 Hold Time :
History2 Hold Status : Hold Code : 0 Hold Time :
------------------------------------------------------------------
Table Name : AJS1JINF
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 70 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
<BINARY segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
3952 hh:mm:ss unt1 _pd0dbst KFPK10300-I Pddbst started
3952 hh:mm:ss unt1 _pd0dbst KFPK10301-I Pddbst terminated, return code=0
pddbst 08-05(Object Option) ** RD Area Logical Analysis ** YYYY/MM/DD hh:mm:ss
RD Area Name : AJS2INDX
Server : ajs2
Total Segment : 904 Segment Size : 10 Pages
Unused Segment: 885 Page Size : 4096 Bytes
History1 Hold Status : Hold Code : 0 Hold Time :
History2 Hold Status : Hold Code : 0 Hold Time :
--------------------------------------------------------------
Index Name : AJS1ARROWINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJS1BODYINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJS1CALINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJS1ENTRYINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJS1GENINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJS1IDINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJS1PERFINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJS1PERFINDEX2
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJS1RELSINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJS1RELSINDEX2
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJS1RELSINDEX3
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJS1SCHINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJS1STATINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJS1UNITINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJS1UNITINDEX2
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJSAGTEXECCNTINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJSEXECAGTGRPINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJSEXECAGTINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJSLINKAGTINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
3667 hh:mm:ss unt1 _pd0dbst KFPK10300-I Pddbst started
3667 hh:mm:ss unt1 _pd0dbst KFPK10301-I Pddbst terminated, return code=0
pddbst 08-05(Object Option) ** RD Area Logical Analysis ** YYYY/MM/DD hh:mm:ss
RD Area Name : AJS2INDX2
Server : ajs2
Total Segment : 3000 Segment Size : 10 Pages
Unused Segment: 2998 Page Size : 4096 Bytes
History1 Hold Status : Hold Code : 0 Hold Time :
History2 Hold Status : Hold Code : 0 Hold Time :
------------------------------------------------------------------
Index Name : AJS1JINFINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Index Name : AJS1JINFINDEX2
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0- RD Area Name
-
Indicates the name of the area used by JP1/AJS3.
AJS2DATA, AJS2DATA2#: Table area
AJS2INDX, AJS2INDX2#: Index area
- #:
-
AJS2DATA2 and AJS2INDX2 information is output only if the backup enhancement function is enabled.
- Server
-
Always ajs2.
- Total Segment
-
Indicates the total number of segments in the indicated area.
- Unused Segment
-
Indicates the total number of unused segments in the indicated area.
- Segment Size
-
Indicates the number of pages in one segment.
- Page Size
-
Indicates the size of one page in bytes.
- History1 Hold Status Code, Hold Code, Hold Time
-
Information used by the system.
- History2 Hold Status Code, Hold Code, Hold Time
-
Information used by the system.
- Table Name
-
Indicates the name of the table used by JP1/AJS3.
- Index Name
-
Indicates the name of the index used by JP1/AJS3.
- Auth Id
-
Indicates the authorization identifier for the table or the index. For JP1/AJS3, this is usually root.
- Segment Reuse
-
The value specified for the reuse start point (the number of segments) for the free-space reuse function is output. If the free-space reuse function is disabled, a hyphen (-) is output.
- Collect On Segment
-
The output value is the number of segments in the state in which release processing is incomplete because the ajsembdbreclaim command is being executed or because the ajsembdbreclaim command did not end normally.
- Status, Reference Pending Status, Check Pending Status, Search Mode, Reuse Search Failure
-
Information used by the system.
- (1)Used(Full)
-
Indicates the percentage of the segments or pages being used. The number in parentheses indicates the percentage of full segments or pages in all the segments or pages being used.
- (2)Used( Full)
-
Indicates the number of segments or pages being used. The number in parentheses indicates the number of full segments or pages in all the segments or pages being used.
- Sum
-
Indicates the total number of segments or pages allocated to the table or the index.
Checking the details about the database areas in the embedded database
ajsembdbstatus -db -d -id _JF0
3240 hh:mm:ss unt1 _pd0dbst KFPK10300-I Pddbst started
3240 hh:mm:ss unt1 _pd0dbst KFPK10301-I Pddbst terminated, return code=0
pddbst 08-05(Object Option) ** RD Area Logical Analysis ** YYYY/MM/DD hh:mm:ss
RD Area Name : AJS2DATA
Server : ajs2
Total Segment 301 Segment Size : 10 Pages
Unused Segment: 297 Page Size : 30720 Bytes
History1 Hold Status : Hold Code : 0 Hold Time :
History2 Hold Status : Hold Code : 0 Hold Time :
--------------------------------------------------------------
Table Name : AJS1ARROW
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Collect Prearranged Page : 0
Used Page Ratio Page(Ratio)
0% : 0( 0%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 0
Table Name : AJS1BODY
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Collect Prearranged Page : 0
Used Page Ratio Page(Ratio)
0% : 0( 0%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 0
Table Name : AJS1CAL
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Collect Prearranged Page : 0
Used Page Ratio Page(Ratio)
0% : 0( 0%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 0
Table Name : AJS1ENTRY
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Collect Prearranged Page : 0
Used Page Ratio Page(Ratio)
0% : 0( 0%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 0
Table Name : AJS1GEN
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Collect Prearranged Page : 0
Used Page Ratio Page(Ratio)
0% : 0( 0%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 0
Table Name : AJS1ID
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 0
Used Page Ratio Page(Ratio)
0% : 9( 90%)
1- 10% : 1( 10%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Table Name : AJS1PERF
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Collect Prearranged Page : 0
Used Page Ratio Page(Ratio)
0% : 0( 0%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 0
Table Name : AJS1RELS
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Collect Prearranged Page : 0
Used Page Ratio Page(Ratio)
0% : 0( 0%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 0
Table Name : AJS1SCH
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Collect Prearranged Page : 0
Used Page Ratio Page(Ratio)
0% : 0( 0%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 0
Table Name : AJS1STAT
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 48 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Collect Prearranged Page : 0
Used Page Ratio Page(Ratio)
0% : 0( 0%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 0
Table Name : AJS1UNIT
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 18 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 0
Used Page Ratio Page(Ratio)
0% : 9( 90%)
1- 10% : 1( 10%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Table Name : AJSAGTEXECCNT
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 3 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 0
Used Page Ratio Page(Ratio)
0% : 9( 90%)
1- 10% : 1( 10%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Table Name : AJSEXECAGT
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 3 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 0
Used Page Ratio Page(Ratio)
0% : 9( 90%)
1- 10% : 1( 10%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Table Name : AJSEXECAGTGRP
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 3 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Collect Prearranged Page : 0
Used Page Ratio Page(Ratio)
0% : 0( 0%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 0
Table Name : AJSLINKAGT
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 3 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Collect Prearranged Page : 0
Used Page Ratio Page(Ratio)
0% : 0( 0%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 0
3711 hh:mm:ss unt1 _pd0dbst KFPK10300-I Pddbst started
3711 hh:mm:ss unt1 _pd0dbst KFPK10301-I Pddbst terminated, return code=0
pddbst 08-05(Object Option) ** RD Area Logical Analysis ** YYYY/MM/DD hh:mm:ss
RD Area Name : AJS2DATA2
Server : ajs2
Total Segment : 100 Segment Size : 100 Pages
Unused Segment: 100 Page Size : 30720 Bytes
History1 Hold Status : Hold Code : 0 Hold Time :
History2 Hold Status : Hold Code : 0 Hold Time :
------------------------------------------------------------------
Table Name : AJS1JINF
Auth Id : root
Status :
Reference Pending Status :
Check Pending Status :
Segment Reuse : 70 segments
<Base row segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Collect Prearranged Page : 0
Used Page Ratio Page(Ratio)
0% : 0( 0%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 0
<BINARY segment>
Search Mode : INS
Reuse Search Failure : 0/ 0
Used(Full) Used( Full) Sum
Segment 0%( 0%) 0( 0) 0
Page 0%( 0%) 0( 0) 0
Collect On Segment : 0
Collect Prearranged Page : 0
Used Page Ratio Page(Ratio)
0% : 0( 0%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 0
4872 hh:mm:ss unt1 _pd0dbst KFPK10300-I Pddbst started
4872 hh:mm:ss unt1 _pd0dbst KFPK10301-I Pddbst terminated, return code=0
pddbst 08-05(Object Option) ** RD Area Logical Analysis ** YYYY/MM/DD hh:mm:ss
RD Area Name : AJS2INDX
Server : ajs2
Total Segment : 904 Segment Size : 10 Pages
Unused Segment: 885 Page Size : 4096 Bytes
History1 Hold Status : Hold Code : 0 Hold Time :
History2 Hold Status : Hold Code : 0 Hold Time :
--------------------------------------------------------------
Index Name : AJS1ARROWINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 1
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 10( 100%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJS1BODYINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 1
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 10( 100%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJS1CALINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 1
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 10( 100%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJS1ENTRYINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 1
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 10( 100%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJS1GENINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 1
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 10( 100%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJS1IDINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 0
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 9( 90%)
1- 10% : 1( 10%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJS1PERFINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 1
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 10( 100%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJS1PERFINDEX2
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 1
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 10( 100%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJS1RELSINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 1
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 10( 100%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJS1RELSINDEX2
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 1
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 10( 100%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJS1RELSINDEX3
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 1
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 10( 100%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJS1SCHINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 1
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 10( 100%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJS1STATINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 1
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 10( 100%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJS1UNITINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 0
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 9( 90%)
1- 10% : 1( 10%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJS1UNITINDEX2
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 0
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 9( 90%)
1- 10% : 1( 10%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJSAGTEXECCNTINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 0
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 9( 90%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 1( 10%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJSEXECAGTGRPINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 1
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 10( 100%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJSEXECAGTINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 0
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 9( 90%)
1- 10% : 1( 10%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJSLINKAGTINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 1
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 10( 100%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
3729 hh:mm:ss unt1 _pd0dbst KFPK10300-I Pddbst started
3729 hh:mm:ss unt1 _pd0dbst KFPK10301-I Pddbst terminated, return code=0
pddbst 08-05(Object Option) ** RD Area Logical Analysis ** YYYY/MM/DD hh:mm:ss
RD Area Name : AJS2INDX2
Server : ajs2
Total Segment : 3000 Segment Size : 10 Pages
Unused Segment: 2998 Page Size : 4096 Bytes
History1 Hold Status : Hold Code : 0 Hold Time :
History2 Hold Status : Hold Code : 0 Hold Time :
------------------------------------------------------------------
Index Name : AJS1JINFINDEX1
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 1
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 10( 100%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10
Index Name : AJS1JINFINDEX2
Auth Id : root
Status :
Used(Full) Used( Full) Sum
Segment 100%( 0%) 1( 0) 1
Page 10%( 0%) 1( 0) 10
Collect On Segment : 0
Collect Prearranged Page : 1
Collect On Page : 0
Used Page Ratio Page(Ratio)
0% : 10( 100%)
1- 10% : 0( 0%)
11- 20% : 0( 0%)
21- 30% : 0( 0%)
31- 40% : 0( 0%)
41- 50% : 0( 0%)
51- 60% : 0( 0%)
61- 70% : 0( 0%)
71- 80% : 0( 0%)
81- 90% : 0( 0%)
91-100% : 0( 0%)
Total 10- Collect Prearranged Page
-
Indicates the size in pages of the area that can be released by using the ajsembdbreclaim command.
Check this value to determine when to execute the ajsembdbreclaim command.
If this value is 0, no area is released even if you execute the ajsembdbreclaim command. We recommend that you execute the ajsembdbreclaim command when this value reaches 30 to 50% of the pages being used. However, this command is not very effective if the number of pages being used is 50 pages or less. If the number of pages being used exceeds 10,000, we recommend that you execute the ajsembdbreclaim command when this value reaches 20 to 30% of the pages being used.
- Collect On Page
-
The output value is the number of pages in the state in which release processing is incomplete because the ajsembdbreclaim command is being executed or because the ajsembdbreclaim command did not end normally.
- Used Page Ratio, Page(Ratio)
-
Indicates the detailed information about the pages allocated to the table or the index.
When more pages are at higher percentages, storage efficiency is better. When only a few pages are at higher percentages, storage efficiency is worse.
Because the percentages in parentheses are rounded up at the decimal point, the total might add up to more than 100%.
Checking the system log of the embedded database
ajsembdbstatus -l -id _JF0 HOSTNAME : 127.0.0.1(201942) Group Type Server Gen No. Status Run ID Block No. Ex-Status log1 sys ajs2 1 oc-d--u 433a0c53 1 ae -x------ log2 sys ajs2 0 os----- 00000000 0 0 -u------ log3 sys ajs2 0 os----- 00000000 0 0 -u------ log4 sys ajs2 0 os----- 00000000 0 0 -u------ log5 sys ajs2 0 os----- 00000000 0 0 -u------ log6 sys ajs2 0 os----- 00000000 0 0 -u------ log7 sys ajs2 0 os----- 00000000 0 0 -u------ log8 sys ajs2 0 os----- 00000000 0 0 -u------ log9 sys ajs2 0 os----- 00000000 0 0 -u------ log10 sys ajs2 0 os----- 00000000 0 0 -u------ log11 sys ajs2 0 os----- 00000000 0 0 -u------ log12 sys ajs2 0 os----- 00000000 0 0 -u------
- HOSTNAME
-
127.0.0.1 is displayed.
The item in parentheses is the hour, minutes, and seconds (format: HHMMSS) of the time when the ajsembdbstatus command is executed.
- Cautionary note
-
If any of the conditions below is met, the host name of the embedded database installation directory is output by using no more than 32 characters. In a cluster configuration, the first host name that is set as the active server is output.
-
When JP1/AJS3 - Manager for Windows version 09-50 or earlier is used and the embedded database has been built on a logical host
-
When JP1/AJS3 - Manager for UNIX version 09-50 or earlier is used
-
When JP1/AJS3 - Manager version 09-50 or earlier is updated to version 10-00 or later, and IPv6 has not been set up
-
- Group
-
Indicates the name of the system log file group for the embedded database with up to eight characters.
- Type
-
Always sys.
- Server
-
Always ajs2.
- Gen No.
-
Indicates the generation number of the system log with a hexadecimal number of eight digits or less. This number indicates the sequence of the system logs used by the embedded database and starts at 1. After the last system log file group has been used, the first system log file group is used again. At this time, the generation number of the system log is updated.
- Status
-
Indicates the status of the system log file group with seven characters:
- First character:
-
Open status of the system log file group
o: Open
c: Closed
This character is o when the embedded database is running. The character is c when the embedded database is not running.
- Second character:
-
Current status of the system log file group
c: Active
s: Standby
n: Reserved
During operation, the system log file group currently used is indicated as c, and other system log file groups are indicated as s.
If no system log file can be accessed because, for example, the embedded database is not running or the disk that contains system log files is not mounted, n is output.
- Third character:
-
Unload status of the system log file group
-
u: The log file group is waiting to be unloaded.
(The log file group was active, but swapped and is not currently being used.)
No action is necessary if the operation does not use the system log (that is, the ajsembdbbuild command with neither the -bs nor -br option specified was executed during embedded database environment setup).
If the operation uses the system log (that is, the ajsembdbbuild command with the -bs or -br option specified was executed during embedded database environment setup), the system log file group must be unloaded. However, normally, this unloading is automatically performed.
-
-: The log file group is unloaded.
-
- Fourth character:
-
Indicates whether the system log file group can be overwritten.
-
d: The log file group cannot be overwritten (the system log file group contains a log required for restoring the embedded database).
If all the system log files on the server are in this status, the embedded database stops. In that case, add a system log file.
This status might occur when an extremely large job is defined in a batch job and the resulting embedded database transaction is extremely long.
-
-: The log file group can be overwritten (the system log file group does not contain a log required for restoring the embedded database).
-
- Fifth character:
-
Internal information used by the system.
- Sixth character:
-
The usage history of the system log file group
-
c: The system log file group that is currently active
Displayed only when the embedded database has stopped.
-
- Seventh character:
-
Internal information used by the system.
- Run ID
-
Indicates information used by the system.
- Block No.
-
Indicates the first block number and the last block number in the system log file with hexadecimal numbers of eight digits or less.
- Ex-Status
-
Indicates the expansion status of the system log file group with eight characters.
- First character:
-
Internal information used by the system.
- Second character:
-
The automatic expansion status of the system log file group.
u: The system log file group is subject to the system log file auto-increment function.
e: System log files are expanded.
x: The system log file group is not subject to the system log file auto-increment function.
-: The system log file auto-increment function is not used.
- Third character:
-
Whether automatic expansion of the system log file group is possible.
-: Possible by using the system log file auto-increment function.
x: Not possible by using the system log file auto-increment function.
- Fourth, Fifth, sixth, seventh, and eighth characters:
-
Indicates information used by the system.
Checking the embedded database configuration information
ajsembdbstatus -c -id _JF1 HOSTNAME=lhost1 INSTALLDIR= "C:\Program Files\HITACHI\JP1AJS2\embdb\_JF1" SETUPID=_JF1 RAWFILE= "ajssys01=\\.\D:,ajssys11=\\.\E:" DATADIR= WORKDIR=" C:\Program Files\HITACHI\JP1AJS2\embdb\_JF1\dbarea" EMBDBPORT=22221 DBMODEL=l PHYSICALHOST=phost SYSLOGCNF=single UNLDDIR="C:\Program Files\HITACHI\JP1AJS2\embdb\_JF1\unload" EXTENDDB=no EXTENDLOG=no ENHANCEDBACKUP=yes
- HOSTNAME
-
The name of the host that was set when the embedded database was built is output.
- INSTALLDIR
-
The installation directory of the embedded database is output.
- SETUPID
-
The embedded database setup identifier is output.
- RAWFILE
-
The data area partition is output when a RAW file is used for the data area and the system area of the embedded database. This information is output for compatibility.
- DATADIR
-
The data area directory of the embedded database is output. When system logging is being used, the system area directory is also output.
- WORKDIR
-
The work area directory is displayed.
- EMBDBPORT
-
The port number of the embedded database is displayed.
- DBMODEL
-
The database model is output:
l: Large scale
m: Medium scale
s: Small scale
- PHYSICALHOST
-
If a cluster configuration environment is used, the name of the primary node physical host is output.
- SYSLOGCNF
-
The system logging setting is displayed:
single: The system file is not duplicated.
dual: The system file is duplicated.
none: System logging is disabled.
- UNLDDIR
-
The directory where the unload log file has been created is output.
This information is not displayed if system logging is not used.
- EXTENDDB
-
The setting of the database area auto-increment function is output:
yes: The function is enabled.
no: The function is disabled.
- EXTENDLOG
-
The setting of the system log auto-increment function is output:
yes: The function is enabled.
no: The function is disabled.
- ENHANCEDBACKUP
-
The setting of the backup enhancement function is output. This item is not displayed if the JP1/AJS3 version when the embedded database is configured is earlier than 12-10.
yes: The function is enabled.
no: The function is disabled.