Mainframe, MVS and zOS Discussion

Posted: **Sat Apr 12, 2014 5:07 am**

What is the best way to partition a table whose primary key is a sequential number? DB2 9 for z / OS

Txs!

Posted: **Fri May 30, 2014 10:37 am**

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.

Posted: **Fri May 30, 2014 2:04 pm**

What is the growth rate and what is the possibility of purging old data?

Mainframe, MVS and zOS Discussion

Partition table

Partition table

Re: Partition table

Re: Partition table