
ENVCNTL: OBJSIZE
OBJSIZE = nnnnn
Requirement: Optional
Default: 1000
Validation: 'nnnnn' = a 1- to
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
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 |
| 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 |
36 |
| DB2 Manager User Guide |
|
| StorageTek Proprietary |