Previous Topic

Next Topic

dbmsinfo( ) Function—Request Information from a Database

The dbmsinfo( ) function is an SQL function that is used to request information from a database.

This function has the following syntax:

dbmsinfo (request_name)

Request names for the dbmsinfo function that are supported by Ingres Star are shown here:

Request Name

Response Description

autocommit_state

Returns 1 if autocommit is on; 0 if autocommit is off.

_bintim

Returns the current time and date in an internal format, represented as the number of seconds since January 1, 1970, 00:00:00 GMT.

_bio_cnt

Returns the number of I/Os made by Ingres Star and all currently connected local DBMSs. Ingres Star returns "0" for this argument.

_cpu_ms

Cpu time for session in milliseconds. Ingres Star returns 0 for this argument.

database

Returns the database name.

dba

User name of the distributed database owner.

dbms_bio

Returns the number of buffered I/O requests for all connected sessions. Ingres Star returns 0 for this argument.

dbms_cpu

Returns the cumulative CPU time for the local DBMS, in milliseconds, for all connected sessions. Ingres Star returns 0 for this argument.

dbms_dio

Returns the number of direct I/O requests for all connected sessions. Ingres Star returns 0 for this argument.

_dio_cnt

Disk I/O requests made by Ingres Star and all currently connected local DBMSs. Ingres Star returns 0 for this argument.

_et_sec

Returns the elapsed time for session, in seconds.

language

Returns the language used in the current session to display messages and prompts.

_pfault_cnt

Page fault count for Ingres Star and all currently connected local DBMSs. Ingres Star returns 0 for this argument.

query_language

Returns 'sql' or 'quel'.

server_class

Returns the class of local DBMS, for example 'ingres'.

terminal

Returns the terminal address.

transaction_state

Returns 1 if presently in a transaction, 0 if not.

username

User name of the client connected to Ingres Star.

_version

Current version number of the Ingres Star process.

These request names are case insensitive. When you run a query against an Ingres local DBMS, the dbmsinfo() function always returns a varchar(32) as the result. When you run a query against a Star Server, the dbmsinfo() function returns a varchar of the length of the response.

The following query returns a variable length string containing the answer, for example, 1:

select i=dbmsinfo('transaction_state');

For more information on dbmsinfo( ), see the SQL Reference Guide.


© 2007 Ingres Corporation. All rights reserved.