StorageTek Lifecycle Director DB2 Manager 312564001 User Manual

 

36 

DB2 Manager User Guide 

 StorageTek 

Proprietary 

 
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).  

 
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