db2 version 8 load

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

veronica24 - 17 Mar 2005 22:43 GMT

I need some help. I am currently running a load script on db2 version
7 on an AIX 5.1.02 server in our production environment. We have
upgraded our test server with db2 version 8 AIX 5.2..03. The load
script does not run now. I am getting a SQL3025N A parameter
specifying a filename or path is not valid. The input file is located
in my current working directory. I own the file and have done a chmod
777 to make sure it was not a permission issue. I am connecting to the
database and the table because I do a select than a delete on the table
before the load. What things have changed in DB2 version 8 load that I
would need to be aware of during my loading process. Has anyone else
had this problem?

Reply to this Message

Rhino - 17 Mar 2005 23:06 GMT

> I need some help. I am currently running a load script on db2 version
> 7 on an AIX 5.1.02 server in our production environment. We have
[quoted text clipped - 7 lines]
> would need to be aware of during my loading process. Has anyone else
> had this problem?

I have not had this problem in Version 8 or any previous version of DB2.
However, just based on general experience with DB2, do you have any other
filepaths in your LOAD statement? Maybe it is one of them that is causing
the problem. For instance, if you have an inaccurate LOB path, maybe that is
the one that is causing the error.

Try checking *all* of the different files and paths referenced in your
statement to make sure you have the paths, file names, and permissions
correct for all of them.

Rhino

Reply to this Message

veronica24 - 18 Mar 2005 14:56 GMT

I had a MESSAGES /p2p/install/logs/p2p_loadAllLinks.db2log statement
however just to be sure that this was not the problem I removed it. I
only have the path to my data file and the insert into my table. It is
a very plain simple load. Before the load statement in my script I did
a tail -100 on my data file. I am able to more the file and tail the
file. The very next statement is to load the file and I get a
SQL3025N. This is what my load script looks like: Any ideas would
be greatly appreciated.

db2 load from /p2p/install/data/p2p_alllinks.dat of ASC modified by
nullindchar=? METHOD L (1 50,51 61,62 72,73 102, 103 132, 133 162, 163
192, 193 193, 194 293, 294 393, 394 493, 494 593, 594 623, 624 653, 654
679, 680 709, 710 735, 736 761, 763 792, 793 822, 823 852, 853 882, 883
912, 913 922, 923 932, 933 942, 943 952, 953 978) null indicators
(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,762,0,0,0,0,0,0,0,0,0,979 ) insert
into P2P.PTY_TO_PTY_LINKS (
LINK_NO,PARTY1_ID,PARTY2_ID,PARTY1_ROLETYPE,PARTY2_ROLETYPE,LINK_STATUS,LINK_TYPE_DESC,SUPER_REL_ID,PARTY1_LASTNAME,PARTY1_FIRSTNAME,PARTY2_LASTNAME,PARTY2_FIRSTNAME,REQ_CREATOR_ID,REQ_OWNER_ID,CREATED_DATE,LASTMODIFIED_ID,LASTMODIFIED_DATE,TERM_DATE,DELETE_REASON,PARTY1_LOB,PARTY2_LOB,PARTY1_CMRM_ID,PARTY2_CMRM_ID,PARTY1_COMPANY_NO,PARTY2_COMPANY_NO,PARTY1_COSTCENTER_NO,PARTY2_COSTCENTER_NO,DELETE_DATE
) nonrecoverable

Reply to this Message

Ian - 18 Mar 2005 21:08 GMT

> I had a MESSAGES /p2p/install/logs/p2p_loadAllLinks.db2log statement
> however just to be sure that this was not the problem I removed it. I
[quoted text clipped - 14 lines]
> LINK_NO,PARTY1_ID,PARTY2_ID,PARTY1_ROLETYPE,PARTY2_ROLETYPE,LINK_STATUS,LINK_TYPE_DESC,SUPER_REL_ID,PARTY1_LASTNAME,PARTY1_FIRSTNAME,PARTY2_LASTNAME,PARTY2_FIRSTNAME,REQ_CREATOR_ID,REQ_OWNER_ID,CREATED_DATE,LASTMODIFIED_ID,LASTMODIFIED_DATE,TERM_DATE,DELETE_REASON,PARTY1_LOB,PARTY2_LOB,PARTY1_CMRM_ID,PARTY2_CMRM_ID,PARTY1_COMPANY_NO,PARTY2_COMPANY_NO,PARTY1_COSTCENTER_NO,PARTY2_COSTCENTER_NO,DELETE_DATE
> ) nonrecoverable

Can the *instance owner* actaully read the data file? i.e. not just
permissions on the file itself, but also the directories (/p2p,
/p2p/install, and /p2p/install/data) should all have appropriate
permissions.

Ian

Reply to this Message

db2dba@gmail.com - 18 Mar 2005 22:38 GMT

:> I had a MESSAGES /p2p/install/logs/p2p_loadAllLinks.db2log statement
:> however just to be sure that this was not the problem I removed it. I
[quoted text clipped - 21 lines]
:
:Ian

I don't know if it will help, but useful info for db2 q&a is the DB2EUG mailing
list where there's additional info. More at
http://www2.herethey.com:8888/mailman/listinfo/db2eug or www.herethey.com for
the archives.

Reply to this Message