ajsembdbreclaim
- Organization of this page
Format
ajsembdbreclaim -m {manager| scheduler [-F scheduler-service-name]| agent} [-mh logical-host-name] [-t {d|f}] [-r {1|2}]
Format 1 (for maintaining the scheduler service under the manager and agent management)
ajsembdbreclaim -m manager [-mh logical-host-name] -t f -r 2
Format 2 (for maintaining the index area for the scheduler service under the manager and agent management)
ajsembdbreclaim -m manager [-mh logical-host-name] -t d -r 2
Format 3 (for maintaining the pages for the scheduler service under the manager and agent management)
ajsembdbreclaim -m manager [-mh logical-host-name] -t f -r 1
Format 4 (for maintaining only the pages in the index area for the scheduler service under the manager and agent management)
ajsembdbreclaim -m manager [-mh logical-host-name] -t d -r 1
Format 5 (for maintaining the specified scheduler service)
ajsembdbreclaim -m scheduler [-F scheduler-service-name] [-mh logical-host-name] -t f -r 2
Format 6 (for maintaining the index area for the specified scheduler service)
ajsembdbreclaim -m scheduler [-F scheduler-service-name] [-mh logical-host-name] -t d -r 2
Format 7 (for maintaining the pages for the specified scheduler service)
ajsembdbreclaim -m scheduler [-F scheduler-service-name] [-mh logical-host-name] -t f -r 1
Format 8 (for maintaining only the pages in the index area for the specified scheduler service)
ajsembdbreclaim -m scheduler [-F scheduler-service-name] [-mh logical-host-name] -t d -r 1
Format 9 (for maintaining agent management)
ajsembdbreclaim -m agent [-mh logical-host-name] -t f -r 2
Format 10 (for maintaining the index area used for agent management)
ajsembdbreclaim -m agent [-mh logical-host-name] -t d -r 2
Format 11 (for maintaining the pages used for agent management)
ajsembdbreclaim -m agent [-mh logical-host-name] -t f -r 1
Format 12 (for maintaining only the pages in the index area used for agent management)
ajsembdbreclaim -m agent [-mh logical-host-name] -t d -r 1
Description
Maintains the areas in the embedded database used by JP1/AJS3.
You can execute this command only when the embedded database is running. 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
-m {manager | scheduler | agent}
Specify the range of maintenance.
-
manager
Specify this option to maintain all scheduler services and the agent management in JP1/AJS3 - Manager.
You can specify this option together with the -mh option.
-
scheduler
Specify this option to maintain the areas for the specified scheduler service.
You can specify this option together with the -mh and -F options.
-
agent
Specify this option to maintain agent management.
You can specify this option together with the -mh options.
-F scheduler-service-name
Specify the name of the scheduler service for which you want to maintain the areas.
If you omit this option, the system assumes the default scheduler service name.
-mh logical-host-name
Specify the target JP1 logical host name.
You can specify a character string of 1 to 32 bytes.
If you omit this option and environment variable JP1_HOSTNAME has been set, the system assumes the value set for JP1_HOSTNAME. If environment variable JP1_HOSTNAME has not been set, the system assumes the physical host name.
-t d | f
Specify the maintenance mode.
-
d
Specify this option to maintain the area where indexes are stored.
-
f
Specify this option to maintain the areas where indexes and data are stored.
If you omit this option, the system assumes f.
Depending on the type of operation, the data storage area might become full before the index storage area does. Execute the -db -d option of the ajsembdbstatus command and check the obtained output result. If only a few pages in the data storage area can be released, but many pages in the index storage area can be released, specify the -t d option when you execute the command so that you can maintain the areas efficiently.
-r 1 | 2
Specify the level of maintenance.
-
1
Specify this option to release only pages.
-
2
Specify this option to release pages and segments.
If you omit this option, the system assumes 2.
Execute the -db -d option of the ajsembdbstatus command and check the obtained output result. If many pages can be released, but only a few segments are being used, specify the -r l option when you execute the command so that you can maintain the areas efficiently.
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.
-
If either of the following conditions is met, a timeout error might occur for the ajsembdbreclaim command:
-
When the job execution load of a job or jobnet is high
-
When a unit is operated by using a command or in JP1/AJS3 - View
-
When the usage states of scheduler services or the delay states of jobnets with start conditions are aggregated from the Web GUI (Management Portal)
If a timeout error occurs, re-execute the ajsembdbreclaim command when none of the preceding cases applies.
-
-
If a failure such as a communication or disk failure occurs during execution of this command, the command might not respond. If the non-responding command cannot be killed manually (for example, when a job is automatically executed from another job), you can specify the embedded database system common definition pd_utl_exec_time to kill the command. For details about pd_utl_exec_time, see the system common definition in the 23.1.1 Examining the embedded-database operating environment and operating method in the JP1/Automatic Job Management System 3 Configuration Guide.
-
If multiple ajsembdbreclaim commands are executed concurrently for a single embedded database, one of the commands might abnormally terminate and the message KFPA11770-I will be displayed. In this case, no action is needed if any one of the commands is executed successfully. Note that if multiple ajsembdbreclaim 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.
-
If you execute the ajsembdbreclaim command in a state in which large quantities of unavailable areas occur in the database because maintenance has not been performed for a long time, a lot of data is sent to the system log. An embedded database terminates abnormally if the system log capacity is insufficient. Therefore, estimate the required system log capacity and, if the log capacity is insufficient, add a system log and then execute the ajsembdbreclaim command. For details about how to check the unavailable area and the system log capacity required for execution of the ajsembdbreclaim command, see 9.1.1 Analyzing the database area in the JP1/Automatic Job Management System 3 Administration Guide.
-
When -m manager is specified for the ajsembdbreclaim command and the command is executed, even if the KAVS2117-E message is output, maintenance processing other than the maintenance processing of the scheduler service that detects an abnormality will continue. For the maintenance processing of the scheduler service that detected the abnormality, remove the cause of the problem, and then execute the ajsembdbreclaim command again if necessary.
-
Do not execute the ajsembdbreclaim command at the same time with maintenance performed by the automatic maintenance function.
Return values
0 |
Normal end |
Values other than 0 |
Abnormal end |
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. If the ajsembdbreclaim command times out because a high-load job or jobnet is running, re-execute the job when the system load is low. If the ajsembdbreclaim command times out because of unit operations by commands or in JP1/AJS3 - View, re-execute the command after those unit operations have finished. |
KAVS2123-E |
The version of the embedded database is invalid. |
Update the embedded database to a version supported by JP1/AJS3. |