Neoview ODBC Drivers Manual (R2.2)

Traces
You can trace activity for the ODBC client. The following data is collected:
• Entry and exit calls to the HP Neoview ODBC drivers
• Contents of the buffers, except password buffers
• Activity between the HP Neoview ODBC drivers and the transport layer
Using the Driver With a Third Party Driver Manager
For questions related to your third party driver manager, refer to your driver manager's
documentation.
You must configure the following data source attributes. For an example of configuration values,
refer to the MXODSN file template provided with the installation. This is an example:
DESCRIPTION = Default Data Source
Catalog = CAT
Schema = SCH
DataLang = 0
FetchBufferSize = SYSTEM_DEFAULT
Server = TCP:arc0101.caclab.cac.cpqcorp.net:5000
SQL_ATTR_CONNECTION_TIMEOUT = SYSTEM_DEFAULT
SQL_LOGIN_TIMEOUT = SYSTEM_DEFAULT
SQL_QUERY_TIMEOUT = NO_TIMEOUT
INFOSTATS Command
INFOSTATS is a pass-through command that collect 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.
26 HP Neoview ODBC Drivers Overview for Linux, HP-UX, and IBM AIX®