HOME
FAQ Contents
Part 1
Part 2
Part 3
you are here
Part 5
Part 6
Part 7
Part 8
Part 9
Part 10
Part 11
Part 12
|
The ISSUG Infobase contains archived postings from our on-line discussion forums. Nothing here may be quoted without the written permission of the author(s) of the original postings. The Infobase is organised into 12 sections concerning different topics. FAQ content: Ram Malladi |
||
Part 4: Encyclopedia (Host and CSE) 4.1)
CE Performance Gary Stockton We are curious to find out if anyone 'out there' has had cause to partition any of the CE tables, particularly the DASC and DOBJ tables. Our problem is in trying to find a suitable key, without doing anything to the structure of the table. We would preferably like a key that enables both tables to be partitioned efficiently (that, with DB2, must be an oxymoron!) If you have
had any experience with this (good or bad), or any comments of a general
nature pertaining to CE performance and partitioning, please drop me a
line! Darius Panahy The key that we would like to have used is object id, but it used to be the case that some IEF programs directly updated the obj id and therefore this couldn't be used. I don't know if this has been fixed in the later releases of Composer. Regards Darius Panahy
4.2) When to have multiple CSEs? Chris Uttley Currently our only reason for considering a second CSE is the size of the current CSE. We are concerned about backup and recovery times. 1. At what
point is a single CSE no longer effective? I would appreciate comments from others with experience or ideas in this area. Chris Uttley
Hurriyet
Gendj Advantages:
|
|||