cancel
Showing results for 
Search instead for 
Did you mean: 

How to monitor table partition size changing in IQ?

former_member232292
Participant
0 Kudos

Dear All,

    I'm trying to monitor the table partition size changing in IQ so that I can find out the fastest growing partition and if needed, will split it to balance load for better performance. But now, I'm facing this problem --

1. in the syspartition table, there's no partition's size info,

2. in the sp_iqdbspaceobjectinfo -- only tell me how many partition in this dbspace.

  So is that I can only read the partition key's barrier value, and use count(*) to get the rows number and then use sp_iqestspace to count the partition size? And if there's any other accurate way to get the partition size infomation?

    Thanks for your help.

Regards

Eisen

Accepted Solutions (1)

Accepted Solutions (1)

former_member232292
Participant
0 Kudos

select  distinct b.owner, b.object_name,b.partition_name,b.dbspace_name,c.columns, c.indexes 

from sp_iqobjectinfo() a, sp_iqobjectinfo() b,sp_iqdbspaceinfo() c

where a.owner=b.owner

and a.object_name=b.object_name

and a.object_type='partition'

and b.partition_name=a.sub_object_name

and c.owner=b.owner

and c.object_name=b.object_name

order by 1,2,3;

I'm trying this sql -- but it can only support the scenario that each table partition allocated on different dbspace -- and if there's a table has more than 1 partitions on 1 dbspace, then it would be error...

Would anyone please have any ideas? Thanks

Answers (2)

Answers (2)

RolandKramer
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello,

did you tried to use the SAP IQ Cockpit to monitor your tables?

the Document - SAP First Guidance – SAP NLS Solution with SAP IQ explains how to setup the SAP IQ Cockpit

Best Regards Roland

marcguillard
Discoverer
0 Kudos

Hi,

I have seen this topic, but do not solve my problem.

I have a table with partition by range. For exemple 50 partitions.

I would like to have for each partition the size of the partition in Go

Regards.