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_DIRECTO RY 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, sqloPdbConnectS ocket, 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 3 5025
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_DIRECTO RY 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, sqloPdbConnectS ocket, 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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Rami Saarinen |
last post by:
I have been making a client-server type of software mainly on Linux and
now I am trying to get it all work also on windows. However, I am having
slight problems running the program in Windows 2000. I have tried Python
2.2.3 and the latest release 2.3.1 (?)
If I have 2 clients and 1 server. The server listening some predefined
port and all...
|
by: DJJ |
last post by:
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL
tables to a Microsoft Access 2003 database. I am finding that the data from
the MySQL tables takes a hell of a long time to load making any kind linkage
with my Access data virtually useless.
I have the MySQL driver setup in as a USER DSN. The MySQL data is...
|
by: Steve D |
last post by:
We are using a UDB 8.1 client on a Windows 2003 server, standard
edition. We are seeing slow connection response times (27 seconds) on
the first attempt and second attempt is great (< 1 second). The
Windows server uses a DSN that points to a Linux server with DB2 on
it.
We see the same problem when we bring up a DB2 command window on the...
|
by: B B |
last post by:
Okay, here is what's happening:
I have a reasonably fast laptop (1.4 GHz Mobile M, so comparable to 2.5GHz
P4) doing .net development.
Running Windows XP pro, SP2
IIS is installed and running fine
All SQL Servers I am referring to share a small (10 computers or so) LAN
with a 100MB Switch.
No other computers on the LAN exhibit this...
|
by: MadMan2004 |
last post by:
Hello all!
I'm having a problem with a project I'm working on and I'd like to ask
for anyone's input that might be helpful. I'm building a rather large
front-end application connecting to an AS400 for the back end database
and I'm experiencing slow response times when executing sql statements.
Some select statement response times are bad. ...
| |
by: Michal Seidl |
last post by:
Hi,
I am trying to download data from remote ftp server connected through
GSM modem. The speed is slow 1kB/s. Despite the classic linux ftp
client works fine the ftp.retrbinary(),ftpretrlines() function from
ftplib hangs. I am able succesfuly login but a can not download. It has
probably something common with sockets.
Code:...
|
by: One |
last post by:
Hi guys - I have a problem after a client clicks a Confirm button on a
form - the form processes the data, inserts into a database, and then
redirects using header Location.
I have tested this on two different Linux/Apache servers. One works
perfectly, the other takes about 90 seconds to redirect.
Has anyone seen this issue before ?
It...
|
by: getafixx |
last post by:
Hello everyone,
We have a linux server (Fedora core 7, default install, firewall turned off) and a bunch of windows XP machines on network/domain.
All machines are visible and I can get to both windows and linux by various methods.
We are trying to resolve a problem of not being able to connect to the linux box from the xp machines using...
|
by: Christian Welzel |
last post by:
Hi there
i set up php+db2+zend+apache2 on my linux server (debian/etch amd) and
have great problems with the performance of queries. I currently have
50 empty tables and 2 filled ones (one with 11 rows, the other with 60)
if i issue a simple "select * from table1" (11 results), its takes up to
6 seconds to get the result. Other dynamic pages,...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |