Hi friend
At first thanks for reply. It is ok if i change
1. LOGRETAIN = NO
2. USEREXIT = NO
my database will not be in backup pending state. But each time i have to
restore last known good backup image.
I have to write a ETL(extraction transformation loading) in which i will
get a del file which is to be store in database,if it has some error i have
to caught error and send back complete file for processing and again restore
it , This is client requirement.
If i use WARNINGCOUNT 1 then the record before error will be insert (let
say 100) . Now i have to rollback all of then.
So Each time i can not restore the backup this is my problem since i have
to automate the complete process.
My main concern is i m not able to run the terminate/restart command And db2
says if u r using any one option database should be in pending state.
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 get the above error . I do not know why it is.
Plz tell me am i doing somthing wrong.
Or tell me is there any way to come out the problem
thanks & regards
shailendra
-----Original Message-----
From: Bhamani, Naushad A [mailto:Naushad.[Email Address Removed] Friday, April 26, 2002 5:56 PM
To: 'Shailendra Kumar Bhati'; [Email Address Removed] RE: WELCOME to [Email Address Removed] : (please check your system date it is 2001-01-26)
This section is to do a load and make sure that it stops when it finds one
invalid record:
1. LOGRETAIN = NO
2. USEREXIT = NO
3. LOAD from D:\load\methodP.del of del modified by method P(1,3,4)
WARNINGCOUNT 1 MESSAGE methodP.loadmsg (INSERT/REPLACE) INTO
temp_methodp(a,c,b)
Note: Try --
CPU_PARALLELISM = # of CPU,
DISP_PARALLELISM = no. of disks (or) no of containers *** which ever is
greater
INDEXING MODE -- if indexes are present, and depending on INSERT/REPLACE
mode make it REBUILD/INCREMENTAL/AUTOSELECT(safest)
For your problem: Make sure you are back to circular logging and restart the
database (or) restore the database from the last known good backup image.
The explanation to the error "Unable to open the file." is:
--- This could be caused by an incorrect file name or insufficient authority
to access the file/directory. Correct the problem and either restart or
rerun the load. --- Meaning that Db2 cannot access the file methodP.del in
D:\load (or) the dump file c:\dump.txt
Remove the DUMP FILE option from the load command and run the LOAD in
TERMINATE mode. I think now, because you are in archival logging, the
database will move into backup pending state. Take a backup if the data is
good (or) as i had mentioned earlier, restore from last known good backup
image.
Please try this and let know of questions if any.
HTH
-----Original Message-----
From: Shailendra Kumar Bhati [mailto:[Email Address Removed] Friday, April 26, 2002 6:11 AM
To: [Email Address Removed] RE: WELCOME to [Email Address Removed]
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.
---------------------------------------------------------------------
To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed] 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