SQ_REASSOC
Igor Zaiets asked what SQ_REASSOC means in sqliprint output on IDS 11.50FC5 with a 4GL client, and whether a 10-second delay is a problem. Jonathan Leffler explained the server sends it for a database statement naming another server so the client can connect there. He said long delays usually point to network or DNS problems, and here the client code took nearly 10 seconds to reconnect.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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@gmail.com> wrote: > 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 > >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.leffler@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."
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: > On Mon, Jan 24, 2011 at 07:38, Igor Zaiets <zaiets.ko...@gmail.com> wrote: > > 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 > > >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.leff...@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."
On Mon, Jan 24, 2011 at 07:58, Igor Zaiets <zaiets.komus@gmail.com> wrote: > 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? > 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. > On Jan 24, 5:45 pm, Jonathan Leffler <jonathan.leff...@gmail.com> > wrote: > > On Mon, Jan 24, 2011 at 07:38, Igor Zaiets <zaiets.ko...@gmail.com> > wrote: > > > 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 > > > > >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.leffler@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."