MainView for DB2 – Basics

Intro: (0:00)

Accessing MainView through MVEXPLORER: (0:10)
Accessing MainView for DB2 through MVEXPLORER: (1:07)
Accessing PAS information (PASINFO): (1:35)

Buffer Pool Menu (EZDBFRPL): (1:54)
Buffer Pool Statistics (BFRPL): (2:12)
Buffer Pool Activity Rates (BFRPLH): (2:41)

DB2 Buffer Pool Summary (STBFRPL): (3:11)
DB2 Statistics Menu (EZDSTAT): (3:38)
DB2 Activity Overview (STDB2): (4:01)
DB2 Exceptions Overview (STEXC): (4:27)
DB2 Activity Rates (STRATE): (4:46)
DB2 Locks (STLOCK): (5:07)
DB2 Global locking (STGBLLK): (5:53)

DDF Connection Menu (EZDDF2): (6:29)
Lockout Blocker Plan Summary (LKBLOCKZ): (7:01)
Lockout Waiter Plan Summary (LKWAITZ): (7:15)
Lockout Waiter Plan Detail (LKWAIT): (7:21)
Lockout Blocker/Waiter Summary (LKBWZ): (7:28)
Lockout Global Blocker/Waiter (LKBWZSSI): (7:40)
Lockout Resource Conflict Detail (LKRESD): (7:52)
Lockout Connection Summary (LKCONZ): (7:57)
Summary Locks Held by Thread (LSTLOCKZ): (8:04)
Total Locks Overview (LSOVER): (8:15)

Monitor Requests Summary (DM): (8:27)
Start Monitor Requests (SM): (8:52)
Showing Monitors details (SM): (9:12)
Details for CHKPT monitor (SM): (9:25)

OBJZ Object Status Summary (OBJSTAT): (9:34)
OBJLIST Object Status List (OBJSTAT): (9:51)

PLEXAREA Target Area Summary (OPS): (10:00)
PLEXAREA Target Area Detail (OPS): (10:15)

EZDPS Menu (PAGESET): (10:22)
PSSTAT view (PAGESET): (10:30)

SQL Summary by Application (SCAPPLZ): (10:37)

Current Trace List (CT): (10:56)
3270 transfer: (11:40)
BIGLEAP Thread Details: (11:53)
EZDB2 Menu: (12:00)
Viewing all traces started: (12:12)
Starting a trace: (12:28)
Purging a trace: (12:16)

Active Threads (THDACTV): (13:29)
Viewing all active threads: (13:48)

UTLZ Utilities Status Summary (UTILSTAT): (14:31)
Utilities List (UtLLIST): (14:45)

Locking Tuning Wizard (WZLOCK): (14:49)

EZDB2PARM menu (ZPARM): (15:35)

Outro: (16:12)