Re: ASC-Sequel

[joberhol@xxxxxxxxxxxx]

*SNIP
We are leaning towards using ASC-Sequel report writer.  Has anyone
had experiences good or bad with their product?
*ENDSNIP

I have done quit a bit of tuning for customers with it.  It does a nice job
of what it advertises, however.......

Make sure you tune your database.  That requires you to understand the data
access you will need and make sure that the query optimizer has the indices
it wants.  The ASC product is really a front end to the SQL that runs  on
the AS/400 so the query optimizer is called, and will spend all its time
building access paths for you if it does not find what it wants.  Because
end users will not generally understand the data base schema, I don't
consider this an end user tool.

If you are running the autotune feature of OS/400 you might consider
turning that off as well.  With it on, the shared pools will be changing
sizes forcing the optimizer to build a new access plan every time the query
is run.

Make sure to use the "userspace" option instead of the dataarea option when
you install.  Much better implementation.

Jim Oberholtzer


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---