I am trying to implement DB2 parallel server on two nodes (may expand
later). I have a few questions on the design phase.
Our application is similar to an ASP model.
We have one small table which has one entry for each of our clients.
table: MTAB ( client# int primary key,
contact .) -- main entry point for every clients
We have few large tables and many medium to small tables. 95% of the
tables will have client# as the part of the primary key. (the tables
are say, CTAB1 CTAB2 etc). PKeys are composite of ...