Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
can we let DB2 REBALANCE partitions automatically???

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Wed Jun 15, 2011 1:14 pm    Post subject: can we let DB2 REBALANCE partitions automatically???
Reply with quote

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.

http://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
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Jun 15, 2011 3:10 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jun 15, 2011 9:23 pm    Post subject: Reply to: can we let DB2 REBALANCE partitions automatically?
Reply with quote

Hello,

Quote:
As DB2 is the most powerful database in the universe, I suppose there must be such functions...
Why would you believe this. . . icon_rolleyes.gif

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Vsam file updated to RLS disabled aut... biswaranjan Parimanik JCL & VSAM 10 Fri May 01, 2015 12:43 pm
No new posts Automatically Zip the txt file in JCL useit All Other Mainframe Topics 6 Thu Nov 20, 2014 2:55 pm
No new posts Deleting the catalog files automatica... Suresh S JCL & VSAM 6 Wed Apr 16, 2014 7:05 am
No new posts JCL to run Automatically in SDSF raj4neo JCL & VSAM 16 Tue Mar 11, 2014 4:37 pm
No new posts Will Job in CA7 cancel automatically? thisak CA Products 2 Thu Aug 29, 2013 10:54 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us