If you need to determine the LRSN that corresponds to a timestamp, you can provide the
timestamp and Log Analysis Tool converts it to an LRSN.
About this task
The Convert Timestamp to LRSN panel also can be invoked from the Generate Database Activity
Report (General) panel. In this case, converted values are passed to the
Start/End LRSN fields on Generate Database Activity Report panel.
For
details about the fields on the Convert Timestamp to LRSN panel, refer to the online help or online
tutorial.
Procedure
From the Db2 Log Analysis Tool - Classic Menu, select option 7,
Utilities, and then option 2,
Convert Timestamp to LRSN.
The Convert Timestamp to LRSN panel is displayed.
Figure 1. Convert Timestamp to LRSN panel
V3.5.0 ----------------- CONVERT TIMESTAMP TO LRSN ----------------- LPR1/SS01
Command ===>
Hit 'Enter' after entering Timestamp to convert to LRSN
Hit 'PF3' to EXIT
Input parameters:
Timestamp.............. YYYY/MM/DD-HH:MM:SS.MMMMMM
STCK to LRSN Delta..... 00000000000000000000
*Override GMT offset.... N (Y/N)
with this GMT offset.. +00:00
Converted LRSN:
LRSN...................
.------------------------------------------------------------------------.
| ALAA736I - Timestamp to LRSN translation is available from |
| "Generate Database Activity Report (General)" ISPF panel with pressing |
| PF06 key or entering XTSTAMP command |
'------------------------------------------------------------------------'
Enter the timestamp that you want to convert in the Timestamp field.
Enter the timestamp in the format YYYY/MM/DD-HH:MM:SS.MMMMMM.
Optional:
If an LRSN delta value has been applied, enter the delta value in the STCK to LRSN
Delta value field.
If you enter a value in this field, it will be added to the timestamp value before conversion
to the LRSN.
Optional:
If you want to adjust the timestamp for a particular time zone, enter Y in the
Override GMT offset field and enter the offset value in the with
this GMT offset field.
The default is the current GMT offset that is in use by the associated LPAR.
Press Enter.
The LRSN value is calculated and is displayed in the LRSN field.