DB2 Bulk Loading Error

Raghu31 — Fri, 15 Nov 2024 23:44:32 GMT

Hi,

I am facing the following error while loading the DB2 using tDB2BULKExec component.

The requirement is loading data from .CSV to DB2 using Bulk mode.

Error:

-----------

Starting job test at 13:12 14/09/2021.

[statistics] connecting to socket on port 3875

[statistics] connected

Exception in component tDBBulkExec_1 (test)

com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-3025, SQLSTATE= , SQLERRMC=null, DRIVER=4.13.127

at com.ibm.db2.jcc.am.id.a(id.java:682)

at com.ibm.db2.jcc.am.id.a(id.java:60)

at com.ibm.db2.jcc.am.id.a(id.java:127)

at com.ibm.db2.jcc.am.no.b(no.java:2310)

at com.ibm.db2.jcc.am.no.c(no.java:2293)

at com.ibm.db2.jcc.t4.cb.l(cb.java:370)

at com.ibm.db2.jcc.t4.cb.f(cb.java:98)

at com.ibm.db2.jcc.t4.q.e(q.java:81)

at com.ibm.db2.jcc.t4.sb.k(sb.java:160)

at com.ibm.db2.jcc.am.no.lb(no.java:2259)

at com.ibm.db2.jcc.am.oo.b(oo.java:4427)

at com.ibm.db2.jcc.am.CallableStatement.ic(CallableStatement.java:117)

at com.ibm.db2.jcc.am.CallableStatement.execute(CallableStatement.java:96)

at poc.test_0_1.test.tFileInputDelimited_1Process(test.java:788)

at poc.test_0_1.test.tDBConnection_1Process(test.java:496)

at poc.test_0_1.test.runJobInTOS(test.java:1364)

at poc.test_0_1.test.main(test.java:1146)

[FATAL] 13:12:16 poc.test_0_1.test- tDBBulkExec_1 DB2 SQL Error: SQLCODE=-3025, SQLSTATE= , SQLERRMC=null, DRIVER=4.13.127

com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-3025, SQLSTATE= , SQLERRMC=null, DRIVER=4.13.127

at com.ibm.db2.jcc.am.id.a(id.java:682) ~[db2jcc4-6.0.0.jar:?]

at com.ibm.db2.jcc.am.id.a(id.java:60) ~[db2jcc4-6.0.0.jar:?]

at com.ibm.db2.jcc.am.id.a(id.java:127) ~[db2jcc4-6.0.0.jar:?]

at com.ibm.db2.jcc.am.no.b(no.java:2310) ~[db2jcc4-6.0.0.jar:?]

at com.ibm.db2.jcc.am.no.c(no.java:2293) ~[db2jcc4-6.0.0.jar:?]

at com.ibm.db2.jcc.t4.cb.l(cb.java:370) ~[db2jcc4-6.0.0.jar:?]

at com.ibm.db2.jcc.t4.cb.f(cb.java:98) ~[db2jcc4-6.0.0.jar:?]

at com.ibm.db2.jcc.t4.q.e(q.java:81) ~[db2jcc4-6.0.0.jar:?]

at com.ibm.db2.jcc.t4.sb.k(sb.java:160) ~[db2jcc4-6.0.0.jar:?]

at com.ibm.db2.jcc.am.no.lb(no.java:2259) ~[db2jcc4-6.0.0.jar:?]

at com.ibm.db2.jcc.am.oo.b(oo.java:4427) ~[db2jcc4-6.0.0.jar:?]

at com.ibm.db2.jcc.am.CallableStatement.ic(CallableStatement.java:117) ~[db2jcc4-6.0.0.jar:?]

at com.ibm.db2.jcc.am.CallableStatement.execute(CallableStatement.java:96) ~[db2jcc4-6.0.0.jar:?]

at poc.test_0_1.test.tFileInputDelimited_1Process(test.java:788) [classes/:?]

at poc.test_0_1.test.tDBConnection_1Process(test.java:496) [classes/:?]

at poc.test_0_1.test.runJobInTOS(test.java:1364) [classes/:?]

at poc.test_0_1.test.main(test.java:1146) [classes/:?]

[statistics] disconnected

Job test ended at 13:12 14/09/2021. [Exit code = 1]

Any help will be greatly appreciated.

Thanks,

Raghu Hari

Re: DB2 Bulk Loading Error

gjeremy1617088143 — Thu, 16 Sep 2021 12:24:39 GMT

Hi @Raghu Hari , I see an error -3025 --> SQL3025N A parameter specifying a filename or path is not valid.,

Hope that can help you.

Send me love and kudos

topic Re: DB2 Bulk Loading Error in Talend Studio

DB2 Bulk Loading Error

Re: DB2 Bulk Loading Error