If this is happening on your first connection, check the logfilsiz and
log_primary, it they are set to large value it takes time to create those
many log files with the size specified in the logfilsiz parameter.

Once the DB2 is started, I would suggest you do "activate db <dbname>" this
will reduce the connection time for all other connections and you should be
able connect much faster.

Kondal R. Yennaram




"pavan"
<db2udbdba-ezmlms
hield-x68247630.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
08/30/2006 10:38
AM Subject
connecting to a db.














HI all,
There is a brand new database on our test server with lots of data on it.
When I issue connect command to this db, it takes more time to connect
than other dbs on the same server.
What factors might need tuning to make sure that the time is optimal to
connect ? There are no others users connecting to this db as of now; so, no
of connections is not an issue that might affect the timing. any help ?
thanks.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page