473,387 Members | 1,864 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,387 software developers and data experts.

Path error when using DB2 load dumpfile modifier - related to partitioned database?

I searched for this topic and already read this article:

http://www.thescripts.com/forum/thread183687.html

However while I wait for the DBA's here to respond to my e-mail, I wanted to make a post and ask the question, is use of the dumpfile modifier on the db2 load command in any way related to whether or not you partition your database? I noticed all of our load scripts here have no dumpfile (like Oracle's .bad/.dsc files) and I thought that was really odd in a high volume ETL shop like ours.

The reason behind that, I was told by another developer, is that you can't use that modifier when you have a partitioned database. Is that true? I find that hard to believe, since knowing which records are rejected on a load is critical.

Here is the error I constantly get:

u060dw97:/u/uelmetl/etl/subject/tlogs/file>pfile = /u/uelmetl/etl/bin/rejected.log replace into ELMS.PHM_MDL nonrecoverable" <
SQL2036N The path for the file or device
"/u/uelmetl/etl/bin/rejected.log.load.084" is not valid.

On this command:

db2 "load client from $ETLROOT/subject/tlogs/file/phm_mdl.rpl of del modified by coldel| dumpfile = /u/uelmetl/etl/bin/rejected.log replace into ELMS.PHM_MDL nonrecoverable"

No matter which path I specify (all valid to the OS), I get that error.

Thanks in advance for any tips!
Dec 20 '06 #1
0 2152

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: MrTulley | last post by:
UDB V8 FP4 AIX 5.1 I am receiving the following error message while using the autoloader to load a pipe delimited file into a partitioned table: SQL3004N The filetype parameter is not valid....
7
by: Eric.Jones | last post by:
I've encountered a strange error with loading delimited files from a Samba (SMB) network drive, has anyone else seen this before? (Platform: WinXP Pro, UDB PE 8015, level 02060106, SAMPLE db) ...
5
by: Sumanth | last post by:
Hi, I am running into a problem ( only in this particular instance). I insert one row into a table - takes a fraction of a second try to do a bulk load of the same --takes 10 seconds. ...
3
by: jason | last post by:
I've been playing around with new (for 2.0) membershp functionality. I was able to build a simple login form that secures a directory on a project I built locally on my development desktop. ...
2
by: Ruymán | last post by:
Hello!, is possible use relative path in access? for example use "photo\image1.jpg" instead of "c:\db\photo\image1.jpg", I try it but I cann't, but in Visual Basic if is possible. Other...
2
by: jtembe | last post by:
Hi, When a need to import my dumpfile., -uuser -ppasswd -hlocalhost database < C:\dumpfile.mysql i have Error: UnKnow command '\b'. regards,
0
by: bogie | last post by:
Hello every one, I have a problem to restore my postgresql dumpfile. I have a postgresql database 7.3.2 in a linux environment and i want to restore the dumpfile that i make from linux environment...
39
by: Leonardo Korndorfer | last post by:
Hi, I'm litle confused by the const modifier, particularly when use const char* or char*. Some dude over here said it should be const char when you dont modify it content inside the function, I...
6
by: sachin | last post by:
Hi, I am facing some strange issue in DB2 UDB 9.5.1 I have created a database on DPF implemented environment and I tried to execute following commands Db2 create table test ( name char(10)...
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: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.