By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,288 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,288 IT Pros & Developers. It's quick & easy.

error regarding importing IXF data

P: 1
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
Share this question for a faster answer!
Share on Google+

Post your reply

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