on 10-09-2007 6:01 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
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.