Viewing Database Statistics

To view and manage database statistics, select 58. Work with DB Statistics Monitors from the Activation and Server Settings screen (STRFW > 1). The DB Statistics - Monitors with Status screen appears.

​                    ​ DB Statistics - Monitors with Status​ *ALL​                                                                                                    ​ Type choices, press Enter.​                                                       ​ 1=Select​ ​ 4=ENDDBMON​                                                                                                                                            ​ Opt​ ​ Status​  ​ Type​  ​ Filter​                                                     ​ ​  ​  ​ CLOSING ​ DETAIL​                                                        ​     ​  ​  ​ CLOSING ​ DETAIL​ File: ALEX/TEST1 *EQ                                   ​     ​  ​  ​ CLOSING ​ DETAIL​ File: ALEX/IBM1 *EQ                                    ​     ​  ​  ​ CLOSING ​ DETAIL​ File: ALEX/IBM2 *EQ                                    ​     ​  ​  ​ CLOSING ​ DETAIL​ File: ALEX/IBM4 *EQ                                    ​     ​  ​  ​ CLOSING ​ DETAIL​ File: ALEX/IBM3 *EQ                                    ​     ​  ​  ​ CLOSING ​ DETAIL​ File: ALEX/IBM5 *EQ                                    ​     ​  ​  ​ CLOSING ​ DETAIL​ File: ALEX/SPOOL1 *EQ                                  ​     ​  ​  ​ CLOSING ​ DETAIL​ File: ALEX/SPOOL3 *EQ                                  ​     ​  ​  ​ INACTIVE​ DETAIL​ Job: QPADEV010*/*ALL/*ALL *EQ                          ​                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 ​ Bottom​  ​ F3=Exit​  ​ F5=Refresh​  ​ F7=Show active​                                                                                                                            ​

The screen can either show database monitors that are currently active or all of them. Press the F7 key to toggle between them.

For each monitor, the body of the screen shows these fields:

Status

?

Type

?

Filter

?

To see further information about a [[???}}, enter 1 on the Opt field for that line. A detail screen appears. In addition to the information on the previous screen, it shows a Monitor ID.

​                 ​ DB Statistics - Monitor with Status​ *ALL​                                                                                                        ​ Press Enter to continue.  ​                                                                                                                                       ​ Monitor ID . . . . .​  ​ 6802202062​                                               ​ Status . . . . . . .​  ​ CLOSING ​                                                 ​ Type . . . . . . . .​  ​ DETAIL​                                                                                                                                    ​ Filter ​                                                                         ​ File . . . . . . . .​  ​ ALEX/TEST1 *EQ                                         ​                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               ​       Bottom​  ​ F3=Exit​  ​ F12=Cancel​                                                                                                                                             ​