topic Cluster Table KOCLU in Application Development and Automation Discussions

Cluster Table KOCLU

Former Member — Thu, 04 Nov 2010 15:56:45 GMT

What physical database tables are in the KOCLU cluster?

Former Member — Thu, 04 Nov 2010 15:58:06 GMT

I believe that KONV is one.

Former Member — Thu, 04 Nov 2010 16:03:21 GMT

KONV is the only one that shows up in a where used list.

Rob

Former Member — Thu, 04 Nov 2010 16:06:09 GMT

Can DBAs run stats on a cluster table or just on the physical tables themselves?

Former Member — Thu, 04 Nov 2010 16:14:41 GMT

You should ask the DBAs what they can do.

But since the only table that is known at the database level is the cluster table...

Rob

Former Member — Sun, 05 Dec 2010 20:13:16 GMT

There are 2 ways you can search the cluster/pool tables list of a specific Table Cluster/Pool :

First Method:

1) Go to SE11

2) Enter the Table Cluster/Pool name and then click on Disply.

3) Use the 'Where-Used-List'

Second Method:

1) Go to SE11

2) Enter table name 'DD02L' and click on Display.

3) Click on 'Table Contents' icon or press 'CtrlShiftF10'

4) Enter your Table Category 'CLUSTER/POOL on selection screen'

5) Enter your Table Cluster/Pool name on selection screen.

And Basis persons run a statistics reports only on database tables.