SQL1652N File I/O error occurred 1

[cristi22]

Hello -

Could you please help me figure out why the load is failing?

It’s been running all along & I’ve attempted to load the file today with the following message:

SQL3500W The utility is beginning the "LOAD" phase at time "04/29/200810:02:06.642163".

SQL2061N An attempt to access media is denied.
SQL1652N File I/O error occurred.
SQL0462W Routine "SYSPROC.DB2LOAD" (specific

name "DB2LOAD") has returned a
warning SQLSTATE, with diagnostic text "LOAD ERROR". SQLSTATE=01H00

The directory was not changed neither did the file permissions, nothing was changed on the db level.

thx!

 

[Truusvlugindewind]

In case were're talking db2/udb. Look into db2diag. If not clear, post it here.

 

[cristi22]

thank you very much for you time & help
here is the msg:

2008-05-08-06.50.04.641973-240 I111140639A451 LEVEL: Error
PID : 1400846 TID : 1 PROC : db2lrid
INSTANCE: db2inst2 NODE : 000 DB : BASYSDW
APPHDL : 0-85 APPID: *LOCAL.db2inst2.080508105004
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 103 bytes
LOADID: 1777778.2008-05-08-06.50.04.557683.0 (6;588)
-3531, 0, Detected in file: sqlulrid.C,line 2518

 

[cristi22]

it happens after instance being re-cycled

 

[cristi22]

the diag file is not clear at all...

 

[Truusvlugindewind]

Try to copy your file to another location, something like c:\temp or /tmp and load it from there.

 

[MarcLodge]

Hi Cristi,

Have a look here:

http://www-1.ibm.com/support/docvie...234623&loc=en_US&cs=UTF-8&lang=en&rss=ct71db2

and see if any of the solutions could apply.

Marc