Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQ_REASSOC

5 views
Skip to first unread message

Igor Zaiets

unread,
Jan 24, 2011, 10:38:39 AM1/24/11
to
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

Jonathan Leffler

unread,
Jan 24, 2011, 10:45:54 AM1/24/11
to Igor Zaiets, Informix List - IIUG
 

From a document on SQLI...

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...@gmail.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."

Igor Zaiets

unread,
Jan 24, 2011, 10:58:32 AM1/24/11
to
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...@gmail.com>
wrote:

> Jonathan Leffler <jonathan.leff...@gmail.com>  #include <disclaimer.h>
> Guardian of DBD::Informix - v2008.0513 -http://dbi.perl.org

Jonathan Leffler

unread,
Jan 24, 2011, 11:16:36 AM1/24/11
to Igor Zaiets, inform...@iiug.org


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.
 
What is a link for document on SQLI..?

There are documents that are not on the internet.


--
Jonathan Leffler <jonathan...@gmail.com>  #include <disclaimer.h>
Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org
0 new messages