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:

• DB2 Compression Threshold: DB2 9.x can perform row level data compression. Domino automatically leverages this capability. This setting displays if compression is enabled. The value in this field defines the size (in bytes) at which a table becomes eligible for compression. Domino manages this compression.
• DB2 Access Server Version: Version of the DB2 Access server if installed. This is useful information if you have a support issues.
• Enable Default Query View User: Indicates that the Default Query View user feature is enabled. Use this feature if you use query views because it eliminates the need to have specific IBM® Lotus® Notes® user to DB2 User mappings.
• Default Query View User Name: Name used to execute query views in DB2. This field displays the DB2 user name that will be used to execute DB2 stored procedures. This does not affect Notes ACL checks on DB2 data.

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 Access	Enabled
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:

Name	Description	Values	Source
DB2 Server	Is this server enabled for IBM® DB2® UDB™ storage?	Enabled Not Enabled	Server document
DB2 Server	The DB2 server's name or IP address.	Local Host name	Server document
DB2 Port Number	Number specific to the remote DB2 server.	Port number Blank	Server document
DB2 instance	Instance name used by Domino	Varies	Server document
DB2 Node Name	Node name used by Domino to access DB2 on a remote DB2 server	Varies	Server document
DB2 Database	DB2 database where Domino databases are stored	Varies	Server document
DB2 Directory	Where DB2 creates data related to DB2 tables used to store Domino databases	Varies	Server document
DB2 Schema Version	DB2 schema version used when creating or upgrading Domino system tables in DB2.	Varies	Server document
Default Domino Database Storage Type	Default storage type for Domino databases.	DB2 NSF	Server document
DB2 Access Server Name	Used to store Domino Access tables for access by DB2 applications.	Varies	Server document
DB2 Access Server path	Path used to store Access Server files.	Varies	Server document
DB2 Code Page	DB2 database code page.	Varies	Server document
DB2 Locale	Db2 database locale.	Varies	Server document
Connected to DB2	Whether or not Domino is connected to a DB2 server.	Yes No	Domino/DB2 Run-time
Connect Pool Count	Domino's DB2 (XA) transaction pool count.	Varies	Domino Run-time
DB2 Service Status	List of DB2 services and whether they have been started.		Operating System (Local configuration only.)

Related topics

Domino and DB2 server commands
Understanding Domino and DB2

Glossary