ajsembdbaddarea
- Organization of this page
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
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.
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
-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.
If you omit this option, the system assumes _JF0.
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.
Return values
0 |
Normal end |
Values other than 0 |
Abnormal end |
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
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. |