Cause: The records in the worksheet format (WSF) file are expected to be in ascending order (row 1, col 1 ... row 1, col 256; row 2, col 1 ... row 2, col 256, and so on). Some damage has occurred to the WSF file or it was generated incorrectly, possibly with a level of the Lotus product not supported by the database manager.
The IMPORT utility stops processing.
Action: Regenerate the WSF file with a supported level of the Lotus product.
Cause: A beginning-of-file (BOF) record must be the first record of a worksheet format (WSF) file. It cannot occur at any other location in the file. Some damage has occurred to the WSF file or it was generated incorrectly, possibly with a level of the Lotus product not supported by the database manager.
The IMPORT utility stops processing.
Action: Regenerate the WSF file with a supported level of the Lotus product.
Cause: The input file is valid, but it did not contain any usable data to be imported. The first worksheet row is reserved for title information. The second worksheet row is used for column labels. Data begins in the third row.
The IMPORT utility stops processing.
Action: Regenerate the worksheet format (WSF) file with valid data in the rows that the database manager uses for data.
Cause: File types other than IXF are not allowed with the CREATE or REPLACE_CREATE keywords in the Action String (e.g. "REPLACE into ...") parameter.
The IMPORT utility stops processing. No data is imported.
Action: Change the file type to IXF, or use INSERT, INSERT_UPDATE or REPLACE.
Cause: The parameters specified on the command require that the table exists.
The utility stops processing. No data is loaded.
Action: Do one of the following:
Cause: The CREATE keyword indicates that a new table must be created but a table with the specified name already exists.
The IMPORT utility stops processing. No data is imported.
Action: Either erase the existing table or use a keyword other than CREATE and resubmit the command.
Cause: An SQL error occurred while inserting a row into the table.
If the SQL error is not severe the row will be rejected and the utility continues processing; otherwise the utility stops processing.
Action: Examine other messages in the message file for details about the actual error and resubmit the command, if necessary.
Cause: The CREATE or REPLACE_CREATE option was specified on the IMPORT command. Either:
The IMPORT utility stops processing. No table is created.
Action: Either correct the columns specified in the METHOD and Action String parameters or correct the columns specified in the METHOD parameter.
Cause: The code page values for the column and the application are not compatible. When the FORCEIN parameter is not specified, the data cannot be loaded if the conversion from the IXF file code pate to the application code page is not supported.
The utility stops processing. No data is loaded.
Action: To load data with these code pages, resubmit the command with the FORCEIN option.
Cause: During the load of a PC/IXF file, a graphic data column was encountered. Because the FORCEIN parameter was not used, the data cannot be loaded.
The utility stops processing. No data is loaded.
Action: If you want to load the data with the graphic data, resubmit the command with the FORCEIN parameter.
Cause: The CREATE or REPLACE_CREATE option was specified on the IMPORT command. A column with an invalid C record was found while importing the PC/IXF file.
The IMPORT utility stops processing. The table is not created.
Action: Verify the column definition information in the input file.
Cause: The disk or diskette is full. During the export to a PC/IXF file, either the PC/IXF data file is on a fixed disk, or the PC/IXF data file and the database are on the same drive, or the PC/IXF data file and the message file are on the same drive.
The EXPORT utility stops processing. The exported data is not complete.
Action: Provide more space on the disk or diskette or specify that the data file be located on a different drive than the database or the message file and resubmit the command.
Cause: During the load of a PC/IXF file, an A record was found in the PC/IXF file, that contained run identification information (in the date and time fields) that differs from the run identification information in the header (H) record. This action does not apply to an A record at the start of a continuation file.
The input file has probably been damaged.
The utility stops processing.
Action: Re-create the damaged file, or repair the damaged file to recover as much data as possible. Resubmit the command.
Cause: During the load of a PC/IXF file that was created by Database Services, an A record was found in the PC/IXF file, that contained volume information (in the volume fields) that is not valid.
The input file has probably been damaged.
The utility stops processing.
Action: Re-create the damaged file, or repair the damaged file to recover as much data as possible. Resubmit the command.
Cause: During the load of a multiple part PC/IXF file, an I/O error occurred while the system was closing one of the files that make up the input PC/IXF file. This action does not apply to the last file in the group of files that make up the PC/IXF file.
The utility stops processing.
Action: Resubmit the command.
Cause: The filetmod string defines the generation and product family for the output WSF file. More than one generation or product family was defined in the string.
The utility stops processing. The output file is not created.
Action: Change the filetmod string to define only one generation and product family. Resubmit the command.
Cause: A COLDEL, CHARDEL, or DECPT keyword appears more than once in the filetmod parameter. This condition may arise while using delimited ASCII (DEL) files.
The utility stops processing. No data is loaded or exported.
Action: Resubmit the command with a correct filetmod parameter.
Cause: An SQL error occurred while creating the table.
The IMPORT utility stops processing. The table was not created. No data was imported.
Action: Look at the SQLCODE (message number) in the message for more information. Make changes and resubmit the command.
Cause: A COLDEL, CHARDEL, or DECPT keyword is located at the very end of the filetmod parameter. There is no delimiter or decimal point character following the keyword. This condition may arise while using delimited ASCII (DEL) files.
The utility stops processing. No data is loaded or exported.
Action: Resubmit the command with a correct filetmod parameter.
Cause: The IMPORT utility could not insert a row of data into the database because the database transaction log was full. All work was committed, but the utility could not insert the row, because the database transaction log remains full.
The utility stops processing. All previous changes were committed, but the current row was not imported.
Action: Check the amount of space remaining on the filesystem containing your database files. Consider increasing the maximum log size in the database configuration file.
Cause: An error occurred in the wait/post semaphores.
The utility stops processing. For the EXPORT utility, data may be incomplete on the media. For the IMPORT utility, data not already committed is rolled back.
Action: Stop and restart DB2 and resubmit the utility.
Cause: A column of data returned by the SQL statement is not supported.
Action: Correct the error and retry the command.
Cause: When you are doing an export of a WSF file and the SELECT statement results in a row of all NULL values, the row will not be added to the WSF file. The total number of rows specified in message SQL3105N is the number of rows resulting from the SELECT statement and not the number of rows in the WSF file.
The command continues processing.
Action: No action required. This is an informational message.
Cause: When you call IMPORT or LOAD with an Action String (e.g. "REPLACE into ...") parameter which contains a column list after the table name, this message will result if it is invalid. For example, the following Action String parameters will fail:
The command cannot continue.
Action: Change the Action String parameter with a valid column list and call the utility again.
Cause: A system error occurred during processing.
The utility stops processing.
Action: Record all error information from the SQLCA, if possible. Retain the message file. Terminate all applications using the database. Reboot the system. Restart the database. Try the command again.
If sufficient memory resources exist and the problem continues, invoke the Independent Trace Facility at the operating system command prompt. Refer to the Independent Trace Facility in the Troubleshooting Guide for information on how to use this facility.
Cause: Only even length character fields can be loaded into graphic database columns.
The row is not loaded.
Action: Either load the data to a new table using the CREATE option in the IMPORT command or do not load this column into this table.
Cause: This may accompany another error message. It indicates an attempt was made to get access to a file or directory in a way that is incompatible with the attributes of the file. One of the following may be the source of the difficulty:
The command cannot be processed.
Action: Retry the utility when the file is not in use, or retry the utility directing the output to a path and file that allows writing.
Cause: This message may accompany another error message. It indicates that the maximum number of open files has been reached.
The command cannot be processed.
Action: Terminate other applications to reduce the number of files open and retry the utility.
Cause: This message may accompany another error message. It indicates that a file or directory to be accessed does not exist or cannot be found.
The command cannot be processed.
Action: Resubmit the command with the correct file name, including a valid path.
Cause: This message may accompany another error message. It indicates there is not enough storage available to open the file.
The command cannot be processed.
Action: Stop the application. Possible solutions include:
Cause: This message may accompany another error message. It indicates there is no available space for writing on the device.
The command cannot be processed.
Action: To make space available on the device, delete unneeded files or direct the output data to a device with space available.
Cause: An I/O error has occurred while attempting to write data to a temporary file on the server (temporary files are created in the tmp directory under the sqllib directory for the instance of the database manager). The file system on the server may be full.
The utility stops processing. The database is unchanged.
Action: Contact the System Administrator for the server to make space available on the server, and resubmit the command.
Cause: A system I/O error has occurred while attempting to read the temporary message file on the server.
The IMPORT operation is complete; however, the message file on the database client system may be empty or incomplete.
Action: Query the remote database to determine if the utility operation was successful.