DB2 Destination

[Neo]

Hi all,

I installed cozyroc 1.3 and used the DB2 destination component. Before
using this, I was using an OLE DB Destination to insert data to DB2
and it was taking almost 3.5 hours to insert 1.4 million records.

But on replacing OLE DB destination with DB2 Destination I am getting
an SQL error dump and the package execution remains in yellow stage
with no errors. No records are getting inserted in the DB.

Please advise if you know the issue.

On using WINDbg to view the dump file I am getting the following :


Loading Dump File [C:\Program Files\Microsoft SQL Server\90\Shared
\ErrorDumps\SQLDmpr0018.mdmp]
User Mini Dump File: Only registers, stack and portions of memory are
available

Symbol search path is: *** Invalid ***
****************************************************************************
* Symbol loading may be unreliable without a symbol search
path. *
* Use .symfix to have the debugger choose a symbol
path. *
* After setting your symbol path, use .reload to refresh symbol
locations. *
****************************************************************************
Executable search path is:
Windows Server 2003 Version 3790 (Service Pack 2) MP (4 procs) Free
x86 compatible
Product: Server, suite: TerminalServer SingleUserTS
Debug session time: Fri Jul 18 09:13:00.000 2008 (GMT+6)
System Uptime: not available
Process Uptime: 0 days 0:00:03.000
..............................................................................................
Loading unloaded module list
.
This dump file has an exception of interest stored in it.
The stored exception information can be accessed via .ecxr.
(c3c.1548): CLR exception - code e0434f4d (first/second chance not
available)
eax=00000000 ebx=7c37aa7e ecx=052ae37c edx=7c8285ec esi=000011a8
edi=00000000
eip=7c8285ec esp=052aed58 ebp=052aedc8 iopl=0 nv up ei ng nz
ac pe cy
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000
efl=00000297
*** ERROR: Symbol file could not be found. Defaulted to export
symbols for ntdll.dll -
ntdll!KiFastSystemCallRet:
7c8285ec c3 ret


Regards,
Neo

[Ivan Peev]

Neo,

I will need more information about what is the DB2 client and server
versions. Also what version of SQL Server do you use? SQL 2005 or SQL
2008? The DB2 Destination component requires installation of IBM Data
Server Runtime Client version 9.5 .

One more thing. I will need more information about the data type of
the columns you are inserting into? We have found a deadlock problem
when inserting into "decimal" column, but there might be another
column type which is causing issues.

Regards,
Ivan