Performance Explorer Node

From DBArtisan
Jump to: navigation, search

Go Up to Understanding the Explorer Tree Hierarchy

This node provides access to a set of DBMS-specific performance-related objects.

Explorer node location

DBArtisan places the Performance node as the first level of information under the datasource node in the Explorer.

Sub-nodes and Platform Availability

Expanding this node provides access to the following nodes:

DB2 LUW DB2 z/OS MySQL ORCL PSTGRS * SQL SVR SYB ASE SYB IQ

Active Threads Node

✓

Blocking Locks Node

✓

✓

✓

Bufferpools

✓

✓

Connected Users Node

✓

Database Locks

✓

Event Monitors

✓

Image Copies

✓

Inactive Threads

✓

Indoubt Threads

✓

IQ Status Node

✓

Locks

✓

✓

✓

✓

✓

✓

✓

Performance Databases Node

✓

PL/SQL Code Profiling Node

✓

Postponed Threads Node

✓

Processes

✓

✓

✓

✓

✓

✓

Prepared Transactions

✓

Restricted Tablespaces

✓

Table Locks Node

✓

Traces

✓

Utilities

✓


For a support summary for the Event Monitors, Image Copies, and Buffer Pools object types, see Supported Objects.

The following topics provide details on all sub-nodes except the Event Monitors, Image Copies, and Buffer Pools nodes.

Note: For DB2 z/OS, performance is a result of the DB2 API calls. The DB2 API calls are subject to change depending on the version and DB2 SDK call interface of the DB2 server. Performances do not appear in the system catalog tables.

Active Threads Node

Active threads are the processes running on your database. When you select the Active Thread node on the Explorer, DBArtisan displays the active threads that are currently running on the IBM DB2 for z/OS and OS/390 database. To utilize all Database Monitor functionality, on the Utilities menu, select Database Monitor.

Platform availability and Explorer node location

DB2 z/OS

Performance > Active Threads

Toolbar or Right-click Actions

The following object-specific action is available for this object type:

For a complete listing of object actions and detailed instructions, see Object actions.

For details on actions available from the Explorer, see Initiating Object Actions in the Navigator/Explorer.

Blocking Locks Node

The Blocking Locks node on the Explorer displays only the locks that are blocked. To utilize all Database Monitor functionality, on the Utilities menu, select Database Monitor.

Platform availability and Explorer node location

ORCL

Performance > Blocking locks

SQL SVR

Performance > Blocking Locks

SYB ASE

Performance > Blocking Locks

Toolbar or Right-click actions

The following object-specific action is available for this object type:

For a complete listing of object actions and detailed instructions, see Object actions.

For details on actions available from the Explorer, see Initiating Object Actions in the Navigator/Explorer.

Connected Users Node

This node displays sp_iqconnection procedure output including

  • User details (ConnHandle, Name, Userid)
  • Connection details (ReqType, LastReqTime, ConnCreateTime, CommLink, NodeAddr, DBremote)
  • Command details (IQCmdType, LastIQCmdTime)
  • Cursor details (IQCursors, LowestIQCursorState)
  • Thread details (IQthreads)
  • Transaction details (TxnID, LastIdle)
  • Storage space details (TempTableSpaceKB, TempWorkingSpaceKB)
  • Message identifier details (IQConnID)
  • Internal counter details (satoiq_count, iqtosa_count)

Platform availability and Explorer node location

SYB IQ

Database Monitor > Connected Users

Toolbar or Right-click actions

The following object-specific action is available for this object type:

For a complete listing of object actions and detailed instructions, see Object actions.

For details on actions available from the Explorer, see Initiating Object Actions in the Navigator/Explorer.

Database Locks

The Database Locks node lists -DISPLAY DATABASE(*) LIMIT(*) LOCKS output, showing status codes, connection ID, correlation ID, and lock information (LockInfo field) for all programs holding locks on databases or spaces.

Note: LockInfo consists of lock status (H, W, or R), a lock state (IS, IX, S, U, SIX, X, or NSU), lock type (S, T, C, R, W, P, PP) and lock duration (A, C, H, M, P, or I). Similarly, status codes display standard -display command output (ARBDP, AREO*, ACHKP, AREST, AUXW, CHKP, COPY, DBETE, GRECP, ICOPY, LPL, LSTOP, PSRBD, RBDP, RBDP*, RECP, REFP, RELDP, REORP, RESTP, RO, RW, STOP, STOPE, STOPP, UT, UTRO, UTRW, UTUT, and WEPR). For detailed descriptions of these items, connection IDs and correlation IDs, consult DB2 for z/OS documentation. For more information, see Accessing Third Party Documentation.

Platform availability and Explorer node location

DB2 z/OS V8^

Performance > Database Locks

Toolbar or Right-click actions

For details on actions available from the Explorer, see Initiating Object Actions in the Navigator/Explorer.

Related Information

Inactive Threads

Inactive threads are processes that are idle. When you select the Inactive Thread node on the Explorer, DBArtisan displays the inactive threads that are currently running on the IBM DB2 for z/OS and OS/390 database. To utilize all Database Monitor functionality, on the Utilities menu, click Database Monitor.

Platform availability and Explorer node location

DB2 z/OS

Performance > Inactive Threads

Toolbar or Right-click actions

The following object-specific action is available for this object type:

For a complete listing of object actions and detailed instructions, see Object actions.

For details on actions available from the Explorer, see Initiating Object Actions in the Navigator/Explorer.

Indoubt Threads

Indoubt threads are processes waiting for resources to become active. When you select the Indoubt Thread node on the Explorer, DBArtisan displays the indoubt threads that are currently running on the IBM DB2 for z/OS and OS/390 database. To utilize all Database Monitor functionality, on the Utilities menu, select Database Monitor.

Platform availability and Explorer node location

DB2 z/OS

Performance > Indoubt Threads

Toolbar or Right-click actions

The following object-specific actions are available for this object type:

For a complete listing of object actions and detailed instructions, see Object actions.

For details on actions available from the Explorer, see Initiating Object Actions in the Navigator/Explorer.

IQ Status Node

This node displays sp_iqstatus procedure output, including:

Version Time Now Build Time File Format

Server mode

Catalog Format

Stored Procedure Revision

Page Size

Number of Main DB Files

Main Store Out Of Space

Number of Temp DB Files

Temp Store Out Of Space

DB Blocks...

Temp Blocks...

Create Time

Update Time

Main IQ Buffers

Temporary IQ Buffers

Main IQ Blocks Used

Temporary IQ Blocks Used

Main Reserved Blocks Available

Temporary Reserved Blocks Available

IQ Dynamic Memory

Main IQ Buffers

Temporary IQ Buffers

Main IQ I/O

Temporary IQ I/O

Other Versions

Active Txn Version

Last Full Backup ID

Last Full Backup Time:

Last Backup ID

Last Backup Type

Last Backup Time

DB Updated

Blocks in next ISF Backup

Blocks in next ISI Backup

DB File Encryption Status

Platform availability and Explorer node location

SYB IQ

Database Monitor > IQ Status

Locks

The Locks node on the Explorer displays the lock objects held on the table and row IDs for your database. DBArtisan lets you view all locks associated with a database.

Platform availability and Explorer node location

DB2 LUW

Performance > Locks

DB2 z/OS

Performance > Locks

MySQL

Performance > Locks

ORCL

Performance > Locks

SQL SVR

Performance > Locks

SYB ASE

Performance > Locks

Toolbar or Right-click actions

The following object-specific actions are available for this object type:

DB2 LUW DB2 z/OS MySQL ORCL PSTGRS * SQL SVR SYB ASE SYB IQ

Kill

✓

✓

✓

✓

For a complete listing of object actions and detailed instructions, see Object actions.

For details on actions available from the Explorer, see Initiating Object Actions in the Navigator/Explorer.

Performance Databases Node

The Performance Databases node lists -DISPLAY DATABASE(*) LIMIT(*) output, showing status codes for all tablespaces and indexes on the datasource.

Platform availability and Explorer node location

DB2 z/OS v8^

Performance > Performance Databases

Toolbar or Right-click actions

For details on actions available from the Explorer, see Initiating Object Actions in the Navigator/Explorer.

Related Information

PL/SQL Code Profiling Node

This node provides access to resources created using the Oracle SQP Profiler. For detailed information on this DBArtisan feature, see PL/SQL Profiler.

Platform availability and Explorer node location

ORCL

Performance > PL/SQL Profiling

Toolbar or Right-click actions

The following object-specific actions are available for this object type:

For a complete listing of object actions and detailed instructions, see Object actions.

Postponed Threads Node

Postponed threads are units of work for which back-out processing is currently postponed.

Platform availability and Explorer node location

DB2 z/OS

Performance > Postponed Threads

Toolbar or Right-click actions

For details on actions available from the Explorer, see Initiating Object Actions in the Navigator/Explorer.

Prepared Transactions Node

These are transactions that have been prepared for two-phase commit. The following pg_prepared_xacts table columns are displayed for each transaction: transaction ID, global ID, date and time that the PREPARE TRANSACTION statement was executed, and the owner and database associated with the transaction.

Platform availability and Explorer node location

PSTGRS

Performance > Prepared Transactions

Processes

The Processes node on the Explorer displays processes that are currently running on your DBMS.

Platform availability and Explorer node location

DB2 LUW

Performance > Processes

MySQL

Performance > Processes

ORCL

Performance > Processes

SQL SVR

Performance > Processes

SYB ASE

Performance > Processes

Toolbar or Right-click actions

The following object-specific action is available for this object type:

DB2 LUW DB2 z/OS MySQL ORCL PSTGRS * SQL SVR SYB ASE SYB IQ

Kill

✓

✓

✓

✓

✓

For a complete listing of object actions and detailed instructions, see Object actions.

For details on actions available from the Explorer, see Initiating Object Actions in the Navigator/Explorer.

Restricted Tablespaces

The Restricted Tablespaces node lists -DISPLAY DATABASE(*) SPACENAM(*) RESTRICT output, showing status codes for all tablespaces in an exception state

Platform availability and Explorer node location

DB2 z/OS V8^

Performance > Restricted Tablespaces

Toolbar or Right-click actions

For details on actions available from the Explorer, see Initiating Object Actions in the Navigator/Explorer.

Related Information

Table Locks Node

This node displays sp_iqlocks procedure output. The following table shows the columns displayed, by Sybase IQ version, and where appropriate, shows additional details on values.

Version 15 and later Versions prior to 15 Notes on values

conn_name

conn_id

connection

user_id

user_id

table_type

BASE, GLBTMP, or MVIEW.

creator

table_name

table_name

index_id

lock_class

Lock_type

S (share), SW (share and write), EW (exclusive and write), E (exclusive), P (phantom), A (antiphantom), or W (write) as well as the qualifiers T, *, and nnn.

lock_duration

(Transaction, Position, or Connection

lock_type

lock_name

row_identifier

Platform availability and Explorer node location

SYB IQ

Database Monitor > Table Locks

Toolbar or Right-click actions

The following object-specific action is available for this object type:

For a complete listing of object actions and detailed instructions, see Object actions.

For details on actions available from the Explorer, see Initiating Object Actions in the Navigator/Explorer.

Traces

The Traces node displays a list of active traces. Traces let you monitor and collect DB2 for OS/390 monitoring, auditing, performance, accounting, statistics, and serviceability (global) data.

Note: This information is read-only.

Platform availability and Explorer node location

DB2 z/OS

Performance > Traces

Toolbar or Right-click actions

For details on actions available from the Explorer, see Initiating Object Actions in the Navigator/Explorer.

Utilities

The Utilities node displays wizards that are typically run from the command line and do not apply to a particular type of schema object. Some of these wizards are also available via the command menus for objects. The wizards include:

  • Check Data
  • Check Index
  • Copy
  • Copy to Copy
  • Load
  • Merge Copy
  • Modify Recovery
  • Modify Statistics
  • Quiesce Tablespace
  • Rebuild Index
  • Recover
  • Reorg Index
  • Reorg Tablespace
  • Runstats Index
  • Runstats Tablespace
  • Unload
  • Maintain Template
Tip: To run a wizard, select the command in the right pane of the application and click the Execute button on the Explorer toolbar.

Platform availability and Explorer node location

DB2 z/OS

Performance > Utilities

Toolbar or Right-click actions

For details on actions available from the Explorer, see Initiating Object Actions in the Navigator/Explorer.

Retrieved from "http://docwiki.embarcadero.com/DBArtisan/171/e/index.php?title=Performance_Explorer_Node&oldid=5854"