Returns the values of individual entries in the database manager configuration file that are relevant to the DB2 Administration Server. The DB2 Administration Server is a special DB2 instance that enables remote administration of DB2 servers. The following database manager configuration parameters are displayed:
| Note: | It is not recommended that the SVCENAME parameter, set by the installation program, be modified by the user. The administration server service name is set to use the DB2 registered TCP/IP port (523). |
For more information about these parameters, see GET DATABASE MANAGER CONFIGURATION.
Scope
This command returns information on all nodes that share the same $HOME/sqllib directory, and can be issued from any of these nodes.
Authorization
None
Required Connection
None or instance. An instance attachment is not required to perform local DBM configuration operations, but is required to perform remote DBM configuration operations. To display the database manager configuration for a remote instance, it is necessary to first attach to that instance.
Command Syntax
>>-GET ADMIN---+-CONFIGURATION-+-------------------------------><
+-CONFIG--------+
+-CFG-----------+
|
Command Parameters
None
Example
The following is sample output from GET ADMIN CONFIGURATION:
Admin Server Configuration
Node type = Database Server with local clients
Database manager configuration release level = 0x0800
Diagnostic error capture level (DIAGLEVEL) = 3
Diagnostic data directory path (DIAGPATH) =
SYSADM group name (SYSADM_GROUP) = BUILD
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) =
Database manager authentication (AUTHENTICATION) = SERVER
Query heap size (4KB) (QUERY_HEAP_SZ) = 1200
Discovery mode (DISCOVER) = KNOWN
Discovery communication protocols (DISCOVER_COMM) =
|
Usage Notes
If an attachment to a remote instance (or a different local instance) exists, the admin configuration parameters for the attached server are returned; otherwise, the local admin configuration parameters are returned.
If an error occurs, the information returned is not valid. If the configuration file is invalid, an error message is returned. The user must install the database manager again to recover.
To set the configuration parameters to the default values shipped with the database manager, use RESET ADMIN CONFIGURATION.
For more information about these parameters, see the Administration Guide.
See Also
RESET ADMIN CONFIGURATION
REFID='T2'.