Hi
I m facing one more problem.I have to load the record from del file to
table but if any one record is invalid I have to rollback it complete.
To achieve it I keep my database in roll-forward state (logretain and
userexit parameter value 1), to use the restart/terminate mode for loading.
If I uses below command

db2 => load from D:\load\methodP.del of del modified by dumpfile =
c:\dump.txt
method P(1, 3, 4) terminate into temp_methodp(a,c,b)

SQL3508N Error in accessing a file or path of type "RESTART/TERMINATE INFO"
during load or load query. Reason code: "1". Path: "".

I got the above error on dos prompt and if I check my db2dig.log file it
gives me two error

2001-01-26-15.37.52.951000 Instance:DB2 Node:000
PID:257(db2syscs.exe) TID:398 Appid:*LOCAL.DB2.010126063609
database_utilities DIAG_ERROR Probe:0 Database:RAMP

Error!!! Failed to set temporary file path. -3508, 00000000, Detected in
file: d:\db2bld\src\sqluvtld.c, line 2851

2001-01-26-15.37.53.001000 Instance:DB2 Node:000
PID:257(db2syscs.exe) TID:398 Appid:*LOCAL.DB2.010126063609
buffer_pool_services sqlbTestSetDatapoolState Probe:574 Database:RAMP
DIA9999E An internal error occurred. Report the following error code :
"FFFFFFFF".

I m not getting any clue , please can u explain me what could be the reason.
Wait for reply
Thanks and regards
Shailendra Ku bhati

NIIT Software Solutions 'eBillSpace' software Powers Electronic Bill Payment
for India's Department of Posts - the World's Largest Postal Network. For
details visit our website http://www.niit.com
___________________NOTICE____________________________
This electronic mail transmission contains confidential information intended
only for the person(s) named. Any use, distribution, copying or disclosure
by any other person is strictly prohibited. If you received this
transmission in error, please notify the sender by reply e-mail and then
destroy the message. Opinions, conclusions, and other information in this
message that do not relate to the official business of NIIT shall be
understood to be neither given nor endorsed by NIIT When addressed to NIIT
clients, any information contained in this e-mail is subject to the terms
and conditions in the governing client contract.
DB2 & UDB email list listserv db2-l LazyDBA home page