ajsembdbaddarea

Organization of this page

Format
Description
Execution privileges
Storage directory
Arguments
Notes
Return values
Additional information
Actions to be taken if an error occurs

Format

ajsembdbaddarea
      -r {table|index}
      [-raw]
      -s embedded-database-file-system-area-size
      [-id embedded-database-setup-ID]
      -d name-of-directory-where-database-area-to-be-expanded-stored

Format1 (for expanding the tablespace)

ajsembdbaddarea
     -r table
     [-raw]
     -s embedded-database-file-system-area-size
     [-id embedded-database-setup-ID]
     -d name-of-directory-where-database-area-to-be-expanded-stored

Format2 (for expanding the index area)

ajsembdbaddarea
     -r index
     [-raw]
     -s embedded-database-file-system-area-size
     [-id embedded-database-setup-ID]
     -d name-of-directory-where-database-area-to-be-expanded-stored

To Page Top

Description

The ajsembdbaddarea command expands the embedded database area (tablespace or index area).

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.

To Page Top

Execution privileges

In Windows: Administrators privileges

In UNIX: Superuser privileges

To Page Top

Storage directory

In Windows:: JP1/AJS3 - Manager-installation-folder\tools\
In UNIX:: /opt/jp1ajs2/tools/

To Page Top

Arguments

`-r table | index`

Specifies the type of database area to be expanded.

table

Expands the tablespace.
index

Expands the index area.

`-raw`

Specify this option when you use a RAW file (character type special file).

`-s` `embedded-database-file-system-area-size`

Specify in MB the size of the file system area in the embedded database to be allocated.

You can specify a value in the range from 1 to 2047.

`-d` `name-of-directory-where-database-area-to-be-expanded-stored`

Use 120 bytes or less to specify the name of the directory that stores the database area to be expanded. If you specify a non-existent directory, an error occurs.

Keep the following points in mind when you specify a directory name:

Use a full path name to specify a directory name.
If you want to specify a directory whose name contains spaces, enclose the entire path in double quotation marks (").
Do not specify a disk on a network drive.
In a cluster system, specify a directory on the shared disk.
Make sure that the amount of space specified in the -s option is available to the specified directory.
If you also want to specify the -raw option, specify a partition that is not formatted (in Windows) or specify a character-type special file (in UNIX). Do not specify a partition in use or a character-type special file.

`-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 in the manual Job Management Partner 1/Automatic Job Management System 3 Command Reference 2.

If you omit this option, the system assumes _JF0.

To Page Top

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.
In a cluster system, execute this command on the executing host (the host specified for the -eh option of the ajsembdbbuild command).
The table area and the index area can each be expanded a maximum of 15 times.

To Page Top

Return values

0	Normal end
Values other than 0	Abnormal end

To Page Top

Additional information

When this command is executed, a file whose name is in the following format is created in the directory specified for the -d option:

ajsRRRRRIIIIYYYYMMDDhhmmss

RRRRR: Type of expanded resource (value specified for the -r option)
IIII: embedded database setup ID (value specified for the -id option)
YYYY: year
MM: month
DD: day
hh: hours
mm: minute
ss: second

Example:

The following shows an example of the command line and the file created when the command is executed at 21:40:12 on June 1, 2010:

ajsembdbaddarea -r index -s 2000 -d K:\rdarea -id _JF0
 
K:\rdarea\ajsindex_JF020100601214012

To Page Top

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 `ajsembdbstatus -s ust` 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.

To Page Top