If you want to manage the contents of the dynamic Web page cache and
LOB files using techniques different from those provided by Net.Data,
you can access the SYSIBM.DTWCACHEDPAGES and SYSIBM.DTWCACHEDEPS
DB2 tables. The columns for these two tables are described below along
with their data types and descriptions.
Contains the Web pages that are cached and information about
them.
|
INDEXED_KEY: CHAR(250)
| Indexed key for cached page: the first 250 characters of the actual
key
|
ID: INTEGER
| Identifier: an identifier derived from the key
|
ACTUAL_KEY: VARCHAR(4000)
| The actual key of the cached page: the path information, macro,
HTML block name, query string, and form data of the request that generated the
page
|
CREATOR: CHAR(8)
| User ID of creator: user ID associated with the request that
created the cached page
|
CREATION_TIME: TIMESTAMP
| Creation timestamp: date and time of creation of cached
page. It is the same as the CREATION_TIME for any LOBs that the Web
page references
|
EXPIRATION_TIME: TIMESTAMP
| Expiration timestamp: date and time of the expiration of the cached
page (value of CREATION_TIME + lifetime value from the DTW_CACHE_PAGE
directive)
|
SIZE: INTEGER
| Size: size of cached page in bytes
|
USAGE_SCOPE: SMALLINT
| Usage scope: a value of 1 means that the page has a PUBLIC usage
scope and a value of 2 means that the page has a PRIVATE usage scope
|
ORDINAL_POSITION: INTEGER
| Ordinal position of segment: the ordinal position of the Web page
segment within the complete cached page
|
PAGE_SEGMENT VARCHAR(28100) FOR BIT DATA
| Dynamic Web page segment: the ASCII encoded Web page segment
|
Contains information about the LOBs that are referenced by Web
pages.
|
INDEXED_KEY: CHAR(250)
| Indexed key for Web page: first 250 characters of the actual key
|
ID: INTEGER
| Identifier: an identifier derived from the actual key
|
ACTUAL_KEY: VARCHAR(4000)
| The actual key of the cached page: the path information, macro,
HTML block name, query string, and form data of the request that generated the
page
|
FILENAME: VARCHAR(1024)
| Fully qualified HFS filename for the LOB
|
CREATION_TIME: TIMESTAMP
| Creation timestamp: date and time of the creation of the
LOB. Is the same as the CREATION_TIME for the Web page that references
this LOB
|
EXPIRATION_TIME: TIMESTAMP
| Expiration timestamp: date and time for expiration of the LOB
(value of CREATION_TIME + DTW_LOB_LIFETIME configuration value when dynamic
web page caching not in use; value of CREATION_TIME +
max(DTW_LOB_LIFETIME configuration value, lifetime value from DTW_CACHE_PAGE
directive) when dynamic web page caching in use).
|
SIZE: INTEGER
| Size: size of the LOB in bytes
|