On Feb 8, 2:51 am, cwahlme.@data-tronics.com wrote: Racerx, In my humble experience, that error masks other errors. ( The one it masks the most in our shop is an ODBC/ ADO timeout error.) However, if you had the error while logging into one of the applications, it may be something else. The only way to see the real error is to run a trace. Does this application connect using the ODBC driver or an OLEDB driver? Craig Wahlmeier It is a OLEDB driver. When we changed the aduseclient to SERVER,we did not recieve the error again. Can we have some light on this?.
Your account is ready. You're now being signed in. Sorry It's me again I try use Bulk load mode to load data to db2(version 8.2) thu informatica (version ) but I got error message like WRITER_1 1> Thu Jun WRITER_1 1> WRT_8123 Failed to prepare target table load. Database error: -1800 WRITER_1 1> WRT_8164 Error loading into target [ FFAUTRN_ ACCM] : Database driver error. Function Name : Execute SQL Stmt : INSERT INTO. DB2 Fatal Error DB2 bulk execute ( CLI load) failed. [ IBM][ CLI Driver] CLI0125 E Function sequence error. SQLSTATE= HY010 sqlstate = HY010 [ IBM][ CLI Driver] CLI0125 E Function sequence error. SQLSTATE= HY010 sqlstate = HY010 Turning off DB2 bulk mode ( CLI load) failed. Database driver error. Function Name : Close DB2 Fatal Error WRITER_1 1> Thu Jun WRITER_1 1> WRT_8068 Writer initialization failed. Writer terminating. MASTER> PETL_24020 any one pls told me how to config db2 database or informatica session tks a lot Mark this reply as the best answer?( Choose carefully, this can't be changed) Yes | No Saving. B D replied Jun 2, 2005 Hi, U try normal mode and check if it is working. Thanks. Mark this reply as the best answer?( Choose carefully, this can't be changed) Yes | No Saving. cobainyeh replied Jun 6, 2005 hi Thanks for ur info I try normal mode before but it's slowly I had about 6700000 rows data and write throughput is 1400/sec, select throughput is 4400/sec and finish need about 1hour and 40 mins and we need to finish in 1hour and 20 mins ) I see document. It said that use bulk load or external loader will more faster (when insert larget data). I have config DTM Buffer Size(2000000->128000000) and Default buffer block size (64000->512000). Did u had any idea to more faster Thanks a lot Vendor: -99999; Message: [ IBM][ CLI Driver] CLI0125 E Function sequence error. SQLSTATE= HY010 COM.ibm.db2.jdbc. DB2 Exception: [ IBM][ CLI Driver] CLI0125 E Function sequence error. SQLSTATE= HY010 at java.sql. SQLException.( SQLException.java:45) at COM.ibm.db2.jdbc. DB2 Exception.( DB2 Exception. java:71) at COM.ibm.db2.jdbc.app. SQLException Generator.throw_ S QLException( SQLException Generator.java:260) at COM.ibm.db2.jdbc.app. SQLException Generator.check_r eturn_code( SQLException Generator.java( Compiled Code) at COM.ibm.db2.jdbc.app. SQLException Generator.check_r eturn_code( SQLException Generator.java( Compiled Code) at COM.ibm.db2.jdbc.app. DB2 Result Set.next( DB2 Result Se t.java( Compiled Code). (remaining stack trace snipped). The piece of code that caused the problem is approximated below. This code is called thousands of times, but failed only 3 times. The stack trace indicates that the rs.next part of the code threw the error. -begin code snippet- Prepared Statement pstmt Click = null; Result Set rs = null; try pstmt Click = PSPool.get Instance.get PSFC / get from pool pstmt Click.set Long(. / some set statements rs = pstmt Click.execute Query return(rs.next finally if (pstmt Click!= null) PSPool.get Instance.release PSFC(pstmt Click / release into pool rs.close end of code snippet- Comments appreciated. Let me know if you need more info about the DB2 server parameters, etc. Thanks. - Silver.
Download Now