469,600 Members | 2,642 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,600 developers. It's quick & easy.

slow connection to DB2/LINUX 8.2.3

jku
Hello,

after installing DB2 V8.2.3 on OpenSuse 10.1 (in vmware)
we have created a database instance with the restore command:
db2 "restore database $OLD_DB user db2inst1 using db2inst1 from
$BACKUP_DIRECTORY taken at $TS into $DB".

We have activated the database but the first connection is still slow.
db2 connect to <db_name>

In the db2diag.log there are the following entries:
2006-11-14-22.53.17.852588+060 E6171935G798 LEVEL: Error (OS)
PID : 3811 TID : 2955049888 PROC : db2hmon
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloPdbConnectSocket, probe:20
MESSAGE : ZRC=0x810F0019=-2129723367=SQLO_CONN_REFUSED "Connection
refused"
CALLED : OS, -, connect OSERR: ECONNREFUSED
(111)
DATA #1 : String, 32 bytes
Unable to connect socket on path
DATA #2 : socket, 4 bytes
6
DATA #3 : sockaddr, 41 bytes
0xB021CBE4 : 0100 2F68 6F6D 652D 6C6F 6361 6C2F 6461
.../home-local/da
0xB021CBF4 : 7375 7372 2F64 6173 2F74 6D70 2F64 6173
susr/das/tmp/das
0xB021CC04 : 6E61 6D65 6470 6970 65 namedpipe
DATA #4 : File name, 39 bytes

DAS server is not running. Is this server needed?

Thank you!
Jörn

Nov 14 '06 #1
3 4815
The first connection to a db will always be slow because it needs to
start services, open files, create logs, allocate memory, ... Stuff you
don't need to do for a second connect.
Check if subsequent connects are as slow as the first, and if not, you
could force a 'dummy' connect after each db2start, so your users won't
notice.
jku schreef:
Hello,

after installing DB2 V8.2.3 on OpenSuse 10.1 (in vmware)
we have created a database instance with the restore command:
db2 "restore database $OLD_DB user db2inst1 using db2inst1 from
$BACKUP_DIRECTORY taken at $TS into $DB".

We have activated the database but the first connection is still slow.
db2 connect to <db_name>

In the db2diag.log there are the following entries:
2006-11-14-22.53.17.852588+060 E6171935G798 LEVEL: Error (OS)
PID : 3811 TID : 2955049888 PROC : db2hmon
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloPdbConnectSocket, probe:20
MESSAGE : ZRC=0x810F0019=-2129723367=SQLO_CONN_REFUSED "Connection
refused"
CALLED : OS, -, connect OSERR: ECONNREFUSED
(111)
DATA #1 : String, 32 bytes
Unable to connect socket on path
DATA #2 : socket, 4 bytes
6
DATA #3 : sockaddr, 41 bytes
0xB021CBE4 : 0100 2F68 6F6D 652D 6C6F 6361 6C2F 6461
../home-local/da
0xB021CBF4 : 7375 7372 2F64 6173 2F74 6D70 2F64 6173
susr/das/tmp/das
0xB021CC04 : 6E61 6D65 6470 6970 65 namedpipe
DATA #4 : File name, 39 bytes

DAS server is not running. Is this server needed?

Thank you!
Jörn
Nov 16 '06 #2

www.spaceboot.eu wrote:
The first connection to a db will always be slow because it needs to
start services, open files, create logs, allocate memory, ... Stuff you
don't need to do for a second connect.
Check if subsequent connects are as slow as the first, and if not, you
could force a 'dummy' connect after each db2start, so your users won't
notice.
But he activated the database and that should take care of this, or am
I missing something?
/Lennart

Nov 17 '06 #3
How about NUM_INITAGENTS - Initial number of agents in pool? I believe
it defaults to zero, but if it's nonzero then some agents are primed and
ready for action, reducing delays on the first connections.
(Does that make them secret agents? I always thought this was an
amusing parameter :-)

Lennart wrote:
www.spaceboot.eu wrote:
>>The first connection to a db will always be slow because it needs to
start services, open files, create logs, allocate memory, ... Stuff you
don't need to do for a second connect.
Check if subsequent connects are as slow as the first, and if not, you
could force a 'dummy' connect after each db2start, so your users won't
notice.


But he activated the database and that should take care of this, or am
I missing something?
/Lennart
Nov 17 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Rami Saarinen | last post: by
11 posts views Thread by DJJ | last post: by
reply views Thread by Michal Seidl | last post: by
5 posts views Thread by One | last post: by
3 posts views Thread by Christian Welzel | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.