|
View previous topic :: View next topic
|
| Author |
Message |
dejunzhu
Active User
Joined: 08 May 2008
Posts: 390
Location: China
|
|
|
|
In below link, IBM says that we can choose to ALTER TABLE or REORG TABLESPACE if data of a particular partition has reached its maximum capacity 4G.
publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2z10.doc.admin/src/tpc/db2z_changepartitionboundary.htm
But what if the data excess its maximum capacity of 4G when online transaction happens? Will this cause a DB2 error and thus online transactions keep abend till DBA implements ALTER TABLE or REORG TABLESPACE against that table?
I mean, can we let DB2 REBALANCE partitions automatically when data reaches its partition's maximum capacity?
As DB2 is the most powerful database in the universe, I suppose there must be such functions... |
|
| Back to top |
|
 |
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Hi,
| Quote: |
| can we let DB2 REBALANCE partitions automatically when data reaches its partition's maximum capacity? |
Yes, you can prepare automated scripts and rebalance partitions before it reaches its maximum capacity during the downtime.
Thanks,
Sushanth |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| As DB2 is the most powerful database in the universe, I suppose there must be such functions... |
Why would you believe this. . . 
DB2 has the biggest market share for mainframe database products, but that has nothing to do with being a "powerful database".
As many have said - If DB2 was not an IBM product, it would have been pulled from the market many, many years ago.
d |
|
| Back to top |
|
|
|
|
