Is there a command that displays active collections?

Products

• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

This document states whether or not there is a command that displays active collections.

Is there a command that displays active collections?

Environment

z/OS 1.11 and above.

Resolution

The MVS Modify DISPLAY command shows the active collections that are running within an Xmanager. The format of the command is stated below:

F PTXMAN,DISPLAY 

The results of the command appear in the Xmanager log as shown below. Notice that Detector & Subsystem Analyzer collections are running on subsystems DB4G, DD2G & DD0G:

PXM0107 MODIFY TEXT = DISPLAY 

PXM0111 XMANAGER DISPLAY WORKLOAD IN PROGRESS 

PXM0113 DETECTOR IS ACTIVE FOR DB2=DB4G LPAR=CA32 

PXM0126 SSANALZE IS ACTIVE FOR DB2=DB4G LPAR=CA32 

PXM0113 DETECTOR IS ACTIVE FOR DB2=DD2G LPAR=CA31 

PXM0126 SSANALZE IS ACTIVE FOR DB2=DD2G LPAR=CA31 

PXM0113 DETECTOR IS ACTIVE FOR DB2=DD0G LPAR=CA11 

PXM0126 SSANALZE IS ACTIVE FOR DB2=DD0G LPAR=CA11 

PXM0109 XMANAGER MODIFY PROCESSING COMPLETE