DTS speed is too slow --conect AS/400
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
DTS speed is too slow --conect AS/400

 
Post new topic   Reply to topic    Windows Server Forum Index -> Host Integration Server
Author Message
ptrw
Guest
Posted: Tue Dec 07, 2004 4:45 pm    Post subject: DTS speed is too slow --conect AS/400 Reply with quote
Hello,

I am using DTS to get Data from AS/400 via VSAM OleDB provider. after many
days setting, connect AS/400 finally , but the transfer speed is too slow to
accept.
it must take 40 mins for transfering about 1000 rows from AS/400 to SQL
server,
IBM Client Access driver only takes 1 sec .

so , can any one tell me any possible factor about this tunning issue.

Thanks for the help!

--
Peter
Back to top
Charles Ezzell (MSFT)
Guest
Posted: Tue Dec 07, 2004 7:20 pm    Post subject: Re: DTS speed is too slow --conect AS/400 Reply with quote
Definitely sounds like things are not setup correctly. I would suggest
opening a case to verify your system is setup correctly.

Charles
"ptrw" <ptrw@discussions.microsoft.com> wrote in message
news:0B86193B-1198-4827-99FD-92AF592DAA13@microsoft.com...
Quote:
Hello,

I am using DTS to get Data from AS/400 via VSAM OleDB provider. after many
days setting, connect AS/400 finally , but the transfer speed is too slow
to
accept.
it must take 40 mins for transfering about 1000 rows from AS/400 to SQL
server,
IBM Client Access driver only takes 1 sec .

so , can any one tell me any possible factor about this tunning issue.

Thanks for the help!

--
Peter
Back to top
Aaron Grady [MSFT]
Guest
Posted: Tue Dec 07, 2004 11:08 pm    Post subject: Re: DTS speed is too slow --conect AS/400 Reply with quote
Also, what kind of data are you trying to access on the AS/400? If you are
trying to access relational data you should be using the HIS Ole DB Provider
for DB2 which can also connect to AS/400.

HTH,
--
Aaron Grady
MCSE + Internet, MCDBA, MCSD
SNA Server/Host Integration Server 2000
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm


"Charles Ezzell (MSFT)" <charliee@online.microsoft.com> wrote in message
news:em1CL%23F3EHA.3416@TK2MSFTNGP09.phx.gbl...
Quote:
Definitely sounds like things are not setup correctly. I would suggest
opening a case to verify your system is setup correctly.

Charles
"ptrw" <ptrw@discussions.microsoft.com> wrote in message
news:0B86193B-1198-4827-99FD-92AF592DAA13@microsoft.com...
Hello,

I am using DTS to get Data from AS/400 via VSAM OleDB provider. after
many
days setting, connect AS/400 finally , but the transfer speed is too
slow
to
accept.
it must take 40 mins for transfering about 1000 rows from AS/400 to SQL
server,
IBM Client Access driver only takes 1 sec .

so , can any one tell me any possible factor about this tunning issue.

Thanks for the help!

--
Peter

Back to top
ptrw
Guest
Posted: Wed Dec 08, 2004 8:37 am    Post subject: Re: DTS speed is too slow --conect AS/400 Reply with quote
HI,

It is a file system, not DB2.
as you mention before, it maybe a connection pool question , would you
please give any better configuration data for tunning it.
by the way, i have a another information about transfer data, it takes 16
hours for transfering 83000 rows from AS/400, it shows AS/400 OleDB driver
can transfer data completely, but too slow, on the other hand , IBM Client
Access Express driver transfer data so quickly, but sometime it hangs when
encounter huge data such as millions of data.
so i hope one can provide any idea to solve this issue really.

Thanks for the help!

--
Peter


"Aaron Grady [MSFT]" wrote:

Quote:
Also, what kind of data are you trying to access on the AS/400? If you are
trying to access relational data you should be using the HIS Ole DB Provider
for DB2 which can also connect to AS/400.

HTH,
--
Aaron Grady
MCSE + Internet, MCDBA, MCSD
SNA Server/Host Integration Server 2000
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm


"Charles Ezzell (MSFT)" <charliee@online.microsoft.com> wrote in message
news:em1CL%23F3EHA.3416@TK2MSFTNGP09.phx.gbl...
Definitely sounds like things are not setup correctly. I would suggest
opening a case to verify your system is setup correctly.

Charles
"ptrw" <ptrw@discussions.microsoft.com> wrote in message
news:0B86193B-1198-4827-99FD-92AF592DAA13@microsoft.com...
Hello,

I am using DTS to get Data from AS/400 via VSAM OleDB provider. after
many
days setting, connect AS/400 finally , but the transfer speed is too
slow
to
accept.
it must take 40 mins for transfering about 1000 rows from AS/400 to SQL
server,
IBM Client Access driver only takes 1 sec .

so , can any one tell me any possible factor about this tunning issue.

Thanks for the help!

--
Peter




Back to top
Aaron Grady [MSFT]
Guest
Posted: Fri Dec 17, 2004 7:30 am    Post subject: Re: DTS speed is too slow --conect AS/400 Reply with quote
Peter-

There's not a lot of performance tuning you can do for the provider. Are you
using it over TCP/IP or SNA? Whichever one you are using you may want to try
the other option to see if it's any faster.

Otherwise, you may want to investigate our ActiveX File Transfer control
which is designed to transfer entire files and usually provides better
results for entire files versus the Ole DB Provider for AS/400 and VSAM.
Once you transfer the file to your PC you can pull it into SQL Server using
DTS.

HTH,
--
Aaron Grady
MCSE + Internet, MCDBA, MCSD
SNA Server/Host Integration Server 2000
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm


"ptrw" <ptrw@discussions.microsoft.com> wrote in message
news:CDD8727E-0A69-4F0A-8A33-2A19DFBA0FA1@microsoft.com...
Quote:
HI,

It is a file system, not DB2.
as you mention before, it maybe a connection pool question , would you
please give any better configuration data for tunning it.
by the way, i have a another information about transfer data, it takes 16
hours for transfering 83000 rows from AS/400, it shows AS/400 OleDB driver
can transfer data completely, but too slow, on the other hand , IBM Client
Access Express driver transfer data so quickly, but sometime it hangs when
encounter huge data such as millions of data.
so i hope one can provide any idea to solve this issue really.

Thanks for the help!

--
Peter


"Aaron Grady [MSFT]" wrote:

Also, what kind of data are you trying to access on the AS/400? If you
are
trying to access relational data you should be using the HIS Ole DB
Provider
for DB2 which can also connect to AS/400.

HTH,
--
Aaron Grady
MCSE + Internet, MCDBA, MCSD
SNA Server/Host Integration Server 2000
Microsoft

This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of any included samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm


"Charles Ezzell (MSFT)" <charliee@online.microsoft.com> wrote in message
news:em1CL%23F3EHA.3416@TK2MSFTNGP09.phx.gbl...
Definitely sounds like things are not setup correctly. I would suggest
opening a case to verify your system is setup correctly.

Charles
"ptrw" <ptrw@discussions.microsoft.com> wrote in message
news:0B86193B-1198-4827-99FD-92AF592DAA13@microsoft.com...
Hello,

I am using DTS to get Data from AS/400 via VSAM OleDB provider.
after
many
days setting, connect AS/400 finally , but the transfer speed is too
slow
to
accept.
it must take 40 mins for transfering about 1000 rows from AS/400 to
SQL
server,
IBM Client Access driver only takes 1 sec .

so , can any one tell me any possible factor about this tunning
issue.

Thanks for the help!

--
Peter




Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> Host Integration Server All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB