StorageTek 312564001 manual Envcntl: Objsize, Envcntl: Readtimeout

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
36		DB2 Manager User Guide
		StorageTek Proprietary