sysproc.snapshot

sysproc.snapshot_tbreorg

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger - 29 Jan 2008 16:14 GMT

For some reason when i execute this :
select table_name from table(sysproc.snapshot_tbreorg('',-1))as t

I doesn't return any data on couple of databases, but works on others,
yet when I do list history reorg I get lots of data.

What could be the reason why sysproc.snapshot_tbreorg is not returning
any data ?

I am on V 8.2 FP 15 - 64 bit on AIX

Roger

Reply to this Message

The Boss - 30 Jan 2008 00:30 GMT

> For some reason when i execute this :
> select table_name from table(sysproc.snapshot_tbreorg('',-1))as t
[quoted text clipped - 8 lines]
>
> Roger

Check the settings of the Monitor Switches.
In this case, the switch for TABLE should be ON.

Signature

Jeroen

Reply to this Message