Job Management Partner 1/Automatic Job Management System 3 Command Reference 1

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]]]]

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.

Execution privileges

In Windows: Administrators privilege

In UNIX: Superuser privilege

Arguments

-F service-name

Specify the name of the target scheduler service.

You can specify a character string of 1 to 30 bytes.

If you omit this option, the system assumes the default service name.

-m

Outputs the semaphore number and the ISAM file format (whether the the key reuse functionality is enabled or disabled) of the specified scheduler database.

You cannot specify this option with any option other than -F.

-x

Reorganizes the ISAM files that the scheduler service uses.

-k

Converts all ISAM files that constitute the specified scheduler service to the format enabling the key reuse functionality, and completely reorganizes the data and key files.

-d directory-name

Specify the directory for the work file used for key sorting, if you reorganize the ISAM files that the scheduler service uses.

For an explanation of the system action when you omit this option, see the description of the Jiscond command in the Job Management Partner 1/Base User's Guide.

-p {output-destination}

Outputs a message when the command starts and ends the reorganization of the ISAM files that the scheduler service uses.

You must specify this option with the -x option.

• output-destination
  Specifies one of the following message output destinations.
  You can specify a single destination or a combination of two or more destinations.
  e: Standard error output
  s: Windows event log or Syslog
  j: JP1 event
  

The following shows example message output when this option is specified:

Example 1: When reorganization is started

 
KAVS1500-I Database condensing of the scheduler service (AJSROOT1) started. 20XX/10/01 01:05:40

Example 2: When reorganization is ended normally

 
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)

The start date/time, end date/time, elapsed time, unused area size before reorganization, and unused area size after reorganization are also output.

Example 3: When reorganization is ended abnormally

 
KAVS1502-I Database condensing of the scheduler service (AJSROOT1) ended abnormally. 20XX/10/01 01:05:40 - 20XX/10/01 01:20:20 (00:14:40)

{-l|-L}

Displays the ratio of unused areas for the ISAM files that the scheduler service uses.

You can obtain more detailed information about the ISAM files by specifying this option with the -a option.

• -l
  Exclusively uses the ISAM files to obtain information.
  Because this option exclusively uses the files, it provides more accurate information than the -L option. It, however, causes an error if another process is using the ISAM files.
  
• -L
  Obtains information without exclusively using the ISAM files.
  Because this option does not exclusively use the files, it can obtain information even while the scheduler service is using the ISAM files. 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.
  

-a

Outputs detailed information about the ISAM files that the scheduler service uses.

If this option is specified with the -l or -L option, the command outputs the data file fragmentation ratio and unused area size as well as the ratio of unused areas.

-i {output-destination}

Outputs a message indicating the unused area size for the ISAM files that the scheduler service uses.

• output-destination
  Specifies one of the following message output destinations.
  You can specify a single destination or a combination of two or more destinations.
  e: Standard error output
  s: Windows event log or Syslog
  j: JP1 event
  

The following shows example message output when this option is specified:

Example:

 
KAVS1503-I The ISAM unused area size of the scheduler service (AJSROOT1) is 99 MB.

-t {output-destination,unused-area-size-threshold}

Outputs a message if the unused area size for the ISAM files that the scheduler service uses has reached the specified threshold.

You can use this option to schedule the execution of the ajsdbcond command as a JP1/AJS3 job when the scheduler service is not very busy, so that the command periodically checks the status of the ISAM files and outputs a warning message as required.

• output-destination
  Specifies one of the following message output destinations.
  You can specify a single destination or a combination of two or more destinations.
  

  e: Standard error output

  s: Windows event log or Syslog

  j: JP1 event

• unused-area-size-threshold
  Specifies a threshold for the unused area size for the ISAM files.
  You can specify a value within the range from 1 to 1024 (in MB; 1 MB = 1,024 * 1,024 bytes).
  

The following shows example message output when this option is specified:

Example:

 
KAVS1504-W The ISAM unused area size for scheduler service (AJSROOT1) is 101 MB, which exceeds the 100 MB threshold value.

-v

Sets the return value (process end code) of the command to indicate whether the ratio of unused areas has reached the specified value.

You must specify this option with the -t option.

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.

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.

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)

Example 1

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

 
ajsdbcond -x -F AJSROOT1

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

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

[Contents][Back][Next]

Copyright (C) 2009, 2010, Hitachi, Ltd.
Copyright (C) 2009, 2010, Hitachi Solutions, Ltd.