I have two problems ...

1. Why is my db-server (dbserv11) under Linux (RedHat Linux) lasting around
20% CPU usage ... although nothing should happen on the database. There is
no client connected and it does not run batch jobs from me.

2. How I can get out of a Linux script to test whether a database /
db-server is started. Dbping I wanted to use it. However, I do not come so
clear to the query return value.

Any ideas?

I made a mistake ...
the dbserver runs in a VM on an 8-core system and the VM creates lasting
usage around 20%.
'top' certifies dbserv11 an occupancy rate of 160 - 170% (on a VM with 2
cores)


<Ingmar> schrieb im Newsbeitrag news:4b1ce6cc (AT) forums-1-dub (DOT) ..

Hi Ingmar,

I'm not sure that I understand your clarification. Are you indicating
that the VM itself is occupying 20% CPU and the database server is
remaining idle as it should? Or are you still seeing a problem?

As for #2. You can use the dbping utility to check for the existence of
a database server from a script. The dbping utility finishes with a 0
exit status when the requested server is found. You can use this in the
usual way to take action when the dbping utility finds a running server.
For example in bourne shell:

dbping -q -c "eng=myserver" && echo "server found"

or

dbping -q -c "eng=myserver"
if [ $? -eq 0 ] ; then
echo "server found"
fi

will only output "server found" to the console if dbping can contact
"myserver".

Nathan Auch
Sybase iAnywhere

Ingmar wrote:

Hi Nathan,

I have still the problem...
The second message was an additional message that dbserv11 not consumed only
20% ... 20% only of the 8 CPUs of the server-node.

Within the VM (VM has 2 CPU) 'top' certifies an occupancy rate of 160-170%.

Clear now?

Thx for answer #2.


"Nathan Auch [Sybase]" <nauch (AT) sybase (DOT) com> schrieb im Newsbeitrag
news:4b1d0d15$1 (AT) forums-1-dub (DOT) ..

Hi Ingmar,

Are you able to connect to the database server? Can you call the
sa_conn_info() procedure and see if anything is reported?

Nathan Auch
Sybase iAnywhere

Ingmar wrote: