DB2 Info
Syntax:

DB2 info

Description:

Provides detail information about the IBM® Lotus® Domino® and IBM® DB2 Universal Database™ Enterprise Server Edition configuration. The DB2 information includes the following:


Example:

For example, if you enter the DB2 INFO command from an IBM® AIX® configuration, the output from the command would resemble this sample output:
DB2 Server: Enabled
DB2 Server:Connected
DB2 Server Name: serverone.ibm.com
DB2 Port Number: 50000.00
DB2 Version:v9.1.0
DB@ Compression Threshold:1062000.00
DB2 Directory:
DB2 Instance:aixnode
DB2 Database:DOMINO
Default Datastore:2.00
Connections:4.00
Max NSFs per Group:10.00
Schema Version: 14.00
DB2 AccessEnabled
DB2 Access Server:humacc
DB2 Access Server Version
DB2 Access Path:/local1/domudf
Enable Default Query View User:1.00
Default Query View User Name:DOMDEFUSER

The DB2 INFO command produces a list containing the following information:
NameDescriptionValuesSource
DB2 ServerIs this server enabled for IBM® DB2® UDB™ storage?Enabled

Not Enabled

Server document
DB2 ServerThe DB2 server's name or IP address.Local

Host name

Server document
DB2 Port NumberNumber specific to the remote DB2 server.Port number

Blank

Server document
DB2 instanceInstance name used by DominoVariesServer document
DB2 Node NameNode name used by Domino to access DB2 on a remote DB2 serverVariesServer document
DB2 DatabaseDB2 database where Domino databases are storedVariesServer document
DB2 DirectoryWhere DB2 creates data related to DB2 tables used to store Domino databasesVariesServer document
DB2 Schema VersionDB2 schema version used when creating or upgrading Domino system tables in DB2.VariesServer document
Default Domino Database Storage TypeDefault storage type for Domino databases.DB2

NSF

Server document
DB2 Access Server NameUsed to store Domino Access tables for access by DB2 applications.VariesServer document
DB2 Access Server pathPath used to store Access Server files.VariesServer document
DB2 Code PageDB2 database code page.VariesServer document
DB2 LocaleDb2 database locale.VariesServer document
Connected to DB2Whether or not Domino is connected to a DB2 server.Yes

No

Domino/DB2 Run-time
Connect Pool CountDomino's DB2 (XA) transaction pool count.VariesDomino Run-time
DB2 Service StatusList of DB2 services and whether they have been started.Operating System

(Local configuration only.)

Related topics