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: | The SVCENAME parameter, set by the installation program, cannot 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
Examples
The following is sample output from GET ADMIN CONFIGURATION:
Admin Server Configuration
Node type = Database Server with local and remote clients
Database manager configuration release level = 0x0900
Diagnostic error capture level (DIAGLEVEL) = 4
Diagnostic data directory path (DIAGPATH) =
SYSADM group name (SYSADM_GROUP) =
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) =
Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Query heap size (4KB) (QUERY_HEAP_SZ) = 250
TCP/IP Service name (SVCENAME) = 30676
APPC Transaction program name (TPNAME) =
IPX/SPX File server name (FILESERVER) =
IPX/SPX DB2 server object name (OBJECTNAME) =
IPX/SPX Socket number (IPX_SOCKET) = 87A2
Discovery mode (DISCOVER) = SEARCH
Discovery communication protocols (DISCOVER_COMM) = TCPIP
|
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