SQ_REASSOC
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."