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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.