PHP : Function Reference : IBM DB2, Cloudscape and Apache Derby Functions : db2_server

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().

<?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:

copy to clipboard

DBMS_NAME: string(9) "DB2/LINUX"

DBMS_VER: string(10) "08.02.0000"

DB_CODEPAGE: int(1208)

DB_NAME: string(6) "SAMPLE"

INST_NAME: string(8) "db2inst1"

SPECIAL_CHARS: string(2) "@#"

KEYWORDS: int(179)

DFT_ISOLATION: string(2) "CS"

ISOLATION_OPTION: string(12) "UR CS RS RR "

SQL_CONFORMANCE: string(7) "FIPS127"

PROCEDURES: bool(true)

IDENTIFIER_QUOTE_CHAR: string(1) """

LIKE_ESCAPE_CLAUSE: bool(true)

MAX_COL_NAME_LEN: int(30)

MAX_ROW_SIZE: int(32677)

MAX_IDENTIFIER_LEN: int(18)

MAX_INDEX_SIZE: int(1024)

MAX_PROC_NAME_LEN: int(128)

MAX_SCHEMA_NAME_LEN: int(30)

MAX_STATEMENT_LEN: int(2097152)

MAX_TABLE_NAME_LEN: int(128)

NON_NULLABLE_COLUMNS: bool(true)

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 )

Example 952. A db2_server_info() example

Change Language

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 )

Example 952. A db2_server_info() example

Change Language

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 )