Re: Performance of ODBC vs. other access methods

On 9/6/06, Elvis Budimlic <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

NO, IT DOES NOT NEED "just as much administering as other systems"!
Have you served as a DBA on System i & other systems?
There's no comparison!
Actually, most System i companies I talk to don't have a DBA function in
their company.  That's definitely not the case on other platforms.

what extra work is needed to admin DB2 on AIX compared to 100% SQL on i5/OS?

And System i has had "just in time index builds" for ever.  They were called
temporary indexes in CQE and are now called Maintained Temporary Indexes
(MTIs - V5R4).  MTIs are now shared by all jobs on the system.

how do MTIs work? Does the system retain ( and maintain ) them once
they are no longer in use? A programmer or sys admin should not have
to keep track of the indexes the database needs to satisfy all the
queries being thrown at it. That is the job of a ton of system code
that runs on a modern, market priced, quad core system.

http://www-03.ibm.com/systems/p/hardware/entry/520q/91311k7a.html

-Steve