Determining the time a table was placed in UT status

Vincenzo Croce II

Determining the time a table was placed in UT status
I am trying to figure out if it is possible to determine a date and time that a tablespace/indexspace is placed in UT status. Any ideas?

Thank You,

Vince Croce


alain pary

RE: Determining the time a table was placed in UT status
(in response to Vincenzo Croce II)

Hello, 

Command text is logged automatically. When you run DSN1LOGP with TYPE(0010), the output includes records for commands. Command record output has TYPE(SYSTEM EVENT) and SUBTYPE(TRACE RECORD). The data is in the form of an IFCID 0090 trace record.

Or you can check in the syscopy if a utility run upon the tablespace. 

regards 

Alain 

Vincenzo Croce II

Determining the time a table was placed in UT status
(in response to alain pary)
Thank you, I’ll look into it.


Vince Croce
From: alain pary <[login to unmask email]>
Sent: Tuesday, December 4, 2018 11:55 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Determining the time a table was placed in UT status


Hello,

Command text is logged automatically. When you run DSN1LOGP with TYPE(0010), the output includes records for commands. Command record output has TYPE(SYSTEM EVENT) and SUBTYPE(TRACE RECORD). The data is in the form of an IFCID 0090 trace record.

Or you can check in the syscopy if a utility run upon the tablespace.

regards

Alain

-----End Original Message-----