modifed timestamp of a table

[Sumanth]

Hi,

Information with regard to creation of a table is stored in SYSTABLES.
Is modified time stamp of a table stored in
DB2, if so where.

Thanks,
Sumanth

[Shashi Mannepalli]

No this information is not stored in any of the CATALOG tables.
But all the changes will be LOGGED. You can use db2urlog or something
like that
to read those LOGS and check for a particular table....

This entire process is complex...

cheers...
Shashi Mannepalli
Sumanth wrote:

Hi,

Information with regard to creation of a table is stored in SYSTABLES.
Is modified time stamp of a table stored in
DB2, if so where.

Thanks,
Sumanth

[Knut Stolze]

Sumanth wrote:

Hi,

Information with regard to creation of a table is stored in SYSTABLES.
Is modified time stamp of a table stored in
You should use only the views in the SYSCAT schema, i.e. SYSCAT.TABLES. All
tables in the SYSIBM schema are not documented and they may change at any
time, breaking your application if you rely on them.
DB2, if so where.

The actual timestamp of the last data modification is not automatically
tracked. This would be a huge bottle-neck performance-wise if it were
done.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[aj]

Knut Stolze wrote:
....snip...

The actual timestamp of the last data modification is not automatically
tracked. This would be a huge bottle-neck performance-wise if it were
done.

But its been requested over and over and over again. Seems like those
smart IBM engineers could figure out some way to do it w/o screwing up
performance.

aj

[Gregor Kovaè]

aj wrote:

Knut Stolze wrote:
...snip...

The actual timestamp of the last data modification is not automatically
tracked. This would be a huge bottle-neck performance-wise if it were
done.

But its been requested over and over and over again. Seems like those
smart IBM engineers could figure out some way to do it w/o screwing up
performance.

aj

And I'd only need the time of last ALTER TABLE :))
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
| Gregor Kovac | Gr**********@mikropis.si |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

[Knut Stolze]

Gregor Kova� wrote:

aj wrote:

Knut Stolze wrote:
...snip...

The actual timestamp of the last data modification is not automatically
tracked. This would be a huge bottle-neck performance-wise if it were
done.
But its been requested over and over and over again. Seems like those
smart IBM engineers could figure out some way to do it w/o screwing up
performance.

As soon as someone implements a general purpose sorting mechanism that runs
faster than O(n log n), we can probably discuss the tuple counter
again. ;-)
And I'd only need the time of last ALTER TABLE :))

Indeed, I've been wondering why this information isn't available. :-(

--
Knut Stolze
DB2 Information Integration Development
IBM Germany