Unix Technical Forum

Re: Microsoft ODBC driver for DB2 OS/390 and DTS

This is a discussion on Re: Microsoft ODBC driver for DB2 OS/390 and DTS within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Pablo - I know MS made a bunch of updates/fixes to the driver in SP1 for HIS2000 - are ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 08:15 PM
Neil Pike
 
Posts: n/a
Default Re: Microsoft ODBC driver for DB2 OS/390 and DTS

Pablo - I know MS made a bunch of updates/fixes to the driver in SP1 for
HIS2000 - are you using the driver from that version?

> We are trying to start using the Microsoft ODBC driver included
> with Host Integration Server 2000 to import and export data from our
> DB2 in OS/390 to SQL Server. Actually we are using the driver from
> Star SQL but we are finding some weird problems. We have a VB app that
> configures a DTS package to download or upload a table from DB2 to SQL
> and I am finding some strange situations:
>
> - When we download a table with 60000 records with 10M size in SQL
> Server the process reaches the 180M of memory starting in 8M (it grows
> constantly). When we use the Star SQL driver the memory usage of the
> process is constant (9M).
>
> Thank you.
>


Neil Pike MVP/MCSE. Protech Computing Ltd
(Please post ALL replies to the newsgroup only unless indicated otherwise)


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:22 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com