Administration and Programming Guide for OS/390
You need to create the dynamic Web page dependency table and
install several stored procedures before you can begin to use Net.Data
to manage your cached Web pages and large objects.
- The dynamic Web page dependency table contains information about the LOB
files stored in HFS and about the relationship that these files may have, if
any, to Web pages stored in the dynamic Web page cache.
- Create the LOB dependency table, SYSIBM.DTWCACHEDEPS, using the SQL
found in DTW220.SDTWSPUF(DTWCRCCH). This file also includes SQL
statements to create a database, called DTWCACHE, and a tablespace, called
DTWTBSP1, for the Web dependency table.
The database and tablespace have the same names as those created when you
enable Net.Data for Web page caching (see Step 2: Set Up the Web Page Cache).
- Define the stored procedure used to insert the dependency information into
SYSIBM.DTWCACHEDEPS. The stored procedure is found in
DTW220.SDTWLOAD(DTWDEPIN).
- Copy the stored procedure into your stored procedure library.
- Define the stored procedure into DB2 UDB Server for OS/390 V6 using the
SQL found in DTW220.SDTWSPUF(DTWCCHV6).
- Bind the stored procedure's DBRM DTW220.SDTWDBRM (DTWV22DP)
into the package DTWCACHEPKG using a user ID with INSERT, SELECT, and DELETE
privileges on SYSIBM.DTWCACHEDEPS. The user IDs associated with
the requests that retrieve LOBs must have EXECUTE privilege on the package
DTWCACHEPKG.
The JCL for this step is located in
DTW220.SDTWBASE(DTWDEPBD).
- Create the stored procedure that performs automatic management of the Web
page cache and LOBs.
- Define the stored procedure. The stored procedure can be found in
DTW220.SDTWLOAD(DTWCLEAN).
- Copy the stored procedure into your stored procedure library.
- Define the stored procedure.
- The SQL to define the stored procedure into DB2 for OS/390 V5 is found in
DTW220.SDTWSPUF(DTWCLNV5).
- The SQL to define the stored procedure into DB2 UDB Server for OS/390 V6
is found in DTW220.SDTWSPUF(DTWCLNV6).
- Bind the stored procedure's DBRM DTW220.SDTWDBRM (DTWV22CL)
into the package DTWCACHEPKG using a user ID with DELETE privilege on
SYSIBM.DTWCACHEDPAGES and SYSIBM.DTWCACHEDEPS. The user
IDs that execute the macro must have EXECUTE privilege on the package
DTWCACHEPKG.
The JCL for this step is located in
DTW220.SDTWBASE(DTWCLNBD).
- Create the stored procedure that is used for more advanced management of
the Web page cache and LOBs.
- Define the stored procedure. The stored procedure is found in
DTW220.SDTWLOAD(DTWMANCL).
- Copy the stored procedure into your stored procedure library.
- Define the stored procedure.
- The SQL to define the stored procedure into DB2 for OS/390 V5 is found in
DTW220.SDTWSPUF(DTWCLNV5).
- The SQL to define the stored procedure into DB2 UDB Server for OS/390 V6
is found in DTW220.SDTWSPUF(DTWCLNV6).
- Bind the stored procedure's DBRM DTW220.SDTWDBRM (DTWV22MN)
into the package DTWCACHEPKG using a user ID with DELETE privilege on
SYSIBM.DTWCACHEDPAGES and on SYSIBM.DTWCACHEDEPS. The
user IDs that execute the cleanup_cache.dtw must have EXECUTE privilege
on the package DTWCACHEPKG.
The JCL for this step is located in
DTW220.SDTWBASE(DTWMANBD).
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]