#3 Use sqlbchkmem to get sqlb working infos

[Frédéric RUAUDEL]

sqlbchkmem is a utility program to get information
about the progress of sqlb working.

The useful syntax of it are :

1) sqlbchkmem -t dbtype -n dbname -qh

=> this command show you what the sqlbqueries doing :

Sqlbquery Infos :
----------------
* Sqlbquery n° 0 : PID 13339 - Job -1
* Sqlbquery n° 1 : PID 13340 - Job -1
* Sqlbquery n° 2 : PID 13341 - Job -1
* Sqlbquery n° 3 : PID 13342 - Job -1
* Sqlbquery n° 4 : PID 13343 - Job 346
* Job n°346 :
Query : "SELECT ID,NAME from Etat where
(ID='11' or Master='13')"
Sqlbquery PID: 13343 - Client Socket :
"/home/sqlb/.sqlbclient20969.sock"
Number of retries allowed : 1
Next Job : -1
* Sqlbquery n° 5 : PID -1 - Job -1
* Sqlbquery n° 6 : PID -1 - Job -1

- For sqlbquery n° 0, 1, 2 and 3, we have the PID of
the sqlbquery already launched and job = -1 means that
they are doing no job at this moment. But when we send
only very quick request, sqlbquery always show you
job=-1 (see next command to have more infos to check if
sqlbqueires work)

- For sqlbquery n°4, we can see the job currently
managed. The number in the socket name is the PID of
the client. If you see very often all the sqlbqueries
in this state, it's a sign of saturation, so check that
your queries are not too slow to execute.

- For sqlbquery n°5 and 6, we have PID = -1, it means
that this slot is free to welcome a new sqlbquery if
the load become too heavy.

2) sqlbchkmem -t oracle -n staterp -lh

=> this command displays the state of the job lists.

Header lists infos :
-------------------
* Free jobs header : Head 14 - Tail 13
-> Number of free jobs : 512
* Waiting jobs header : Head -1 - Tail -1
-> Number of waiting jobs : 0

- For a good sqlb working, you must have 0 waiting
jobs, and the number "Head" and "Tail" of the free jobs
header must change on every queries received.

- If the number of waiting jobs increases, you will see
new sqlbqueries launched by sqlb to try to decrease
this number to zero.