Viewing the DB-Gate Log
The DB-Gate Display Log shows the contents of the history log, which saves various data gathered from the different directory entries as you have defined them, in a standard format and using basic filter criteria. The "Backward Glance" feature lets you look at the last several minutes of activity without the need to define specific time or date parameters.
To filter and view log entries, select 41. Display Log from the DB-Gate main menu. The Display DB-Gate LogEntries screen appears:
| Display DB-Gate Log Entries (DSPDBLOG) Type choices, press Enter. Display last minutes . . . . . . *BYTIME Number, *BYTIME Starting date and time: Starting date . . . . . . . . *CURRENT Date, *CURRENT, *START... Starting time . . . . . . . . 000000 Time Ending date and time: Ending date . . . . . . . . . *CURRENT Date, *CURRENT, *YESTERDAY... Ending time . . . . . . . . . 235959 Time User profile . . . . . . . . . . *ALL Name, generic*, *ALL Remote user profile . . . . . . *ALL Name, generic*, *ALL Relational DB Entry . . . . . . *ALL Name, generic*, *ALL SQL Operation . . . . . . . . . *ALL Name, *ALL, ALTER, CLOSE... SQL State . . . . . . . . . . . *ALL Character, generic*, *ALL SQL Error code . . . . . . . . . *ALL Number, *ERR, *NOERR, *ALL SQL Statement contains . . . . . *ALL More... F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display F24=More keys |
| Display DB-Gate Log Entries (DSPDBLOG) Type choices, press Enter. SQL Message contains . . . . . . *ALL From job name . . . . . . . . . *ALL Name, generic*, *ALL User . . . . . . . . . . . . . *ALL Name, generic*, *ALL Number . . . . . . . . . . . . *ALL 000000-999999, *ALL From program name . . . . . . . *ALL Name, generic*, *ALL Library . . . . . . . . . . . *ALL Name, generic*, *ALL Number of records to process . . *NOMAX Number, *NOMAX Output . . . . . . . . . . . . . * *, *PRINT, *OUTFILE Bottom F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display F24=More keys |
The screen contains these fields:
Display last minutes
To view activity in the immediate past, enter a number corresponding to the number of minutes that you would like to check. For example, to check activity in the past 120 minutes, enter 120 in this field. This value would override starting and ending date and time fields.
Starting date and time
Starting date
The day or date on which the included data begins.
Allowed values include:
-
*CURRENT: The current date
-
*YESTERDAY: Yesterday's date
-
*WEEKSTR: The first day of the current week. By default, this is Sunday.
-
*PRVWEEKS: The first day of the previous week
-
*MONTHSTR: The first day of the current month
-
*PRVMONTHS: The first day of the previous month
-
*YEARSTR: The first day of the current year
-
*PRVYEARS: The first day of the previous year
-
*MON: Monday
-
*TUE: Tuesday
-
*WED: Wednesday
-
*THU: Thursday
-
*FRI: Friday
-
*SAT: Saturday
-
*SUN: Sunday
Starting time
The time on the Starting date at which the included data begins, in HHMMSS format.
Ending date and time
Ending date
The day or date on which the included data ends.
Allowed values are the same as for Starting date.
Ending time
The time on the Ending date at which the included data ends, in HHMMSS format.
User profile
All (default) or a specific user profile on the IBM i
Remote user profile
All (default) or a specific user profile on the remote database
Relational DB Entry
All (default) or a specific remote DB entry
SQL Operation
All (default) or a specific SQL operation that is used at the beginning of an SQL statement (such as CONNECT, CREATE, or DROP).
SQL State
All (default) or a specific state
SQL Error Code
All (default), a specific error code number or name that describes the problem, or entries without any error code
SQL Statement contains
All (default) or a specific SQL statement
SQL Message contains
All (default) or a specific error message that is associated with an error code
From job name
The job that made the change, or *ALL for all jobs.
User
The user who ran the job.
Number
The job number, from 000000 to 999999.
Number of records to process
The maximum number of records to process, or *NOMAX for all records.
Output
The destination for the report. Valid values include * (to send output to the screen). *PDF, *HTML, *CSV, *OUTFILE, and *PRINT1 though *PRINT9.
Define your filter parameters and press Enter. The DisplayDBGateLog screen appears:
| Display DB Gate Log 01/01/20 - 26/01/21 Log information is available from 01/01/20 DB->ORA: CONNECT DB->ORA: DISCONNECT DB->LOPC: SQL error -99999 detected for DB->LOPC: SQL error -99999 detected for DB->LOPC: CONNECT DB->MS: CONNECT DB->MS: SQL error -1 com/microsoft/sqlserver/jdbc/SQLServerDriver detected for DB->MS: SQL error -99999 detected for DB->MS: SQL error -1 java.lang.NullPointerException detected for DB->MS: SQL error -1 com/microsoft/sqlserver/jdbc/SQLServerDriver detected for DB->MS: SQL error -99999 detected for DB->LO: CONNECT DB->LO: SQL error -1 java.lang.NullPointerException detected for SET XXX ->LO: DISCONNECT DB->LO: CONNECT DB->LO: SQL error -1 java.lang.NullPointerException detected for SET XXX DB->LO: SQL error -1 java.lang.NullPointerException detected for SET XXX DB->LO: DISCONNECT More... F3=Exit F10=Entire-Entry F17=Top F18=Bottom |
To view further details for the output, select F10. Entire Entry. The Additional Entry Information screen appears.
| Additional Entry Information System: RLDEV Remote DB Entry . . . : MS From User Profile . . : DB Date sent . . . . . . : 21/01/25 Time sent . . . . . . : 14:45:22 From Job . . . . . . . : QPADEV002G/DB/092834 SQL Opr.: CONNECT Remote User . . . . . : ILAN SQL Err.: 0 SQL State . . . . . . : 00000 SQL Error Message . . : SQL Statement: CONNECT F3=Exit F12=Cancel |