db2_server_info

Returns an object with properties that describe the DB2 database server (PECL ibm_db2:1.1.1-1.6.2)
object db2_server_info ( resource connection )

This function returns an object with read-only properties that return information about the IBM DB2, Cloudscape, or Apache Derby database server. The following table lists the database server properties:

Table 127. Database server properties

Property name	Return type	Description
DBMS_NAME	string	The name of the database server to which you are connected. For DB2 servers this is a combination of `DB2` followed by the operating system on which the database server is running.
DBMS_VER	string	The version of the database server, in the form of a string "MM.mm.uuuu" where `MM` is the major version, `mm` is the minor version, and `uuuu` is the update. For example, "08.02.0001" represents major version 8, minor version 2, update 1.
DB_CODEPAGE	int	The code page of the database to which you are connected.
DB_NAME	string	The name of the database to which you are connected.
DFT_ISOLATION	string	The default transaction isolation level supported by the server: UR Uncommitted read: changes are immediately visible by all concurrent transactions. CS Cursor stability: a row read by one transaction can be altered and committed by a second concurrent transaction. RS Read stability: a transaction can add or remove rows matching a search condition or a pending transaction. RR Repeatable read: data affected by pending transaction is not available to other transactions. NC No commit: any changes are visible at the end of a successful operation. Explicit commits and rollbacks are not allowed.
IDENTIFIER_QUOTE_CHAR	string	The character used to delimit an identifier.
INST_NAME	string	The instance on the database server that contains the database.
ISOLATION_OPTION	array	An array of the isolation options supported by the database server. The isolation options are described in the DFT_ISOLATION property.
KEYWORDS	array	An array of the keywords reserved by the database server.
LIKE_ESCAPE_CLAUSE	bool	`TRUE` if the database server supports the use of `%` and `_` wildcard characters. `FALSE` if the database server does not support these wildcard characters.
MAX_COL_NAME_LEN	int	Maximum length of a column name supported by the database server, expressed in bytes.
MAX_IDENTIFIER_LEN	int	Maximum length of an SQL identifier supported by the database server, expressed in characters.
MAX_INDEX_SIZE	int	Maximum size of columns combined in an index supported by the database server, expressed in bytes.
MAX_PROC_NAME_LEN	int	Maximum length of a procedure name supported by the database server, expressed in bytes.
MAX_ROW_SIZE	int	Maximum length of a row in a base table supported by the database server, expressed in bytes.
MAX_SCHEMA_NAME_LEN	int	Maximum length of a schema name supported by the database server, expressed in bytes.
MAX_STATEMENT_LEN	int	Maximum length of an SQL statement supported by the database server, expressed in bytes.
MAX_TABLE_NAME_LEN	int	Maximum length of a table name supported by the database server, expressed in bytes.
NON_NULLABLE_COLUMNS	bool	`TRUE` if the database server supports columns that can be defined as NOT NULL, `FALSE` if the database server does not support columns defined as NOT NULL.
PROCEDURES	bool	`TRUE` if the database server supports the use of the CALL statement to call stored procedures, `FALSE` if the database server does not support the CALL statement.
SPECIAL_CHARS	string	A string containing all of the characters other than a-Z, 0-9, and underscore that can be used in an identifier name.
SQL_CONFORMANCE	string	The level of conformance to the ANSI/ISO SQL-92 specification offered by the database server: ENTRY Entry-level SQL-92 compliance. FIPS127 FIPS-127-2 transitional compliance. FULL Full level SQL-92 compliance. INTERMEDIATE Intermediate level SQL-92 compliance.

Parameters

connection: Specifies an active DB2 client connection.

Return Values

Returns an object on a successful call. Returns FALSE on failure.

Examples

Example 952. A db2_server_info() example

To retrieve information about the server, you must pass a valid database connection resource to db2_server_info().

copy to clipboard

<?php


$conn = db2_connect('sample', 'db2inst1', 'ibmdb2');

$server = db2_server_info( $conn );


if ($server) {

    echo "DBMS_NAME: ";                 var_dump( $server->DBMS_NAME );

    echo "DBMS_VER: ";                  var_dump( $server->DBMS_VER );

    echo "DB_CODEPAGE: ";               var_dump( $server->DB_CODEPAGE );

    echo "DB_NAME: ";                   var_dump( $server->DB_NAME );

    echo "INST_NAME: ";                 var_dump( $server->INST_NAME );

    echo "SPECIAL_CHARS: ";             var_dump( $server->SPECIAL_CHARS );

    echo "KEYWORDS: ";                  var_dump( sizeof($server->KEYWORDS) );

    echo "DFT_ISOLATION: ";             var_dump( $server->DFT_ISOLATION );

    echo "ISOLATION_OPTION: ";

    $il = '';

    foreach( $server->ISOLATION_OPTION as $opt )

    {

       $il .= $opt." ";

    }

    var_dump( $il );

    echo "SQL_CONFORMANCE: ";           var_dump( $server->SQL_CONFORMANCE );

    echo "PROCEDURES: ";                var_dump( $server->PROCEDURES );

    echo "IDENTIFIER_QUOTE_CHAR: ";     var_dump( $server->IDENTIFIER_QUOTE_CHAR );

    echo "LIKE_ESCAPE_CLAUSE: ";        var_dump( $server->LIKE_ESCAPE_CLAUSE );

    echo "MAX_COL_NAME_LEN: ";          var_dump( $server->MAX_COL_NAME_LEN );

    echo "MAX_ROW_SIZE: ";              var_dump( $server->MAX_ROW_SIZE );

    echo "MAX_IDENTIFIER_LEN: ";        var_dump( $server->MAX_IDENTIFIER_LEN );

    echo "MAX_INDEX_SIZE: ";            var_dump( $server->MAX_INDEX_SIZE );

    echo "MAX_PROC_NAME_LEN: ";         var_dump( $server->MAX_PROC_NAME_LEN );

    echo "MAX_SCHEMA_NAME_LEN: ";       var_dump( $server->MAX_SCHEMA_NAME_LEN );

    echo "MAX_STATEMENT_LEN: ";         var_dump( $server->MAX_STATEMENT_LEN );

    echo "MAX_TABLE_NAME_LEN: ";        var_dump( $server->MAX_TABLE_NAME_LEN );

    echo "NON_NULLABLE_COLUMNS: ";      var_dump( $server->NON_NULLABLE_COLUMNS );


    db2_close($conn);

}
?>

The above example will output: