Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Accessing DB2/AS400 table using SQL

0 views
Skip to first unread message

Erik Loy

unread,
Aug 15, 1997, 3:00:00 AM8/15/97
to

I am currently coding an application in LotusScript and I need to pull
data from a
DB2 AS/400 database via ODBC. I have managed to make the connection and
get
the row I want, but the performance is very bad; it takes about 5
minutes to pull out the correct row. The table contains abt. 500 000
rows...

Any suggestions on how i can increase performance without touching
anything on the AS400? Shouldn't there be some indexes taking care of
this?
--
- Erik Loy

Kent Milligan

unread,
Aug 18, 1997, 3:00:00 AM8/18/97
to

Sounds you don't have the index created that the AS/400
optimizer needs for pulling out the "correct" row. You
need to run under debug mode to verify that the query
optimizer is building a temporary index to satisfy your
query.

Also, visit this URL for general AS/400 ODBC tips:
http://www.softmall.com/as400/cs/csinfo.html

In article <33F4BE1D...@online.no>, Erik Loy <el...@online.no> writes:
|> I am currently coding an application in LotusScript and I need to pull
|> data from a
|> DB2 AS/400 database via ODBC. I have managed to make the connection and
|> get
|> the row I want, but the performance is very bad; it takes about 5
|> minutes to pull out the correct row. The table contains abt. 500 000
|> rows...
|>

--
Kent Milligan, DB2/400 Solutions Team
AS/400 Partners In Development
km...@us.ibm.com
GO HAWKEYES!!
(opinions stated are not necessarily those of my employer)

Jeremy Rickard

unread,
Aug 18, 1997, 3:00:00 AM8/18/97
to

In article <5t9htj$1170$1...@news.rchland.ibm.com>, Kent Milligan
<km...@rs45693.rchland.ibm.com> writes

>
>You need to run under debug mode to verify that the query
>optimizer is building a temporary index to satisfy your
>query.
>

Can it really do that? This doesn't tie in with the rest of the DB2
family AFAIK.

--
Jeremy Rickard

Kent Milligan

unread,
Aug 19, 1997, 3:00:00 AM8/19/97
to

Yes, it's a cost based optimizer, so depending on the
query and data distribution in your table it could do
that.

In article <jNxEUIA9...@jbdr.demon.co.uk>, Jeremy Rickard <Jer...@jbdr.demon.co.uk> writes:
|>
|> Can it really do that? This doesn't tie in with the rest of the DB2
|> family AFAIK.
|>

--

0 new messages