Net.Data Books

Administration and Programming Guide for OS/390

Setting-up DB2: Creating the Web Page Dependency Table

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.

  1. 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.
    1. 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).

    2. Define the stored procedure used to insert the dependency information into SYSIBM.DTWCACHEDEPS. The stored procedure is found in DTW220.SDTWLOAD(DTWDEPIN).
      1. Copy the stored procedure into your stored procedure library.
      2. Define the stored procedure into DB2 UDB Server for OS/390 V6 using the SQL found in DTW220.SDTWSPUF(DTWCCHV6).
    3. 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).

  2. Create the stored procedure that performs automatic management of the Web page cache and LOBs.
    1. Define the stored procedure. The stored procedure can be found in DTW220.SDTWLOAD(DTWCLEAN).
      1. Copy the stored procedure into your stored procedure library.
      2. 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).
    2. 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).

  3. Create the stored procedure that is used for more advanced management of the Web page cache and LOBs.
    1. Define the stored procedure. The stored procedure is found in DTW220.SDTWLOAD(DTWMANCL).
      1. Copy the stored procedure into your stored procedure library.
      2. 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).
    2. 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 ]