calShowPartitions not working

3 posts / 0 new
Last post
twixer
twixer's picture
Offline
Last seen: 1 month 1 week ago
Joined: Sep 11 2012
Junior Boarder

Posts: 6

Olivier Naeem
calShowPartitions not working

Hello everybody,
I have a problem with the calShowPartitions command which is returning no result :(

I have 2 DB, one is Active the other is Passive. The Active contains more recent data (3 more months compare to the Passive).

Configuration :
[code]OS : Linux Ubuntu 10.0.4
InfiniDB SoftwareVersion = 2.2.11 Enterprise[/code]

select calShowPartitions('myTable', 'my_datetime_col');
[code]+------------------------------------------------------------------------------+
| calShowPartitions('myTable', 'my_datetime_col') |
+------------------------------------------------------------------------------+
| Part# Min Max Status |
+------------------------------------------------------------------------------+
1 row in set (0.08 sec)[/code]

The same request on my Passive DB :
[code]calShowPartitions('myTable', 'my_datetime_col'): Part# Min Max Status
0.0.1 2011-12-01 00:00:00 2011-12-22 16:25:18 Enabled
0.1.1 2011-12-06 00:00:00 2011-12-28 17:48:39 Enabled
0.2.1 2011-12-10 00:00:00 2012-01-04 17:16:13 Enabled
0.3.1 2011-12-14 00:00:00 2012-01-10 18:20:16 Enabled
1.0.1 2012-01-10 00:00:00 2012-02-07 18:58:19 Enabled
1.1.1 2012-01-16 00:00:00 2012-02-13 21:26:15 Enabled
...
...
8.3.1 2012-12-19 00:00:00 2013-01-19 11:25:35 Enabled
9.0.1 2013-01-19 00:00:00 2013-02-15 17:12:09 Enabled
9.1.1 2013-01-24 00:00:00 2013-02-21 15:42:07 Enabled
9.2.1 2013-01-30 00:00:00 2013-02-05 18:01:00 Enabled
9.3.1 2013-02-05 00:00:00 2013-02-28 23:55:42 Enabled
10.0.1 2013-02-20 00:00:00 2013-02-20 23:55:45 Enabled
1 row in set (0.00 sec)[/code]

Any idea ?

radams
radams's picture
Offline
Last seen: 1 hour 40 min ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
Re: calShowPartitions not working

Hi,

We do not support the Enterprise version of InfiniDB on the Community Forum. The features and releases are different. Partiton management is only available on the Enterprise edition of InfiniDB. Please contact Calpont support for assistance.

Thank you,

Robert
Calpont

twixer
twixer's picture
Offline
Last seen: 1 month 1 week ago
Joined: Sep 11 2012
Junior Boarder

Posts: 6

Olivier Naeem
Re: calShowPartitions not working

Ok, I didn't know about this.

We will probably contact you for assistance on this subject.

Bye,
Twixer