Partitioning on DB2 for OS/390 (z/OS) is completely different than on DB2 for Linux, UNIX, and Windows.
Partitioning on DB2 for OS/390 is range partitioning, which is not even available (yet) on DB2 for Linux, UNIX, and Windows (range partitioning will be available in V9).
Partitioning on DB2 for Linux, UNIX, and Windows is primarily for the purposes of parallel processing where it is common for queries to require complete table scans. The partitioning scheme is called hash partitioning.
I don't think you will encounter any performance problems with inserts or updates on DB2 for OS/390. But you should avoid frequent updating of the partitioning key, which would cause the row to have to be moved from one partition to the other.
Check out the DB2 for OS/390 manuals to read about partitioned tablespaces. Make sure you don't confuse it with partitioning available on DB2 for Linux, UNIX, and Windows (which is a different product).
Last edited by Marcus_A; 03-24-06 at 23:17.
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390