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|table2|index2}
      -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 AJS2DATA)

ajsembdbaddarea
     -r table
     -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 AJS2INDX)

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

Format3 (for expanding the tablespace AJS2DATA2)

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

Format4 (for expanding the index area AJS2INDX2)

ajsembdbaddarea
     -r index2
     -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 | table2 | index2`

Specifies the type of database area to be expanded.

table

Expands the tablespace AJS2DATA.
index

Expands the index area AJS2INDX.
table2

Expands the tablespace AJS2DATA2.

Do not specify this option if the backup enhancement function is disabled.
index2

Expands the index area AJS2INDX2.

Do not specify this option if the backup enhancement function is disabled.

`-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 2,047^#.

#:: If you specified table2 for the -r option, you can specify a value between 50 and 2,047 for the -s option.

`-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.

`-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.

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.
Do not execute multiple ajsembdbaddarea commands for a single embedded database.

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:

ajsRRRRRRIIIIYYYYMMDDhhmmss

RRRRRR: 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.
KAVS8404-E	The backup enhancement function is disabled.	Check the specification of the `-r` option and then re-execute the command.

To Page Top