DB2 Database Load sql3508n problem

Source: Internet
Author: User



sql3508n An error occurred while accessing a file or path of type ' < file type > ' during a load or load query. Reason code: "< reason code >". Path: "< path/File >".



[@[email protected]] Explanation: An error occurred while attempting to access the file while loading or loading the query processing. Utility stops at
Acting

User response: If a mount is being performed and the tablespace is not in the mounted pending state, the problem is corrected.
and call the Load utility again. If the tablespace is mounted in a pending state, the RESTART
or REPLACE mode to invoke the Load utility, or to restore a backup of the tablespace. can be used
The list tablespaces command determines the state of the tablespace.

The following is a list of reason codes:




1 cannot open the file.
This situation may be due to incorrect file names or insufficient permissions to access files/directories and
Caused by. Correct the problem and restart or rerun the mount operation.

2 cannot read/scan files.
This may be the result of a hardware error. If the error is a hardware error, execute the
Troubleshooting the appropriate action specified in the Guide to identify the hardware problem,
and restart or re-run load.




3 cannot write files or change file size.
This could be the result of a disk full state or a hardware error. Refer to the following list of file types,
And make sure there's enough room to run
Load, or specify to use a different location. Restart or re-run
Load. If the error is a hardware error, execute the Troubleshooting guide
To identify the hardware problem and restart or rerun the Load.




4 file contains invalid data.
The required files for Load contain incorrect data. See also the Tempfiles_path
Describes the operation.




5 cannot close the file.
If Load cannot be restarted or re-run, contact the IBM service representative.




6 The file cannot be deleted.
If Load cannot be restarted or re-run, contact the IBM service representative.




The  parameter is not specified correctly. Refer to the list of file types to determine the parameters of the error and rerun
Load, and specify a valid parameter.
The following is a list of file types:
I checked the meaning of error code 3508! For your reference!

Sortdirectory ensure that the Workdirectory parameter is correctly specified. In all directories,
You must have enough space to hold twice times the size of the index key for the data you are loading. For
Load Insert and load Restart,
You must also have two times as much space as the index key size of the existing data in the table.

Msgfile ensure that the Messagefile is correctly specified
Parameters. There must be enough disk space to write out the information generated during the mount.

If this is a Load query, make sure that the local information file parameter is the one that is used to query its state.
The messagefile parameters for Load are different.

Tempfiles_path ensure that the tempfiles path parameter is specified correctly. See Data
Movement Utilities Guide and Reference
To learn more details about this parameter.



DB2 Database Load sql3508n problem


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.