473,390 Members | 1,723 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,390 software developers and data experts.

SQL3508N Error in accessing a file or path of type "TEMP_FILE" during load

Environment:

$ uname -a
AIX <withheld2 5 000100614C00

$ db2level
DB21085I Instance "<withheld>" uses "32" bits and DB2 code release
"SQL08024"
with level identifier "03050106".
Informational tokens are "DB2 v8.1.1.104", "s060120", "U805924", and
FixPak
"11".
Product is installed at "/usr/opt/db2_08_01".

Failing SQL synopsis:

DECLARE xyz CURSOR FOR SELECT <withheld>
;

....
DB20000I The SQL command completed successfully.
LOAD FROM xyz OF CURSOR MESSAGES /path/to/message/dir/xyz.log
TEMPFILES PATH /path/to/temp/dir
REPLACE INTO <schema>.<table>
STATISTICS YES AND DETAILED INDEXES ALL
;

Agent Type Node SQL Code Result
__________________________________________________ ____________________________
LOAD 001 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 002 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 003 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 004 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 005 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 006 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 007 +00000000 Success.
__________________________________________________ ____________________________
LOAD 008 +00000000 Success.
....
LOAD 028 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 029 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 030 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
RESULTS: 2 of 30 LOADs completed successfully.
__________________________________________________ ____________________________

Summary of LOAD Agents:
Number of rows read = 0
Number of rows skipped = 0
Number of rows loaded = 0
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 0

SQL3508N Error in accessing a file or path of type "TEMP_FILE" during
load or
load query. Reason code: "1". Path:
"/path/to/temp/dir/DB20049A.PID/DB200003.OID/load0024".

There is approximately 172 gig left on drive. This is a new directory,
so persistent historical data is not the problem. This is only
happening
on our development box - there is no problem in the production or user
acceptance
test environments.

The problem is intermittent. Sometimes you can just resubmit the job
and it works. Right now, it's just not working.

TIA for any help or advice.

Dan Mercer

Jan 18 '07 #1
2 14040
Can be different reasons
1) check ulimit -a on your dev box to see if there is a limit on file
size
2) check the chmod values for the directory you are writing the load
file to..
maybe the user you are loading the data as does not have appropriate
privileges to write to the directory.

************************************************** *************************************************
contractsup wrote:
Environment:

$ uname -a
AIX <withheld2 5 000100614C00

$ db2level
DB21085I Instance "<withheld>" uses "32" bits and DB2 code release
"SQL08024"
with level identifier "03050106".
Informational tokens are "DB2 v8.1.1.104", "s060120", "U805924", and
FixPak
"11".
Product is installed at "/usr/opt/db2_08_01".

Failing SQL synopsis:

DECLARE xyz CURSOR FOR SELECT <withheld>
;

...
DB20000I The SQL command completed successfully.
LOAD FROM xyz OF CURSOR MESSAGES /path/to/message/dir/xyz.log
TEMPFILES PATH /path/to/temp/dir
REPLACE INTO <schema>.<table>
STATISTICS YES AND DETAILED INDEXES ALL
;

Agent Type Node SQL Code Result
__________________________________________________ ____________________________
LOAD 001 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 002 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 003 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 004 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 005 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 006 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 007 +00000000 Success.
__________________________________________________ ____________________________
LOAD 008 +00000000 Success.
...
LOAD 028 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 029 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 030 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
RESULTS: 2 of 30 LOADs completed successfully.
__________________________________________________ ____________________________

Summary of LOAD Agents:
Number of rows read = 0
Number of rows skipped = 0
Number of rows loaded = 0
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 0

SQL3508N Error in accessing a file or path of type "TEMP_FILE" during
load or
load query. Reason code: "1". Path:
"/path/to/temp/dir/DB20049A.PID/DB200003.OID/load0024".

There is approximately 172 gig left on drive. This is a new directory,
so persistent historical data is not the problem. This is only
happening
on our development box - there is no problem in the production or user
acceptance
test environments.

The problem is intermittent. Sometimes you can just resubmit the job
and it works. Right now, it's just not working.

TIA for any help or advice.

Dan Mercer
Jan 22 '07 #2
************************************************** *************************************************
contractsup wrote:
Environment:

$ uname -a
AIX <withheld2 5 000100614C00

$ db2level
DB21085I Instance "<withheld>" uses "32" bits and DB2 code release
"SQL08024"
with level identifier "03050106".
Informational tokens are "DB2 v8.1.1.104", "s060120", "U805924", and
FixPak
"11".
Product is installed at "/usr/opt/db2_08_01".

Failing SQL synopsis:

DECLARE xyz CURSOR FOR SELECT <withheld>
;

...
DB20000I The SQL command completed successfully.
LOAD FROM xyz OF CURSOR MESSAGES /path/to/message/dir/xyz.log
TEMPFILES PATH /path/to/temp/dir
REPLACE INTO <schema>.<table>
STATISTICS YES AND DETAILED INDEXES ALL
;

Agent Type Node SQL Code Result
__________________________________________________ ____________________________
LOAD 001 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 002 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 003 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 004 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 005 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 006 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 007 +00000000 Success.
__________________________________________________ ____________________________
LOAD 008 +00000000 Success.
...
LOAD 028 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 029 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
LOAD 030 -00003508 Init error. Table unchanged.
__________________________________________________ ____________________________
RESULTS: 2 of 30 LOADs completed successfully.
__________________________________________________ ____________________________

Summary of LOAD Agents:
Number of rows read = 0
Number of rows skipped = 0
Number of rows loaded = 0
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 0

SQL3508N Error in accessing a file or path of type "TEMP_FILE" during
load or
load query. Reason code: "1". Path:
"/path/to/temp/dir/DB20049A.PID/DB200003.OID/load0024".

There is approximately 172 gig left on drive. This is a new directory,
so persistent historical data is not the problem. This is only
happening
on our development box - there is no problem in the production or user
acceptance
test environments.

The problem is intermittent. Sometimes you can just resubmit the job
and it works. Right now, it's just not working.

TIA for any help or advice.

Dan Mercer
Asphalt Blazer wrote:
Can be different reasons
1) check ulimit -a on your dev box to see if there is a limit on file
size
ulimit -a
....
file(blocks) unlimited
....

2) check the chmod values for the directory you are writing the load
file to..
maybe the user you are loading the data as does not have appropriate
privileges to write to the directory.
I created a brand new parent directory with permissions 777 - no luck.

However, we have had a similar problem with the MSGFILES keyword. In
both
cases, the error messages have contained truncated path names. The
major
difference between the production, uat and dev environments is the
path length
of the locations where we keep logs and tempfiles. To get around this
we
have symbolically linked our log dir and tempfile dir into /tmp which
seems
to obviate the problem.

Dan Mercer

Jan 22 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Vivek | last post by:
Hi, I want to know if it is possible to load(using the db2load API) into a remote database. By remote database i mean one that i have cataloged. Any parameters that need to be changed ? TIA
4
slapshock
by: slapshock | last post by:
gud morning!!!!!!!! i have a problem on how to upload photo and save it in the database.... i am not so familiar in visual basic on how to code..... can you help me with this problem?? i want...
4
by: liberty1 | last post by:
Hi everyone. I appreciate your effort at helping newbies like me. I have the following problems and will appreciate urgent help. PROBLEM NUMBER 1: Using PHP and MySQL, I am able to upload...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.