Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. LDAP User Authentication
  16. Auditing
  17. Running Jobs from External Applications
  18. Upgrading Oracle History Data
  19. Upgrading PeopleSoft History Data
  20. Data Archive Maintenance
  21. Storage Classifications
  22. Appendix A: Datetime and Numeric Formatting
  23. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Forming the URL that Calls RunUpdateRetention.jsp

Forming the URL that Calls RunUpdateRetention.jsp

To call
RunUpdateRetention.jsp
, form a URL that includes the required parameters.
  1. Use the following format to form the URL:
    http://<Data Archive Host>:<Data Archive Port>/jsp/RunUpdateRetention.jsp?DEST_REP_NAME=<Destination ILM Repository Name>&ENTITY_ID=<Entity ID>&WHERE_CLAUSE=<WHERE Clause>&EXISTING_POLICY_NAME=<Existing Policy>&NEW_POLICY_NAME=<New Policy>&COMMENTS=<Comments>&USER_NAME=<User Name>
  2. Enter the parameter values and formulate the WHERE_CLAUSE.
    Use the following values in the WHERE_CLAUSE:
    • Brace
      or
      NOBrace
      to indicate the presence or absence of the left brace.
    • Table name and column name separate by a period. For example,
      CUSTOMERS.CUSTOMER_ID
      .
    • Operator
    • Column value or, if the operator is
      IS NULL
      or
      NOT NULL
      , use
      NOValue
      .
    • Brace
      or
      NOBrace
      to indicate the presence or absence of the right brace.
    • AND
      ,
      OR
      , or
      NOCondition
      for condition.
    Each criteria should be separated by four hash (#) symbols. Each value in a criteria should be separated by three hash (#) symbols.
    For example, use the following format to form the WHERE_CLAUSE if you want to set column-level retention based on company ID 1 and customer name John Smith:
    WHERE_CLAUSE=(##CUSTOMERS.CUSTOMERS_ID###EQ###1###NOBrace###false###OR####NOBrace###CUSTOMERS.CUST_FIRST_NAME###EQ###JOHN###)###false###AND####(###CUSTOMERS.CUSTOMERS_ID###EQ###2###NOBrace###false###OR####NOBrace###CUSTOMERS.CUST_LAST_NAME###EQ###SMITH###)###false###NOCondition)
  3. Form the URL.
    Replace the following in the WHERE_CLAUSE:
    • Replace all hash (#) symbols with %23. For example, change
      ###EQ###
      to
      %23%23%23EQ%23%23%23
      .
    • Replace all left parentheses with %28.
    • Replace all left parentheses with %29.
    Example:
    http://10.74.40.37:8080/jsp/RunUpdateRetention.jsp?DEST_REP_NAME=Copy+of+DATES_23_SAND&ENTITY_ID=-2&WHERE_CLAUSE=%28+%28%23%23%23CUSTOMERS.CUSTOMER_ID%23%23%23EQ%23%23%2381077%23%23%23NOBrace%23%23%23false%23%23%23AND%23%23%23%23NOBrace%23%23%23CUSTOMERS.CUSTOMER_ID%23%23%23EQ%23%23%2381081%23%23%23%29%23%23%23false%23%23%23OR%23%23%23%23NOBrace%23%23%23CUSTOMERS.CUSTOMER_ID%23%23%23EQ%23%23%2381089%23%23%23%29%23%23%23false%23%23%23NOCondition&EXISTING_POLICY_NAME=5+Years&NEW_POLICY_NAME=10+Years&COMMENTS=Test&USER_NAME=amadmin&IS_REPORT_REQUIRED=Yes&IS_PAUSE_AFTER_REPORT=Yes

0 COMMENTS

We’d like to hear from you!