RE: Table Split based on columns

How deep are your pockets?
If they are infinitely deep then you might want to look at the option DB2 Multisystem. Don't let the name "Multisystem" confuse you. There are options in there IBM will NOT unbundle, like the option to have partitioned tables on a single system. You may know "partitions" as "members". With a partitioned table you can create a table which will automatically assign rows to the correct partition based on date/quarter. See the partitioning clause at https://www.ibm.com/docs/en/i/7.4?topic=statements-create-table
You only get the partitioning clause if you have DB2 Multisystem installed.
IBM's classic examples involve tables created for history temporal tables. Allows you to get by things like maximum rows by using multiple partitions(members). Need to purge history? Simply drop a partition.

We are not using DB2 Multisystem.

If you really go whole hog on DB2 Multisystem you can partition so that the tables are spread across multiple systems (hence the name). For example each warehouse might have their own system and their partition would be local to their warehouse. Allows you to query all warehouses by addressing a single table.
People who do this kind of stuff want us to pick up their bill by purchasing DB2 Multisystem for just doing partitioning on a single system. Spread the development cost around.

Rob Berendt