Prev: SQL error 805
Next: Packages (Package "NULLID.SYSLH214 0X5359534C564C3031" was notfound.)
From: jku on 14 Nov 2006 06:41
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

From: www.spaceboot.eu on 16 Nov 2006 11:51
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

From: Lennart on 17 Nov 2006 15:17

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

From: Greg Nash on 17 Nov 2006 17:18
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
>
 | 
Pages: 1
Prev: SQL error 805
Next: Packages (Package "NULLID.SYSLH214 0X5359534C564C3031" was notfound.)