Locking Views
This section shows how to retain the present data shown in your views without it being updated.
A VistaPoint view is composed of a query and a form. The query selects the5 data that appears in a view. The form specifies how the data is summarized and displayed. VistaPoint Views Composed of Queries and Forms illustrates the concept of views extracting data with a query and processing it through a form template that configures the appearance of the fields displayed on the screen.
VistaPoint Views Composed of Queries and Forms
Display the APOVERC view.
APOVERC View shows an example APOVERC cluster view. The FINANCE application shows poor response time over the current real-time period. Only 24% of the transactions occurring in the application are meeting their response time service objectives. But, the interval and session graphs show that the FINANCE transaction response times were much better recently. Something is happening in the current real-time period that is affecting response time performance.08NOV2000 13:36:52 ----------- INFORMATION DISPLAY ---------------------------
COMMAND ===> SCROLL ===> CSR
CURR WIN ===> 1 ALT WIN ===>
W1 =APOVERC===========ALL======*========08NOV2000====13:36:52=MVVP==========7===
CMD Appl Realtime %Obj Interval %Obj Session %Obj Tot
--- -------- 0.....50...100 0.....50...100 0.....50...100 Wkl
PAYROLL 98.26 ************** 79.18 ********** 89.23 ************ 12
FINANCE 24.24 **** 86.75 *********** 88.23 *********** 6
ALLBATCH 56.23 ******** 89.00 ************ 85.55 *********** 4
ACCTREC 97.33 ************* 89.75 ************ 92.34 ************ 6
ACCTPAY 96.33 ************* 95.30 ************* 96.89 *************
DEVLMNT 84.55 *********** 87.78 ************ 83.22 ***********
PRODCTN 82.90 *********** 85.89 ************ 82.50 ***********You need to lock the view to see if you can capture enough data to begin diagnosing the cause of the problem. If it is a transient event, the data may be lost when you refresh the view.
- Type Lock to keep the present data shown in your APOVERC view.
The window information line status field changes to L to indicate that the view is locked. - Look at the time shown in the window information line.
Wait several seconds and then press Enter.
The window information line should show the same time that the LOCK command was entered. The view data should also be the same. Use the LOCK command when you need to display the same data and prevent it from being refreshed.- Type DATAR to update the view but retain the view lock.
The DATARefresh command allows a view to be refreshed even though it is locked. Your APOVERC view should be refreshed with new data and the window information line should show the current time. The status field shows L to indicate that the window is still locked. - Get help for the APOVERC view by typing help apoverc on the COMMAND line.
Scroll forward through the help window until you see a list of additional help topics for the APOVERC view.
08NOV2000 13:36:52 ----------- INFORMATION DISPLAY ---------------------------
COMMAND ===> SCROLL ===> CSR
CURR WIN ===> 1 ALT WIN ===>
L1 =APOVERC===========ALL======*========08NOV2000====13:36:52=MVVP==========7===
CMD Appl Realtime %Obj Interval %Obj Session %Obj Tot
0.....50...100 0.....50...100 0.....50...100 Wkl
PAYROLL 98.26.---------------------------------------------------- FINANCE
24.24| Help MVVP Cluster Overview Help | 6
ALLBATCH 56.23| Command ==> Scroll ==> PAGE | 4
ACCTREC 97.33| -------------------------------------------------- |* 6
ACCTPAY 96.33| |**
DEVLMNT 84.55| o Actions available from this view |
PRODCTN 82.90| |
| o Elements in this view |
| |
| o Positional parameters |
| |
| o Keyword parameters |
| |
| o Forms that are valid for this view |
| |
| o Sort information |
'----------------------------------------------------'Hyperlink to the Forms topic by moving the cursor over any character in thehighlighted phrase Forms that are valid for this view and pressing Enter.
List of Alternate APOVERC Views shows the help window with a partial listing of alternate forms of APOVERC.Help Forms Help
Command ==> Scroll ==> CSR
--------------------------------------------------
You can look at the currently displayed data in a
different format by specifying any of the
following view names on the FORM command.
o APBSYSZ
o APBSYSCZ
o APBSYSRZ
o APBSYSSZ
o APGRP
o APGRPC
o APGRPR
o APGRPS
o APHOURThe alternate forms of the APOVERC view are most of VistaPoint's remaining views. Most of VistaPoint's views are alternate forms of each other.
- Exit from the help windows and return to the APOVERC view.
The view should show the same data that you locked earlier in this section. - Refresh the view by typing UNLOCK and pressing Enter.
You should see the view refreshed with new data and the time change on the window information line. Display the real-time view of the same data by typing form apoverr.
APOVERR as an Alternate Form of the APOVERC View shows the APOVERR real-time view, which is an alternate form of the APOVERC cluster view. Notice the time shown on the window information line did not change. The window information line also shows APOVERR as the form of the original APOVERC view.19DEC2000 11:37:53 ----------- INFORMATION DISPLAY ---------------------------
COMMAND ===> SCROLL ===> CSR
CURR WIN ===> 1 ALT WIN ===>
>W1 =APOVERC==APOVERR=(ALL======*=======)19DEC2000==11:37:53====MVVP=========62
CMD Appl Realtime %Obj <= 80%- 90%- > Total Worst Best Avg
--- -------- 0.....50...100 80% 90% 100% 100% Wklds %Obj %Obj Resp---
TSO 19.0 1 1 19.0 19.0 0.165
OLTPWORK 52.5 1 1 52.5 52.5 2.482
HSJCIDB2 100.0 2 6 0.0 100.0 0.001
GPTEST1 100.0 2 6 0.0 100.0 0.001
IHKCICS 100.0 1 2 0.0 100.0 0.001
FINANCE 100.0 1 5 0.0 100.0 0.001
CMR1 100.0 4 100.0 100.0 0.001
TESTIE 100.0 4 100.0 100.0 0.001
WILLIE 100.0 4 100.0 100.0 0.001
TESTWKLD 100.0 4 100.0 100.0 0.001
IHK 100.0 1 100.0 100.0 0.001
MARTYXX 100.0 1 100.0 100.0 0.001
SPURS 100.0 1 100.0 100.0 0.001
CSCCOMP 100.0 2 100.0 100.0 0.001
PUBCICS 100.0 4 100.0 100.0 0.001
MORTGAGE 100.0 4 100.0 100.0 0.001The real-time interval of the original APOVERC cluster view shows the FINANCE workload is not meeting its response-time service objectives. Displaying the alternate real-time view uses the same data, but displays additional fields not shown in the original view.
- Look at the interval alternate form by typing form APOVER.
You should see the same time on the window information line displayed from the APOVERC and APOVER views. - Look at the session alternate form by entering form APOVERS.
VistaPoint stacks alternate forms of views. You can shift back and forth between the alternate forms of a view that you have displayed in a session. - Enter fprev to display the APOVER view again.
- Enter fnext to display APOVERS again.
Return to the APOVERC view by repeatedly pressing your END key until you reach the top of the view stack.
In this section, you displayed APOVERR, APOVER, and APOVERS forms of the APOVERC view in that order. You can shift between these views by entering the FNEXT or FPREV command to see the next or previous view in the stack.To do this...
Use this command...
Shift forward to the next form in the stack
FNEXT
Shift backward to the previous form in the stack
FPREF
Return to the last form; if there are no more forms in the stack, return to the last query
END
Delete the current query and all its forms; return to the previous view
ENDQuery
Display a list of the filters currently in effect for both the query and the form
SHOWFILT
Update the data in one window without updating data in the others
DATARefresh
Related topic