What is the best way to partition a table whose primary key is a sequential number? DB2 9 for z / OS
Txs!
Partition table
- Anuj Dhawan
- Founder
- Posts: 2802
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: Partition table
Fom DB2 V8 you can separate the LIMITKEY from the INDEX, so you can partition based on batch parallelism and have the limitkey defined on a completely set-off columns/s – that is TCP.
PS.: Sorry for a late reply.
PS.: Sorry for a late reply.
Thanks,
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
-
- Global Moderator
- Posts: 588
- Joined: Wed Nov 20, 2013 11:53 am
- Location: Mars
Re: Partition table
What is the growth rate and what is the possibility of purging old data?
zprogrammer
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute