Source of timestamp for captured SQL text in Sysview for Db2
search cancel

Source of timestamp for captured SQL text in Sysview for Db2

book

Article ID: 8644

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Where does Sysview Performance Management Option for Db2 for z/OS (IDB2) obtain the timestamp displayed in the Exception captured SQL text?

Resolution

IDB2 obtains the clock value for the Exception captured SQL statement begin time out of the control block and converts it to the format seen in the captured SQL statement.