Net.Data Books

Administration and Programming Guide for OS/390

Web page cache table and Web page dependency table descriptions

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.

Table 3. SYSIBM.DTWCACHEDPAGES Table

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

Table 4. SYSIBM.DTWCACHEDEPS Table

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


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