Neoview ODBC Drivers Manual (R2.5)

Compression is off by default. You can enable it:
• By setting compression = 1 in either the MXODSN file or the odbc.ini file.:
[TDM_Default DataSource]
Description = TDM_Default_DataSource
Catalog = NEO
Schema = ODBC_SCHEMA
DataLang = 0
FetchBufferSize = SYSTEM_DEFAULT
Server = TCP:wmb0101.tst.hp.com:3200
SQL_ATTR_CONNECTION_TIMEOUT = NO_TIMEOUT
SQL_LOGIN_TIMEOUT = SYSTEM_DEFAULT
SQL_QUERY_TIMEOUT = SYSTEM_DEFAULT
Compression = 1
• Or you can set compression = 1 in the connection string.
To turn compression off again, set it to 0(zero) or SYSTEM_DEFAULT.
IMPORTANT: Neoview systems before Release 2.5 do not support compression. Enabling
compression for an ODBC connection to a release of Neoview previous to Release 2.5 can cause
undefined behavior.
INFOSTATS Command
INFOSTATS is a pass-through command that collects statistics for a prepared statement. Statistics
are returned to the ODBC application as a result set as soon as the PREPARE is finished. The
result set has these columns:
• Query ID (SQL_CHAR)
• CPUTime (SQL_DOUBLE): An estimate of the number of seconds of processor time it might
take to execute the instructions for this query. A value of 1.0 is 1 second.
• IOTime (SQL_DOUBLE): An estimate of the number of seconds of I/O time (seeks plus data
transfer) to perform the I/O for this query.
• MsgTime (SQL_DOUBLE): An estimate of the number of seconds it takes for the messaging
for this query. The estimate includes the time for the number of local and remote messages
and the amount of data sent.
• IdleTime (SQL_DOUBLE): An estimate of the maximum number of seconds to wait for an
event to happen for this query. The estimate includes the amount of time to open a table or
start an ESP process.
• TotalTime (SQL_DOUBLE): Estimated cost associated to execute the query.
• Cardinality (SQL_DOUBLE): Estimated number of rows that will be returned.
INFOSTATS {stmt-name | cursor-name | sql-stmt }
A pass-through command that collect statistics for a prepared statement.
stmt-name
is the name of a prepared statement. If a case-sensitive statement name is used, you must
enclose it in either single quotes or double quotes.
cursor-name
is an SQL identifier. The name is unique within the containing module or compilation unit.
The maximum length of a cursor name is 128 characters. If a case-sensitive cursor name is
used, you must enclose it in either single quotes or double quotes.
sql-stmt
is any valid SQL query surrounded by either single quotes or double-quotes.
INFOSTATS Command 43