RE: [DB2EUG] Very slow connect to database

[Dimoline, Simon]

Title: Very slow connect to database

Thank-you, all replies

It seems to be every time I connect. I used the activate command but it comes back with 'SQL1490W Activate database is successful, however, the database has already been activated on one or more nodes. ' Sorry should have mentioned that.

Possibly I have a problem with buffers or some other configuration parameter. I will check. Any other ideas?

Simon.

-----Original Message-----
From: Helen Johnson [mailto:[EMAIL PROTECTED]]
Sent: 16 April 2002 16:48
To: Dimoline, Simon
Subject: RE: [DB2EUG] Very slow connect to database

Try activating the database so the buffers, etc. are allocated and don't have to be allocated with each connect.

-----Original Message-----
From: Dimoline, Simon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 10:16 AM
To: Db2eug (E-mail 2)
Subject: [DB2EUG] Very slow connect to database

AIX 4.3.3 and DB2 v5.2
Can anyone help,
Using the command 'connect to database' (on an installation of db2 newly set up) the command seems to take forever.  This is on a telnet session and the database is on the same machine. Has anyone had a similar problem and solved or any ideas very welcome.

Many thanks,
Simon.



"This communication is intended solely for the addressee and is confidential and not for third party unauthorised distribution."




"This communication is intended solely for the addressee and is confidential and not for third party unauthorised distribution."