Issue with MLPPI

Database
Highlighted
Enthusiast

Issue with MLPPI

Hi,

 

Greetings.

 

Is there any way to know whether table is partitioned by 2 byte or 8 byte?

 

Thanks.


Accepted Solutions
Junior Contributor

Re: Issue with MLPPI

The easiest way is to query dbc.PartitioningConstraintsV, if MaxCombinedPartitions is less than 65535 it's 2 byte otherwise 8 byte.

1 ACCEPTED SOLUTION
2 REPLIES
Junior Contributor

Re: Issue with MLPPI

The easiest way is to query dbc.PartitioningConstraintsV, if MaxCombinedPartitions is less than 65535 it's 2 byte otherwise 8 byte.

Enthusiast

Re: Issue with MLPPI

Hi,

 

Thank you so much for your response.