ajsdbcond

Format

ajsdbcond
     [-F service-name]
     [[-m] |
       [[-x][-k]
         [-d directory-name][-p {output-destination}]]|
     [[{-l|-L} [-a] [[-i {output-destination}]|
       [-t {output-destination,unused-area-size-threshold} [-v]]]]
        |[-t {output-destination,unused-area-size-threshold} [-v]]]]

To Page Top

Description

1. Compresses unused areas and reorganizes files if the ratio of unused areas is high for the ISAM files that the scheduler service uses.

2. Outputs the ratio of unused areas, data file fragmentation ratio, and unused area size for the ISAM files used by the scheduler service, to the standard output file.

   You can display the ratio of unused areas for the ISAM files even while the scheduler service is using the ISAM files.

3. Outputs the following information for the ISAM files that the scheduler service uses, to the specified destination as a message:

   - Information about reorganization (start and end date/time, statistics)

   - Unused area size

   - Whether the unused area size has reached the threshold

   You can specify one or more of the following message destinations:

   - Standard error output

   - Windows event log or Syslog

   - JP1 event

4. Checks whether the size of unused areas for the ISAM files that the scheduler service uses has reached the threshold and sets the result in the return value of the command.

5. Converts the format of the ISAM file.

To Page Top

Execution privileges

In Windows: Administrators privilege

In UNIX: Superuser privilege

To Page Top

Arguments

To Page Top

Notes

• Back up and store the files before reorganizing them. The ajsdbcond command uses the directory specified in the -d option as the work directory. The drive or partition containing that directory must have at least twice as much free space as the largest ISAM key file for the scheduler service for which you want to perform reorganization. In addition, the drive or partition containing the scheduler service database directory must have at least as much free space as the largest ISAM file for the scheduler service for which you want to perform reorganization.

• If you do not specify the -d option, the command uses the default OS work directory. For details, see the description of the Jiscond command in the Job Management Partner 1/Base User's Guide.

• If you specify none of the -x, -t, -l, -L, -k, and -m options, the -x option is assumed.

• If you specify the -x or -k option for this command, you must back up the ISAM files before executing the command (before reorganizing the ISAM files).

• If you specify the -x, -l, or -k option for this command, you must execute the command with the ISAM files closed (to close the ISAM files, execute the jajs_spmd_stop command to terminate the operation of JP1/AJS3. Be sure to stop all the JP1/AJS3 - Views and JP1/AJS3 Console Agent services.) When the ISAM files are open, executing the command will result in an error.

• If you specify the -L option for this command, you can also obtain information about any ISAM files that other processes are using. If another process is simultaneously updating the ISAM files, however, the command fails to obtain accurate information for any updates performed just when it obtains information. In order to maintain the integrity of the ISAM files, other processes attempting to access the ISAM files have to wait while the command is executed. You should not, therefore, use this command when the scheduler service is busy.

• The output information from this command with the -l or -L option specified refers to the ratio of unused areas, not the ratio of fragmentation. If, therefore, the ISAM file contains no records or there are an extremely limited number of records, 100% is output showing the ratio of unused areas to the empty area that has been reserved.

• Even if you reorganize the ISAM files, some unused areas may remain.

To Page Top

Return values

0	Normal end#1
1	The ISAM files being used contain unused areas exceeding the specified threshold size.#2
Multiple of 4 within the range from 4 to 124	Abnormal end

#1

When the -t and -v options are specified simultaneously, indicates that the ISAM files used by the scheduler service have not reached the unused area size threshold.

#2

This code is returned only when the -t and -v options are specified simultaneously.

To Page Top

Additional informations

• The following shows the format of output when the -l or -L option is specified:

  

  The following items are output:

  Table name

  Displays the table name.

  Record count

  Displays the number of records.

  Data

  Displays the ratio of unused areas for the data file.

  Key 1

  Displays the ratio of unused areas for the first key file.

  Key 2

  Displays the ratio of unused areas for the second key file.

  This item is blank if there is only a single key file.

  There cannot be more than two key files.

• The following shows the format of output when the -a option is specified with the -l or -L option.

  

  Data is output in two rows for each table. The data displayed in the upper row is the same as that displayed with the -l or -L option. The lower row displays the unused area size for each file (in MB; 1 MB = 1,024 * 1,024 bytes).

  The following items are output:

  Table name

  Displays the table name.

  Record count

  Displays the number of records.

  Data

  When the -a option is specified, data is output in two rows for each table. The data displayed in the upper row is the same as that displayed with the -l or -L option. The lower row displays the unused area size.

  Fragment ratio

  For a variable-length record, updating a record may cause the data in ISAM files to be split into multiple blocks. This item displays the ratio of the split records to the total number of records. This item is only displayed for variable-length ISAM files. It displays a hyphen (-) for tables other than unit definition tables (BODY), schedule definition tables (SCH), and generation management tables (GEN).

  Key 1

  When the -a option is specified, data is output in two rows for each table. The data displayed in the upper row is the same as that displayed with the -l or -L option. The lower row displays the unused area size.

  Key 2

  When the -a option is specified, data is output in two rows for each table. The data displayed in the upper row is the same as that displayed with the -l or -L option. The lower row displays the unused area size.

  Unused area size

  Displays the total unused area size for the data and key files that comprise each ISAM file.

  Total unused area size

  Displays the total unused area size for the ISAM files that the scheduler service uses.

• The following shows the format of output when the -m option is specified:

  

  The following items are output:

  Table name

  Displays the table name.

  Reuse key

  Displays Enabled if the key reuse functionality for the ISAM file format is enabled.

  Displays Disabled for the conventional ISAM file format.

  Semaphore No.

  Displays the semaphore number if the file is split by semaphore.

  Otherwise, a hyphen (-) is displayed.

• If you specify j (JP1 event) as the output destination for the -p, -i, or-t option, the following JP1 events are output:

  Specified option	Event ID	Event name	Issued when	Message ID
  -p	00004150	Scheduler database reorganization started	Reorganization starts.	KAVS1500-I
  -p	00004151	Scheduler database reorganization ended normally	Reorganization ends normally.	KAVS1501-I
  -p	00004152	Scheduler database reorganization ended abnormally	Reorganization ends abnormally.	KAVS1502-E
  -i	00004153	ISAM unused area size information	ISAM unused area size information is obtained.	KAVS1503-I
  -t	00004154	ISAM unused area size threshold reached	The ISAM unused area size threshold is reached.	KAVS1504-W

  Note

  For details about the JP1 events, see A. JP1 Events Issued by JP1/AJS3 in the Job Management Partner 1/Automatic Job Management System 3 Administration Guide.

• The following describes a database reorganization log that is output when the database is reorganized:

  When you execute the ajsdbcond command, it creates the CONDENSE{1|2}.log file in the directory storing the database. This file contains the database reorganization log, which records the following statistics:

  • Start date/time, end date/time, and time required

  • Unused area size and total file size before database reorganization

  • Unused area size and total file size after database reorganization

  Data is logged in the HNTR log format.

  Message KAVS1510-I is output with the statistics of database reorganization embedded.

  Output example

  KAVS1500-I Database condensing of the scheduler service (AJSROOT1) started. 20XX/10/01 01:05:40
  KAVS1510-I CONDENSE: Before condensing the database. Unused area size:102.020 MB  Total file size:542.245 MB
  CONDENSE: ISAM After condensing the database. Unused area size:0.100 MB  Total file size:440.225 MB
  KAVS1501-I Database condensing of the scheduler service (AJSROOT1) ended normally. 20XX/10/01 01:05:40 - 20XX/10/01 01:20:20 (00:14:40)

To Page Top

Example 1

The following command reorganizes the ISAM files the AJSROOT1 scheduler service uses, when the scheduler service is stopped:

ajsdbcond -x -F AJSROOT1

To Page Top

Example 2

The following command outputs the status of the ISAM files the AJSROOT1 scheduler service uses (ratio of unused areas, unused area size, and data file fragmentation ratio):

ajsdbcond -l -a -F AJSROOT1

To Page Top

Example 3

The following command outputs information about the ISAM files the scheduler service uses to the standard output, and outputs messages to the standard error output and Windows event log or Syslog if the unused area size has reached the threshold (10 MB):

ajsdbcond -L -a -t se,10 -F AJSROOT1

To Page Top