cancel
Showing results for 
Search instead for 
Did you mean: 

How to increase the limit keys?

Former Member
0 Kudos

Hi,

I have problem in PA4. The table GLPCAX has been already partitioned and it has 21 parts. The problem is that 21st part of the table gradually increasing size 47GB.

We don't know how to re-balance or increase the limit key values in SAP side? Can you please provide us an OSS note to increase the limit key

values.

Thanks,

Rajesh

Accepted Solutions (0)

Answers (1)

Answers (1)

KayKa
Active Participant
0 Kudos

Hi Rajesh,

i don't know how to do it in SAP. But we rebalance the table on z/OS, if it is necessary:

REORG TABLESPACE "<database>"."<tablespace>" PART (1:<n>) REBALANCE

COPYDDN(CP1)

SORTDATA LOG NO SORTKEYS

SHRLEVEL REFERENCE

TIMEOUT TERM

STATISTICS TABLE(ALL) SAMPLE 25 UPDATE ALL

hth

Kay