IBM Books

Administration Guide


DB2 File Manager

The following parameters relate to DB2 File Manager:

DataLink Access Token Expiry Interval (dl_expint)

Configuration Type
Database

Parameter Type
Configurable

Default [Range]
60 [ -1, 1 - 31 536 000 ]

Unit of Measure
Seconds

This parameter specifies the interval of time (in seconds) for which the file access token generated is valid. The number of seconds the token is valid begins from the time it is generated. The File Manager Filter checks the validity of the token containing this expiry time.

For information about file access tokens, refer to the DB2 File Manager Quick Beginnings book.

The default value for this parameter is sixty (60) seconds. Minus one (-1) implies that the token will effectively not expire.

This parameter applies to the DATALINK columns which specify "READ PERMISSION DB".

DataLink Number of Backups (dl_num_backup)

Configuration Type
Database

Parameter Type
Configurable

Default [Range]
1 [ 1 - 31 ]

This parameter specifies the number of the most recent DB2 backups for which a File Manager keeps backup information. Files that are unlinked from the database are garbage collected based on this value. A value of one (1) means that the unlinked files are garbage collected at the completion of the next DB2 backup.

The default value for this parameter is one (1) backup.

This parameter applies to the DATALINK columns which specify "Recovery=Yes".

DataLink Number of Copies (dl_num_copies)

Configuration Type
Database

Parameter Type
Configurable

Default [Range]
0 [ 0 - 15 ]

This parameter specifies the number of additional copies of a file to be made in the archive server (such as an ADSM server) when a file is linked to the database.

The default value for this parameter is zero (0).

This parameter applies to the DATALINK columns which specify "Recovery=Yes".

DataLink Time After Drop (dl_time_drop)

Configuration Type
Database

Parameter Type
Configurable

Default [Range]
1 [ 0 - 365 ]

Unit of Measure
Days

This parameter specifies the interval of time (in days) files would be retained on an archive server (such as an ADSM server) after a DROP TABLE, DROP DATABASE, or DROP TABLESPACE is issued.

The default value for this parameter is one (1) day. A value of zero (0) means that the files are deleted immediately from the archive server when the DROP command or statement is issued. (The actual file is not deleted unless the ON UNLINK DELETE parameter was specified for the DATALINK column.)

A non-zero value applies to the DATALINK columns that specify "Recovery=Yes".


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]