Re: how to duplicate this mainframe process on iSeries?

Michael,

I came here from a S/36.  Someone tried, unsuccessfully, to explain 
multiple members to me at COMMON or something before we received our 
machine.  It's one of those things that you sort of take for granted once 
you get your hands on it.  As much as some don't want to admit it, we are 
a visual sort of people.

1 - Yes.
2 - Yes.
3 - You can add more members while accessing one particular one.  Now, 
what happens if you are in the process of doing a read of an override to 
*ALL and someone adds a new member, I am not sure.

Member locking:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/dbp/rbafoconcmbr.htm

With the latest version of the operating system you can even do 
"partitioned tables".  A partitioned table is nothing more than a file 
with multiple members defined by SQL.  The advantage of using SQL is that 
you can set it up so that the system will automatically determine which 
member to add new data into.  For example, if the year of the transaction 
date is 2006 put the data into the 2006 member.
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/dbmult/partitionedtables.htm
You must have DB2 Multisystem installed on your iSeries server in order to 
take advantage of partitioned tables support. There are, however, some 
important differences between DB2 Multisystem and partitioning. DB2 
Multisystem provides two ways to partition your data:
You can create a distributed table to distribute your data across several 
iSeries systems or logical partitions. 
You can create a partitioned table to partition your data into several 
members in the same database table on one system. 


Rob Berendt