Data items and views

A view usually contains a mix of key and result data items. This mixture of keys and results provides flexibility in determining the amount of detail of the data to be returned. The exception is server-wide data, such as transaction or network activity data. For server-wide data, no key data items are specified and only one row of data is returned.

Table 2-1 shows examples of data returned by views.

Table 2-1: Examples of data returned by views

View defined with

Returns

SMC_NAME_PAGE_IO

page I/Os for the whole server
Row results:
    Page I/O
    ---------
    145

SMC_NAME_SPID, SMC_NAME_LOGIN_NAME, SMC_NAME_PAGE_IO

(where SPID is a key data item)

page I/O per process
Row results:
SPID          Login Name        Page I/O
---------------------------
3             sa                45
5             joe               100

SMC_NAME_SPID, SMC_NAME_DB_ID, SMC_NAME_OBJ_ID, SMC_NAME_DB_NAME, SMC_NAME_OBJ_NAME, and SMC_NAME_PAGE_IO (where SMC_NAME_SPID, SMC_NAME_DB_ID, and SMC_NAME_OBJID are key data items)

page I/O per database table per process
Row results:
SPID     DBID    ObjID    DBName   ObjName   PageIO
------------------------------------------------
1       5     208003772  pubs2    titles      10
1       5     336004228  pubs2    blurbs      5
5       5     22003430   pubs2    sales       100