IDUG : Forums : Determining the time a table was placed in UT status

Vincenzo Croce II

Determining the time a table was placed in UT status

December 4, 2018 07:52 AM

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

December 4, 2018 10:55 AM (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

December 4, 2018 11:34 AM (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-----