on 08-18-2016 3:30 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.