ca.portal.admin

DB Segmentation

Discussion created by ca.portal.admin on Feb 10, 2006
Once again I would like to tap into the vast knowledge pool that is
IDMS-L.

We are considering a major modification to an existing IDMS database.
Due to the growth of the data within IDMS, we are considering splitting
this database into several smaller entities. Example: all customers
whose accounts start with ""1"" go into DB1, accounts that start with ""2""
go into DB2, etc. Some mechanism would be used (system exit or
programmatically) to determine which database is accessed and stored.

Are there any other IDMS shops out there doing something like this?
Would you be willing to discuss this topic with me and let us know the
benefits and pitfalls you are aware of?

Thanks in advance.

Dan Hall
GE
Capital Solutions
Danbury, CT

T 513.217.5060
E dan.hall@ge.com
http://www.ge.com/capitalsolutions/

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
RE : DB Segmentation
"I use the same thecnic but instead of using a flat file( i assume the flat file is used for keeping track of the dbk of the direct records) the direct records, stored physically for marking the separation of two parts of the area, are defined via an indexed set sorted on the dbkey of the direct record or sorted on the no of the separator stored in the direct record.

Michel Lamoureux.
Quebec Police Force
Canada


-----Message d'origine-----
De : IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM] De la part de WHITE, RICK
Envoyé : 10 février 2006 10:40
À : IDMS-L@LISTSERV.IUASSN.COM
Objet : Re: DB Segmentation


Dan,
We currently split our database into four segments by storing 4 database records in the area via a direct mode store. The programs that sweep the database read flat file and go to that record directly then sweep until the logical point. This method allows 4 program to sweep and update the database concurrently. I am not sure this is exactly what you are asking but I thought I would provide you the information.

Rick White
850-453-4141 x1486
Database Administrator
DFAS TSOPE
Pensacola, FL

Outcomes