By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,784 Members | 2,933 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,784 IT Pros & Developers. It's quick & easy.

sysproc.snapshot_tbreorg

P: n/a
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
Jan 29 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Roger wrote:
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
Check the settings of the Monitor Switches.
In this case, the switch for TABLE should be ON.

--
Jeroen
Jan 30 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.