Re: IBM DB2 speed issues: why so slow?

There can be many reasons for this. Here are a few to look into. Whenever you stop/start DB2, the first connection will experience a significant overhead if an activate database command was not issued prior to this connection. The activate database command will allocate buffers, start certain services, etc. Another reason could be the lack of buffer space for your database. Depending on how big the rows are that you are selecting, the default buffer space (I assume you used the default when you installed DB2 also known as UDB) might not be big enough. Check how many services are started when UDB is started (database manager configuration parameter num_initagents). The default is 0. You might want to change this to a number the equals the initial number of connections to your database. Allocating these agents is overhead too. These are just a few biggies to start looking into. I suggest you either consult a DBA (if you have one) or access the following site for additional information: http://www-4.ibm.com/cgi-bin/software/db2www/library/pubs.d2w/report?uid=UNK NOWN&pwd=&search_type=SIMPLE&r_host=&last_page=list.d2w You neglected to say what platform UDB is running on and what version of UDB you are running. I am assuming Linux. -----Original Message----- From: Tyson Lloyd Thwaites <tysonlt@webmedia.com.au> To: php-db@lists.php.net <php-db@lists.php.net> Date: Tuesday, January 02, 2001 10:17 PM Subject: [PHP-DB] IBM DB2 speed issues: why so slow? >Hi, > >I am currently looking at IBM DB2 as a possible DB, but simple queries are >taking up to a second to run! It takes approx. 6 seconds to bring a page up that >connects to and queries a simple table, and about 1 second per query after that. > >Does anyone have any experience with DB2? Is there some vital tuning I have left >out? > >-- > >Regards, > >Tyson Lloyd Thwaites >I.T&e eCommerce Division >Adelaide >www.ite.com.au > > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net > >