Sorting Information

Introduction to Performance Monitor › Windowing › Sorting Information

Sorting Information

You can sort screens for the Realtime Monitor and the Interval Monitor based on the values in one or more screen fields.

Sorting a Single Field

To request sort processing for a single window field:

Type sort following the CMD--> prompt, followed by a (ascending) or d (descending) to specify the sequence of the sort.
Position the cursor anywhere in the field to be sorted.
Press [Enter].

Performance Monitor displays the sorted screen as requested.

Sorting Multiple Fields

To request sort processing for multiple window fields:

Type sort following the CMD--> prompt, then press [Enter] for the current window. Use the WINDOW command to specify a noncurrent window.
or
Type s in the window command field of the window to be sorted, then press [Enter].

Sort Selection Screen

Performance Monitor displays the Sort Selection screen for the selected window:

PM-Rnn.n SYSTEM71 CA, Inc. V71 08.348 13:47:31.35 CMD--> Window : 02 Refresh: 10 02 Sort Selection * CAUTION, May Be CPU Intensive i Sort Field Field Sort Order Order Number Field_Name Sequence 1 1 Select_Field 2 2 Buffer_Name 3 3 Found_In_Buffer 4 4 Reads 5 5 Writes 6 6 Forced_Writes 7 7 Bcr_Waits 8 8 Area_Count

The Sort Selection screen lists each field defined for the selected window. For each field, the Sort Selection screen displays:

The display sequence number of the field, moving across the screen from left to right (Field Order)
The internal field number (Field Number)
The field name (Field Name)
Existing sort criteria (Sort Order and Sort Sequence)

Specifying Sort Criteria

To specify sort criteria, enter information in the following fields:

Field	Information to enter
Sort Order	A sort order number for each field to be sorted: 1 for the primary sort field, 2 for the secondary sort field, and so forth.
Sort Sequence	a (ascending) or d (descending) to request that a field be sorted in ascending or descending order. Ascending order is the default.

Exiting a Sort Session

When you finish entering sort criteria, press [Enter].

The Sort Selection screen remains in the window until you return to the original monitor screen by performing one of the following steps:

Press [PF3].
Type exit following the CMD--> prompt, then press [Enter]. The window for the Sort Selection screen must be current.
Type x in the window command field for the window, then press [Enter].

Performance Monitor displays the original monitor screen. The information in the screen is sorted according to the new criteria.

Saving a Sorted Screen Format

You can save a sorted screen format for use during subsequent Performance Monitor sessions. Use the method described for saving an edited window under Editing Windows.

Example of Sorting a Field

The following I/O Detail screen is displayed during an Interval Monitor session. To sort the Write Waits field in descending sequence, type sort d on the command line and position the cursor in the Write Waits field:

PM-Rnn.n SYSQA03 CA, Inc. V105 08.348 11:35:34.80 CMD-->sort d Window : 02 02 09:40 IODT IO Detail ! > Area Name File Name Read Read Write Write Waits Time Waits Time NETAPPL.DDLDML NETAPPL.APPLDML 0 .0000S 0 .0000S NETAPPL.DDLDCLOD NETAPPL.APPLLOD 4 .0683S 0 .0000S PROJSEG.PROJAREA PROJSEG.PROJDEMO 0 .0000S 0 .0000S SQLAPPL.DDLCAT SQLAPPL.APPLCAT 0 .0000S 0 .0000S SQLAPPL.DDLCATX SQLAPPL.APPLCATX 0 .0000S 0 .0000S SQLAPPL.DDLCATLOD SQLAPPL.APPLCATL 0 .0000S 0 .0000S SQLDEMO.EMPLAREA SQLDEMO.EMPLDEMO 0 .0000S 0 .0000S SQLDEMO.INFOAREA SQLDEMO.INFODEMO 0 .0000S 0 .0000S SQLDEMO.INDXAREA SQLDEMO.INDXDEMO 0 .0000S 0 .0000S SYSLOC.DDLOCSCR SYSLOC.DCLSCR 0 .0000S 0 .0000S SYSMSG.DDLDCMSG SYSMSG.DCMSG 0 .0000S 0 .0000S SYSTEM.DDLDCLOD SYSTEM.DCLOD 0 .0000S 0 .0000S SYSTEM.DDLDCLOG SYSTEM.DCLOG 0 .0000S 54 2.25S SYSTEM.DDLDCRUN SYSTEM.DCRUN 0 .0000S 0 .0000S SYSTEM.DDLDML SYSTEM.DCDML 0 .0000S 0 .0000S SYSTEM.DDLDCSCR SYSTEM.DCSCR 0 .0000S 17 .9603S SYSUSER.DDLSEC SYSUSER.DCSEC 0 .0000S 0 .0000S TOOLDB.EMP-DEMO-REGION TOOLDB.TOOLEMP 0 .0000S 0 .0000S

Press [Enter]. Performance Monitor redisplays the screen contents sorted as requested:

PM-Rnn.n SYSQA03 CA, Inc. V105 08.348 11:36:58.23 CMD--> Window : 02 02 09:40 IODT IO Detail > Area Name File Name Read Read Write Write Waits Time Waits Time SYSTEM.DDLDCLOG SYSTEM.DCLOG 0 .0000S 54 2.25S SYSTEM.DDLDCSCR SYSTEM.DCSCR 0 .0000S 17 .9603S ASFNWK.DDLDML ASFNWK.ASFDML 0 .0000S 0 .0000S ASFNWK.DDLDCLOD ASFNWK.ASFLOD 0 .0000S 0 .0000S ASFNWK.IDMSR-AREA ASFNWK.ASFDEFN 0 .0000S 0 .0000S ASFNWK.IDMSR-AREA2 ASFNWK.ASFDATA 0 .0000S 0 .0000S CATSYS.DDLCAT CATSYS.DCCAT 0 .0000S 0 .0000S CATSYS.DDLCATX CATSYS.DCCATX 0 .0000S 0 .0000S CATSYS.DDLCATLOD CATSYS.DCCATL 0 .0000S 0 .0000S DIRLNWK.DDLDML DIRLNWK.DIRLDML 0 .0000S 0 .0000S DIRLNWK.DDLDCLOD DIRLNWK.DIRLLOD 0 .0000S 0 .0000S EMPDB.EMP-DEMO-REGION EMPDB.EMPDEMO 0 .0000S 0 .0000S EMPDB.INS-DEMO-REGION EMPDB.INSDEMO 0 .0000S 0 .0000S EMPDB.ORG-DEMO-REGION EMPDB.ORGDEMO 0 .0000S 0 .0000S EVQA.QATS-RRDS1 EVQA.EVQA01 0 .0000S 0 .0000S EVQA.QATS-ESDS1 EVQA.EVQA01 0 .0000S 0 .0000S EVQA.QATS-ESDS2 EVQA.EVQA01 0 .0000S 0 .0000S EVQA.QATS-KSDS1 EVQA.EVQA01 0 .0000S 0 .0000S