Browsing the Session Log
The Browse Session Log panel enables you to indicate browse specifications—the combination of operators, values, and WHERE statements that generate a customized Session Log List. This list is a subset of the Session Log and includes only the data that you want to see.
- On the Primary Menu panel or any list panel, on the Command line, enter MAINTAIN (MAINT).
On the Log Maintenance Menu panel, select Browse Session Log.The Browse Session Log panel is displayed.
DEMO-R --------------------- Browse Session Log ----------------------------
Command ===>
Type browse specifications and press Enter.
Column Operator Value
-------------------------------------------------------------------------------
Timestamp . . . = yyyy-mm-dd-hh.mm.ss.nnnnnn
Authid . . . . . =
Session Id . . . =
Return_Code . . =
Function . . . . =
Object_Type . . =
Object_Qual . . =
Object_Name . . =
You may add additional conditions in the WHERE clause below
WHERE
- On the Browse Session Log panel, in the Authid field, type an operator and a value for the authorization ID.
- (Optional) In the Function field, type a command or SQL action.
- (Optional) Specify a WHERE clause for the SQL statement.If you include a WHERE clause, observe the following rules:
- Use the column names as they are displayed on the Browse Session Log panel.
- Use correct SQL case, punctuation, and syntax as required by Db2.
- Use only wildcards that are supported by Db2.
Press Enter.The Session Log List panel is displayed.
DEMO-R ---------------------- Session Log List ---------- Row 1 to 35 of 205
Command ===> Scroll ===> PAGE
01
Enter D or S to describe a single session log row.
WHERE A.AUTHID LIKE 'MVSJXL%' AND A.SEQUENCE = 1
Cmd Date Authid Sesn Functn RtnC TypName
----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v---
2022-03-01 MVSJXL1 16 SET 000 UK
2022-03-01 MVSJXL1 16 CREATE 000 TR QCT.QCTR0X_DE01S01T01
2022-03-01 MVSJXL1 16 SET 000 UK
2022-03-01 MVSJXL2 10 DROP 000 TR QCT.QCTR0X_DE01S01T01
2022-02-25 MVSJXL1 15 START 000 DB
2022-02-24 MVSJXL2 9 CREATE 000 TS QCTS04X2
2022-02-24 MVSJXL1 13 REVOKE 000 TB QCT_SCHE.QCTT01_DE12S02_128
2022-02-24 MVSJXL1 13 REVOKE 000 TB QCT_SCHE.QCTT01_DE12S02_128
2022-02-24 MVSJXL1 14 SET 000 UK
2022-02-24 MVSJXL1 14 SET 000 UK
2022-02-24 MVSJXL1 13 REVOKE 000 TB QCT_SCHE.QCTT01_DE12S02_128
2022-02-24 MVSJXL1 13 REVOKE 000 TB QCT_SCHE.QCTT01_DE12S02_128
2022-02-24 MVSJXL1 13 REVOKE 000 TB QCT_SCHE.QCTT01_DE12S02_128
2022-02-24 MVSJXL1 13 REVOKE 000 TB QCT_SCHE.QCTT01_DE12S02_128
2022-02-24 MVSJXL1 13 REVOKE 000 TB QCT_SCHE.QCTT01_DE12S02_128
2022-02-24 MVSJXL1 14 COMMIT 000
2022-02-24 MVSJXL1 13 GRANT 000 UK
2022-02-24 MVSJXL1 13 GRANT 000 UK
2022-02-24 MVSJXL1 13 GRANT 000 UK
2022-02-24 MVSJXL1 13 GRANT 000 UK
2022-02-24 MVSJXL1 13 GRANT 000 UK
2022-02-24 MVSJXL1 13 GRANT 000 UK
2022-02-24 MVSJXL1 13 GRANT 000 UK
2022-02-24 MVSJXL2 9 DROP 000 TB QCT_SCHE.QCTT01_DEX2S04_128
2022-02-24 MVSJXL1 13 CREATE 000 IX QCT_SCHE.QCTX01_DEX2S04T01_
2022-02-24 MVSJXL1 13 CREATE 000 TB QCT_SCHE.QCTT01_DEX2S04_128
2022-02-24 MVSJXL1 13 CREATE 000 IX QCT_SCHE.QCTX02_DEX2S04T01_
2022-02-24 MVSJXL1 13 ALTER 000 TB QCT_SCHE.QCTT01_DEX2S01_128
2022-02-24 MVSJXL1 14 CREATE 000 TS QCTS0512
2022-02-24 MVSJXL1 14 CREATE 000 TB QCT_SCHE.QCTT01_DE12S05_128
2022-02-24 MVSJXL1 14 SET 000 UK
2022-02-24 MVSJXL1 14 COMMIT 000
2022-02-24 MVSJXL1 14 ALTER 000 TB QCT_SCHE.QCTT01_DE12S05_128
2022-02-24 MVSJXL1 14 COMMEN 000 TB QCT_SCHE.QCTT01_DE12S05_128
2022-02-24 MVSJXL1 14 LABEL 000 TB QCT_SCHE.QCTT01_DE12S05_128- In the Cmd column for the appropriate items, type D or S to view detailed information about entries on the list.
Press Enter.The Describe Session Log Entry panel is displayed, which shows information from the Session Log.
DEMO-R ----------------- Describe Session Log Entry ------ Row 1 to 19 of 19
Command ===> Scroll ===> PAGE
02
-------------------------------------------------------------------------------
FROM ACT131.SESSION_LOG
------------------------------------------------------------------------------
Logts. . . . . . : 2022-02-24-14.05.59.310784
Authid . . . . . : MVSJXL2
Session_id . . . : 9
Session_seq. . . : 2
Function . . . . : CREATE
Return_code. . . : 0
Object_type. . . : TABLESPACE
Object_qual. . . :
Object_name. . . : QCTS04X2
Sequence . . . . : 1
Action . . . . . : CREATE TABLESPACE QCTS04X2 IN QCTDEX2 USING STOGROUP
SYSDEFLT PRIQTY 200 SECQTY 120 ERASE NO FREEPAGE 15
PCTFREE 10 FOR UPDATE -1 GBPCACHE CHANGED COMPRESS NO
TRACKMOD YES LOGGED DSSIZE 1 G SEGSIZE 16 MAXPARTITIONS 4
BUFFERPOOL BP0 LOCKSIZE ANY LOCKMAX SYSTEM CCSID EBCDIC
MAXROWS 255 INSERT ALGORITHM 0
------------------------------------------------------------------------------
******************************* Bottom of data ********************************- Press END to move to the next Describe Session Log Entry panel (if you selected multiple items) or back to the Session Log List panel.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*