469,275 Members | 1,563 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,275 developers. It's quick & easy.

error regarding importing IXF data

here is my script

#!/bin/ksh

db2 connect to acqr1653 user username using password

db2 set integrity for cqr.plant_audit_fam off no access cascade immediate

db2 load from "/clocal/cqradmin/user/cqradm/db2move/load2test/CQR.PLANT_AUDIT_FAM.IXF" OF IXF SAVECOUNT 100 MESSAGES m.txt REPLACE INTO CQR.PLANT_AUDIT_FAM PARTITIONED DB CONFIG MODE LOAD_ONLY PART_FILE_LOCATION "/clocal/cqradmin/user/cqradm/db2move/load2test/"

db2 set integrity for cqr.plant_audit_fam immediate checked

db2 terminate

-----


and when i execute the above script, I get the following error

Database Connection Information

Database server = DB2/AIX64 8.2.7
SQL authorization ID = CQRADM
Local database alias = ACQR1653

DB20000I The SQL command completed successfully.

Agent Type Node SQL Code Result
__________________________________________________ ____________________________
LOAD 002 -00003025 Init error. Table unchanged.
__________________________________________________ ____________________________
RESULTS: 0 of 1 LOADs completed successfully.
__________________________________________________ ____________________________

Summary of LOAD Agents:
Number of rows read = 0
Number of rows skipped = 0
Number of rows loaded = 0
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 0

SQL3025N A parameter specifying a filename or path is not valid.
DB20000I The SQL command completed successfully.
DB20000I The TERMINATE command completed successfully.



how to resolve the SQL3025N bcos i checked the path of the file and the file itself, everything seems fine.

thanks,

regards,

aravind.s
Dec 6 '07 #1
0 1257

Post your reply

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

Similar topics

9 posts views Thread by advance scout | last post: by
5 posts views Thread by Mike Collins | last post: by
3 posts views Thread by nimajneb via AccessMonster.com | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.