Hitachi

Hitachi Advanced Database Messages


KFAA50225-E

The aa....aa specification contains an error or indispensable operand is not specified, or a necessary operand has not been specified. (reason = bb....bb) (M)

There is a bb....bb error in the specification of aa....aa.

aa....aa: Option specified by command

The following table provides details.

Value of aa....aa

Description

table

Table name

schema-name

Schema name

table-identifier

Table identifier

file-name

File name

filetype

Data type

fld-char

Field-delimiting character

fld-char-pre

Field-delimiting character (preceding)

fld-char-suf

Field-delimiting character (following)

trm-char

Line-delimiting character

idx-mode

Index creation method

index

Index identifier

col-inf-n

Column unit information count

col-inf

Column unit information

data-len

Input data length of column

err-inf

Error information

deliminator

Delimiting character

enclosing-character

Enclosing character

table-name-file

Table name description file

table option

Table option

input-path-file-name

Input data path file name

input-file-name

Input data file name

export-path-file-name

Output data path file name

export-data-output-file-name

Output data file name

timing-to-output-progress-message

Output interval for progress message on data import processing

temporary-directory

Path name of the storage directory for temporary work files:

References the command's -w option.

If the -w option is omitted for a command, the path name of the storage directory for temporary work files is $DBDIR/ADBWORK.

import-option-file-name

Import option file name

idxrebuild-option-file-name

Index rebuild option file name

cost-information-collection-option-file-name

Cost information collection option file name

export-option-file-name

Export option file name

merge-chunk-option-file-name

Merge chunk option file name

error-data-file-name

Logical error data file name

sort-buffer-size

Sort buffer size

--force

-- force option (forced execution)

--create-temp-file

--create-temp-file option

user-name

Authorization identifier

index-ID file

Index identifier file

index-ID file name

Index identifier file name

SQL-statement-file-name

SQL statement file name

column-structure-information-file-name

Column structure information file name

-b option

-b option

index-name

Index name ("[schema-name.]index-identifier")

DBarea-name

DB area name

-n option

-n option

-c option

-c option

-m option

-m option

-s option

-s option

-k option

-k option

-r option

-r option

chunk ID

Chunk ID

--compress

File compression option

archive-directory

Archive directory

archive-file-name

Archive file name

file-that-specifies-the-unload-file-directory

Name of the directory path file that specifies the storage directory for unload files

unload-file-directory

Path name of the storage directory for unload files

bb....bb: Detailed information about error

The following table provides details.

Value of bb....bb

Description

invalid char

The specified character is invalid.

This error also occurs if the specified file name includes reserved characters, or if an EOF control character is included in the input control file.

invalid value

The specified value is invalid. Carefully review whether the specification is correct.

invalid combination

The specified combination is invalid. Carefully review whether the specification is correct.

invalid format

The specified format is invalid. Carefully review whether the specification is correct.

invalid length

The specified value length is invalid. Carefully review the specified value length.

length over

The specified value exceeds the limit. Another possibility is that a 0-byte character has been specified. Carefully review the specified value.

length short

The specified value is less than the minimum that can be specified. Carefully review the range of values that can be specified.

limit over

The maximum count that can be specified has been exceeded. Carefully review the specified count.

not directory name

The specified path name is invalid. Carefully review whether the specification is correct.

not file name

The specified path is not a file. Alternatively, the file does not exist. Carefully review whether the specification is correct.

insufficient memory(u)

Memory area cannot be acquired. Read the message output before this message and take the corrective action indicated.

insufficient memory(s)

error convert path

An error occurred in absolute path conversion. Carefully review whether the path specification is correct for input data files and the like.

duplicate

A specification has been used more than once. Alternatively, the specified file name is the same as one of the following file names:

  • Logical error data file name

  • Unload file name

Carefully review to make sure that a duplicated value was not specified.

invalid permission

Access permissions are lacking. Carefully review whether access permissions have been granted.

not index-identifier

The specified index identifier does not exist.

table for which "CHUNK" was not specified

The CREATE TABLE statement does not include the chunk specification.

not index name

The specified index does not exist.

not DBarea name

The specified DB area does not exist.

unsupported DBarea name

The specified DB area type is not supported.

S:

Terminates processing.

Action:

Eliminate the cause of the error based on aa....aa and bb....bb. Then, retry the operation.

This message might also be output due to one of the following reasons:

  • A required operand was not specified.

  • The sequence of specifying operands is invalid.

  • A file with the same name as a logical error data file was specified.

If bb....bb is insufficient memory(u) or insufficient memory(s), take the action outlined in the following procedure:

  1. Check for any unnecessary processes. If there are any unnecessary processes, shut them down or delete them.

  2. If there is not enough memory after performing step 1, restart the OS, and then start the HADB server with the adbstart command.

  3. If there is not enough memory after performing step 2, change the kernel parameter setting to increase the amount of memory that processes can use. After restarting the OS, start the HADB server with the adbstart command.