Filter
Top Products
36 DB2 Manager User Guide
StorageTek Proprietary
ENVCNTL: OBJSIZE
OBJSIZE = nnnnn
Requirement: Optional
Default: 1000
Validation: 'nnnnn' = a 1- to 5-digit numeric value in the range 1-65535.
Use: The OBJSIZE parameter is used to specify the maximum
number of migrated rows to be stored per Archive Manager
object.
Notes: Increasing the maximum number of rows which may be stored
per Archive Manager object will reduce the size of the primary
index file required for indexing objects in the Archive Manager
database, but will add a little overhead to the time taken to
retrieved a migrated row from the database.
During row retrieval processing, Archive Manager will first of
all locate the start of the object containing the migrated row,
using a high-speed block locate process, then process the
object sequentially until the logical record containing the
migrated row is encountered. A larger number of migrated
rows (i.e. logical records) per object will increase the average
time taken to perform this sequential record locate process.
Note that the value specified (or defaulted) here for the global
OBJSIZE parameter will be used in conjunction with the
OTDBP100 COMMIT parameter specified during table
migration processing, in order to determine the number of
rows to be stored per object in the Archive Manager database.
The actual number of rows per objects will be the lower of the
two values (COMMIT or OBJSIZE).
ENVCNTL: READTIMEOUT
READTIMEOUT = nnnn
Requirement: Optional
Default: 10
Validation: ‘nnnn’ = a 1- to 4-digit numeric value in the range 1-1440.
Use: The READTIMEOUT parameter specifies the maximum
number of minutes that the SQL intercept routine is to wait for
a response from the control region, during row retrieval
processing. If no request is received within this time, the