Chat now with support
Chat with Support

Spotlight on DB2 6.9.3 - User Guide

Spotlight on IBM DB2 LUW (Linux, Unix, and Windows)
New in This Release Getting started with Spotlight on IBM DB2 LUW Desktop features specific to Spotlight on IBM DB2 LUW Spotlight on IBM DB2 LUW drilldowns
About Spotlight on IBM DB2 LUW drilldowns Buffer Pool Analysis drilldown Client Application Analysis drilldown Database Analysis drilldown Database Manager Summary drilldown Diagnostic Log drilldown FCM Analysis drilldown Tablespace Analysis drilldown Top SQL drilldown Operating System drilldown Workload Management Analysis drilldown
Spotlight on IBM DB2 LUW alarms Spotlight on IBM DB2 LUW Options Tuning SQL statements in Spotlight on IBM DB2 LUW
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

Instance identification panel

The Instance Identification panel lists information about the monitored instance. The following illustration shows a sample Instance Identification panel.

Review the following for additional information about the items listed about the monitored instance:

Item Description
Name The name as it is known on the server—of the DB2 instance you are currently monitoring.
Node The name in the database manager configuration file at the client node.
Type

One of the following DB2 node types are shown in this field:

  • Local and remote clients — A server side product with local and remote support for database clients. This node type can also access remote database servers.
  • Requestor — A database client that can access remote database servers.
  • Local clients — A database management system with local support for database clients. This node type can also access remote database servers.
  • Partitioned server — A server side product with local and remote support for database clients. This node type can also access remote database servers and has partition parallelism capability.
  • Satellite — A database management system with local support for database clients. This node type can also access remote database servers.
Product The DB2 name and version number.
Release The product code and version number for the DB2 client system on which the application is running.
Server Level

The IBM build and PTF (Program Temporary Fix) levels of the current DB2 server and client. These numbers can be used to determine your fixpak level.

  • Build level—The alphanumeric number not in parentheses is the build level of the DB2 code you are currently using.
  • PTF level—The alphanumeric number in parentheses is the PTF level of the code.

Determining IBM fixpak levels

To check if your system is at the latest fixpak , run the db2level command on both the client and the server where the database resides.

Note: You can execute this command from a DB2 command window. (On Unix or Linux platforms, you would run the command from the login prompt of your instance user ID.) This command will not run in the Command Line Processor ( CLP ).

Once you have determined the fixpak level of your system, go to the following web page to ensure that this is the latest fixpak of DB2. If it is not, you should upgrade.

http:// www.ibm.com /support

Server PTF The IBM PTF (Program Temporary Fix) level of the current DB2 server and client.
Server Fixpack The IBM level of the current DB2 server fix pack. If a fix pack is not installed, 0 (zero) is shown.
Server Bit Architecture The size of the bit strings supported by the server processor. For example, 32 is shown for 32-bit processors; 64 is shown for 64-bit processors.
Partitions The total number of partitions used by all the databases within the current instance.
Start

The timestamp showing when the database manager was started via the DB2START command.

The timestamp uses the following format:

year-month-day

hour:minutes:seconds.microseconds

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating