IBM IDS 11.50FC5W2
Sun Solaris 10

What is SQ_REASSOC in sqliprint output?

S->C (24) PREV CMD Time: 0.00244 Time: 2011-01-24
13:56:15.39550
SQ_REASSOC
Server Name....: "" [0]
Database Name..: "my_database" [5]
Statement type.: 0 [0]
Statement Opts.: 33554432 [0x2000000]
Db Location....: "" [0]
Logfile path...: "" [0]
SQ_EOT

C->S (8) PREV CMD Time: 9.40867 Time: 2011-01-24
13:56:24.80417
SQ_DISCONNECT


Client appl. - 4GL

On Mon, Jan 24, 2011 at 07:38, Igor Zaiets <zaiets.komus (AT) gmail (DOT) com> wrote:


SQ_REASSOC

Sent from the server which is processing a database statement (create
database, drop database or database statement). There is a different server
specified in the database statement, this information is passed back to
SQLI, so SQLI can make a “secret” connection to this server. Examples:
client executes “database db2@server2” but is currently connected to
server1; the database specified is not on the current server and DBPATH is
set.

--
Jonathan Leffler <jonathan.leffler (AT) gmail (DOT) com> #include <disclaimer.h>
Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."

Thanks
Yes, in debug output before this operator:
C->S (22) PREV CMD Time: 0.00055 Time: 2011-01-24
13:56:24.81054
SQ_PREPARE
# values: 1
CMD.....: "database ?" [10]
SQ_NDESCRIBE
SQ_WANTDONE
SQ_EOT
.....
C->S (38) PREV CMD Time: 0.00016 Time: 2011-01-24
13:56:24.81241
SQ_ID
0
SQ_BIND
# values: 1
0) Type.....: CHAR; NULLABLE
Indicator: NOT NULL
Precision: 0x0
Data.....: "bluebird " [18]

SQ_EXECUTE
SQ_EOT

S->C (26) PREV CMD Time: 0.00287 Time: 2011-01-24
13:56:24.81528
SQ_REASSOC


When CMD Time of SQ_REASSOC is very long(>10 sec.) - this performance
problem of my IDS or error/defect IDS Software?

What is a link for document on SQLI..?



On Jan 24, 5:45*pm, Jonathan Leffler <jonathan.leff... (AT) gmail (DOT) com>
wrote:

On Mon, Jan 24, 2011 at 07:58, Igor Zaiets <zaiets.komus (AT) gmail (DOT) com> wrote:


Usually, if there is a 10 second delay, it means there is a problem with the
networking infrastructure in some shape or form - DNS or something similar.
It seems that the client (I4GL) code took almost 10 seconds to decide to
disconnect from the current server and connect to the other.


There are documents that are not on the internet.





--
Jonathan Leffler <jonathan.leffler (AT) gmail (DOT) com> #include <disclaimer.h>
Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."