Fehlernachrichten

SQL2700 - SQL2799


SQL2701NInvalid command line option for "<progname>". Reason code: "<reason-code>"

Erläuterung: Command line option for the data splitting utility is not valid. Valid options are:

Benutzeraktion: Given for each reason code:

1
There is an option not started with '-' sign.

2
Each option except 'h' (or 'H') must be followed by an argument.

3
There is an invalid option.

4
The argument of an option is too long (maximum 80 characters).


SQL2702NFailed to open the configuration file "<config-file>".

Erläuterung: The utility cannot read the configuration file "<config-file>".

Benutzeraktion: Please ensure the configuration file exists and is readable.


SQL2703NFailed to open the log file "<log-file>".

Erläuterung: The utility cannot open the log file "<log-file>" for writing or appending.

Benutzeraktion: Please ensure the log file exists and is writable.


SQL2704NFailed to open the input data file "<input-data-file>".

Erläuterung: The utility cannot read the input data file "<input-data-file>".

Benutzeraktion: Please ensure the input data file exists and is readable.


SQL2705NFailed to open the input partitioning map file "<in-map-file>".

Erläuterung: The utility cannot read the input partitioning map file "<in-map-file>".

Benutzeraktion: Please ensure the input partitioning map file exists and is readable.


SQL2706NFailed to open the output partitioning map file "<out-map-file>".

Erläuterung: The utility cannot open the output partitioning map file "<out-map-file>" for writing.

Benutzeraktion: Please ensure the output partitioning map file is writable.


SQL2707NFailed to open the distribution file "<dist-file>".

Erläuterung: The utility cannot open the distribution file "<dist-file>" for writing.

Benutzeraktion: Please ensure the distribution file is writable.


SQL2708NFailed to open the output data file "<out-data-file>".

Erläuterung: The utility cannot open the output data file "<out-data-file>" for writing.

Benutzeraktion: Please ensure the output data file is writable.


SQL2709NSyntax error at line "<line>" of the configuration file.

Erläuterung: There is a syntax error in the specification of a keyword and its argument.

Benutzeraktion: A keyword and its argument must be delimited by an '=' sign.


SQL2710NInvalid keyword at line "<line>" of the configuration file.

Erläuterung: There is an undefined keyword in the configuration file.

Benutzeraktion: Valid keywords (case insensitive) are:


SQL2711NInvalid column delimiter (CDELIMITER) at line "<line>" of the configuration file.

Erläuterung: The column delimiter (CDELIMITER) specified in the configuration file is not valid.

Benutzeraktion: Make sure the column delimiter (CDELIMITER) is a single byte character.


SQL2712NInvalid string delimiter (SDELIMITER) at line "<line>" of the configuration file.

Erläuterung: The string delimiter (SDELIMITER) specified in the configuration file is not valid.

Benutzeraktion: The string delimiter (SDELIMITER) cannot be a period.


SQL2713NInvalid run type (RUNTYPE) at line "<line>" of the configuration file.

Erläuterung: The value for run type (RUNTYPE) specified in the configuration file is not valid.

Benutzeraktion: Valid run type (RUNTYPE) can be either PARTITION or ANALYZE (case insensitive).


SQL2714NInvalid message level (MSG_LEVEL) at line "<line>" of the configuration file.

Erläuterung: The value for message level (MSG_LEVEL) specified in the configuration file is not valid.

Benutzeraktion: Valid message level (MSG_LEVEL) can be either CHECK or NOCHECK (case insensitive).


SQL2715NInvalid check level (CHECK_LEVEL) at line "<line>" of the configuration file.

Erläuterung: The value for check level (CHECK_LEVEL) specified in the configuration file is not valid.

Benutzeraktion: Valid check level (CHECK_LEVEL) can be either CHECK or NOCHECK (case insensitive).


SQL2716NInvalid record length (RECLEN) "<reclen>" at line "<line>" of the configuration file.

Erläuterung: The value for record length (RECLEN) "<reclen>" specified in the configuration file is not valid.

Benutzeraktion: The record length (RECLEN) must be between 1 and 32767.


SQL2717NInvalid node specification (NODES) at line "<line>" of the configuration file. Reason code "<reason-code>".

Erläuterung: The node specification (NODES) in the configuration file is not valid.

Benutzeraktion: Given for each reason code:

1
NODES has already been defined.

2
The format is not valid. A valid example: NODES=(0,30,2,3,10-15,57)

3
Each entry must be numeric data between 0 and 999.

4
Range specification must be from a lower number to a higher number.


SQL2718NInvalid output node specification (OUTPUTNODES) at line "<line>" of the configuration file. Reason code "<reason-code>".

Erläuterung: The output node specification (OUTPUTNODES) in the configuration file is not valid.

Benutzeraktion: Given for each reason code:

1
OUTPUTNODES has already been defined.

2
The format is not valid. A valid example: OUTPUTNODES=(0,30,2,3,10-15,57)

3
Each entry must be numeric data between 0 and 999.

4
Range specification must be from a lower number to a higher number.


SQL2719NInvalid output type (OUTPUTTYPE) at line "<line>" of the configuration file.

Erläuterung: The output type (OUTPUTTYPE) in the configuration file is not valid.

Benutzeraktion: Valid output types (OUTPUTTYPE) are W (write) or S (stdin), case insensitive.


SQL2720NNumber of partition keys exceeded the maximum "256". This error was detected at line "<line>" of the configuration file.

Erläuterung: The number of partitioning keys defined cannot exceed the maximum limit: 256.

Benutzeraktion: Remove one or more partitioning keys defined in the configuration file.


SQL2721NInvalid partitioning key specification (PARTITION) at line "<line>" of the configuration file. Reason code "<reason-code>".

Erläuterung: A partitioning key specification (PARTITION) in the configuration file is not valid. Valid format:

 PARTITION=<key name>,<position>,<offset>,
           <len>,<nullable>,<datatype>

If a delimited-data file, <position> must be defined; otherwise, <offset> and <len> must be defined.

Benutzeraktion: Given for each reason code:

1
Fields must be delimited by the ',' character.

2
<position>, <offset> and <len> must be positive integers.

3
<nullable> must take a value from {N,NN,NNWD}.

4
Valid <data type> includes: SMALLINT, INTEGER, CHARACTER, VARCHAR, FOR_BIT_CHAR, FOR_BIT_VARCHAR, FLOAT (for binary numerics only), DOUBLE (for binary numerics only), DATE, TIME, TIMESTAMP, DECIMAL(x,y).

5
For DECIMAL data type, precision (x) and scale (y) must be specified and they must be positive integers.

6
For CHARACTER or VARCHAR data type, <len> must be specified."


SQL2722NInvalid log file specification (LOGFILE) at line "<line>" of the configuration file.

Erläuterung: The log file specification (LOGFILE) in the configuration file is not valid.

Benutzeraktion: The log file specification (LOGFILE) must be in one of the following two formats:

<log type> can only be W (write) or A (append), case insensitive.


SQL2723NInvalid trace specification (TRACE) at line "<line>" of the configuration file.

Erläuterung: The trace specification (TRACE) in the configuration file is not valid.

Benutzeraktion: The trace specification (TRACE) must be a positive integer between 0 and 65536 (exclusive).


SQL2724NInvalid node list specification.

Erläuterung: The node list specification is not valid.

Benutzeraktion: One and only one of the two parameters: NODES and MAPFILI (input partition map) must be specified in the configuration file.


SQL2725NFilename for output partition map was not specified.

Erläuterung: If run type is ANALYZE, a filename for the output partition map must be defined.

Benutzeraktion: Specify a filename for the output partition map.


SQL2726NThere is no partitioning key defined.

Erläuterung: At least one partitioning key must be defined.

Benutzeraktion: Specify one or more partitioning keys.


SQL2727NPartition key "<key-name>" exceeds the record length "<reclen>".

Erläuterung: For non-delimited data, starting position for a key must be less than the record length.

Benutzeraktion: Make sure starting position for a key is less than the record length.


SQL2728NOutput node "<out-node>" is not defined in the node list.

Erläuterung: Output node list must be a subset of the node list, which is derived from NODES or the input partition map file.

Benutzeraktion: Make sure all output nodes are defined in the node list.


SQL2729NInvalid input partition map.

Erläuterung: There is at least one error in the input partition map file.

Benutzeraktion: The input partition map must contain no less than 4096 data entries, and each data entry must be a number between 0 and 999.


SQL2730NError while writing header to output data file "<out-data-file>".

Erläuterung: An I/O error occurred while writing the header to an output data file.

Benutzeraktion: Check your operating system documentation for file I/O errors and ensure that there is sufficient space on the output device.


SQL2731NError while reading from input data file "<filename>".

Erläuterung: An I/O error occurred while reading from input data file.

Benutzeraktion: Check your operating system documentation for file I/O errors.


SQL2732NLine "<line>" of the input data file contains binary data.

Erläuterung: Binary data is not permitted on the host versions of this utility program.

Benutzeraktion: Check your input data file.


SQL2733NRun type (RUNTYPE) was not defined in the configuration file.

Erläuterung: The run type (RUNTYPE) must be defined as either PARTITION or ANALYZE.

Benutzeraktion: Please specify run type (RUNTYPE) in the configuration file.


SQL2734NInvalid specification for parameter 32KLIMIT at line "<line>" of the configuration file.

Erläuterung: The specification for parameter 32KLIMIT in the configuration file is not valid.

Benutzeraktion: Parameter 32KLIMIT can be either YES or NO, case insensitive.


SQL2735WThe record "<rec-no>" of the input data file was discarded because it was an empty record.

Erläuterung: The record "<rec-no>" of the input data is discarded because it contains nothing but spaces.

Benutzeraktion: Check record "<rec-no>" in the input data file.


SQL2736Nsqlugrpi_api returned an error when processing record at line "<line>" of the input data file.

Erläuterung: Partitioning key fields contain invalid data.

Benutzeraktion: Check the input data file at line "<line>".


SQL2737NFailed to write output data file for output node "<out-node>" when processing record at line "<line>" of input data file.

Erläuterung: An I/O error occurred while writing a record to the output data file for node "<out-node>".

Benutzeraktion: Check your operating system documentation for file I/O errors and ensure that there is sufficient space on the output device.


SQL2738WRecord at line "<line>" of input data file has been truncated when writing to the output data file for node "<out-node>". Expected writing length is "<reclen>" while actual writing length is "<real-len>".

Erläuterung: Expected writing length (RECLEN) does not match the actual writing length.

Benutzeraktion: Adjust record length value defined in the configuration file.


SQL2739NThe record length was not specified for a binary numerical data file.

Erläuterung: If a binary numerical input data file, the record length has to be defined.

Benutzeraktion: Please specify the record length in your configuration file.


SQL2740NFloat data type is not allowed in a non-binary input data file.

Erläuterung: Float data type is only supported when the file type is BIN (binary).

Benutzeraktion: Make sure data types and the type of input data file match.


SQL2741NInvalid file type specification at line "<line>" of the configuration file.

Erläuterung: The file type specification (FILETYPE) in the configuration file is not valid.

Benutzeraktion: Valid values for the file type parameter are as follows:

All the values are case insensitive.


SQL2742NThe length of partition key "<partition-key>" does not match its precision.

Erläuterung: In a binary input data file, the length of a partition key with decimal data type must conform to the equation: LENGTH=(PRECISION+2)/2 (integer division), because it is a packed decimal.

Benutzeraktion: Match the length of a decimal-typed partition key with its precision if the input data file is a binary data file.


SQL2743NThe length of partition key "<partition-key>" does not match its data type.

Erläuterung: In a binary input data file, the length of a partition key with integer, small integer, float, and double data type must be a predefined constant, i.e. 4 for integer, 2 for small integer, 4 for float, and 8 for double.

Benutzeraktion: Check partition key definitions in the configuration file.


SQL2744NIllegal file name specification for "<file>" at line "<line>" of the configuration file.

Erläuterung: The maximum length for a file name is 80 bytes.

Benutzeraktion: Check the configuration file.


SQL2745NInvalid NEWLINE flag at line "<line>" of the configuration file.

Erläuterung: The NEWLINE flag must be either YES or NO, and if not given, it is NO.

Benutzeraktion: Check the specification of NEWLINE flag in the configuration file.


SQL2746NAn incomplete record was found while reading record "<record-number>" from the input data file.

Erläuterung: If a fixed-length positional ASC file or a binary numerical data file, each record has to be exactly the same length as the value of the RECLEN parameter in the configuration file.

Benutzeraktion: Make sure the input data file is complete.


SQL2747NA record was too long while reading record "<rec-no>" from the input data file.

Erläuterung: For a positional ASC input data file or a delimited data file with parameter 32KLIMIT on, the maximum record length can not exceed the 32k (bytes) limit.

Benutzeraktion: Check your input data file and make sure the record length is less than 32k bytes.


SQL2748NRecord "<record-number>" has a length of "<length>" bytes, which is too short to hold the partitioning key "<key>".

Erläuterung: For a positional ASC input data file or a binary numerical data file, each record has to be long enough to hold all partitioning keys.

Benutzeraktion: Check the record length of your input data file.


SQL2749NPartitioning key "<key-no>" of record "<rec-no>" was not in the first 32k bytes of the record.

Erläuterung: If a record is greater than 32k bytes long in a delimited data file, all partitioning keys of each record have to be within the first 32k bytes of the record.

Benutzeraktion: Check record "<rec-no>" in the input data file.


SQL2750NThe length of line "<line-number>" in the configuration was more than 255 bytes.

Erläuterung: The maximum length of a line in the configuration file must be less than 255 bytes.

Benutzeraktion: Check your configuration file and make sure all lines are less than 255 bytes.


SQL2751NThe actual length "<actual-reclen>" of record "<rec-no>" did not match the expected length "<exp-reclen>".

Erläuterung: If new line checking is required for a fixed length ASC data file (NEWLINE parameter is YES and RECLEN parameter is not zero), the actual length of each record has to match the expected record.

Benutzeraktion: Check record "<rec-no>" in the input data file.


SQL2752NInvalid codepage specification "<codepage>" at line "<line>" of the configuration file.

Erläuterung: The codepage specification is not valid. It must be a positive integer.

Benutzeraktion: Correct the codepage specification in the configuration file.


SQL2753NFailed to get the country code and codepage for the application. Return code from function "<function-name>" is "<rc>".

Erläuterung: The program failed to get the country code and codepage of its environment.

Benutzeraktion: Check with your database system adminstrator.


SQL2754NCodepage "<source-cp>" cannot be converted to codepage "<target-cp>".

Erläuterung: The database does not support codepage conversion between those two codepages.

Benutzeraktion: Please ensure your data is in a convertible codepage.


SQL2755NDecimal data can not be in both IMPLIEDDECIMAL and PACKEDDECIMAL format.

Erläuterung: Valid format of decimal data is SQL_PACKEDDECIMAL_FORMAT, SQL_CHARSTRING_FORMAT, or SQL_IMPLIEDDECIMAL_FORMAT, mutually exclusive.

Benutzeraktion: Verify the format of your decimal data, correct the format value, and resubmit the command.


SQL2761NOnly one of table name or nodegroup can be specified.

Erläuterung: Specify either the table name or the nodegroup name, but not both.

Benutzeraktion: Check your command line options.


SQL2762NThe utility failed to find the database installation path.

Erläuterung: The utility needs to know where the database manager is installed, then it can find its bind file.

Benutzeraktion: Make sure your database manager is properly installed.


SQL2763NThe table "<tbl-name>" was not found.

Erläuterung: The table "<tbl-name>" cannot be located in sysibm.systables.

Benutzeraktion: Make sure the table exists in the database.


SQL2764NThe nodegroup "<nodegroup>" was not found.

Erläuterung: The nodegroup "<nodegroup>" cannot be located in sysibm.sysnodegroupdef.

Benutzeraktion: Make sure the nodegroup exists in the database.


SQL2765WThe utility failed to open output partition map file "<out-map-file>".

Erläuterung: The utility cannot open the output partition map file for writing. It will write the output to stdout.

Benutzeraktion: Check your file access permissions.


SQL2766NThe partition map is not of the correct size "<map-size>".

Erläuterung: The size of the partition map is not correct. Data is corrupted in the database.

Benutzeraktion: Contact the Database Administrator to resolve the problem.


SQL2767NA command line option is not valid.

Erläuterung: There is an invalid command line option.

Benutzeraktion: Make sure to specify the correct command line options.


[ Seitenanfang | Vorherige Seite | Nächste Seite | Inhaltsverzeichnis | Index ]