Previous Topic: Performing CSE CleanupNext Topic: Maintaining CSE Tables and Indexes


Cleaning Up the CSE

Follow these steps:

  1. To determine whether unusable objects or associations exist, execute this query from the encyclopedia DBMS query manager:
        select model_id, model_name, model_status from dmdl
    

    If any returned rows have a model_status of U, the model is unusable; proceed.

  2. Ensure that none of the resource intensive CSE server processes are active.

    Note: For more information, see Resource Intensive Processes.

  3. Run the cleanup command line utility with the following parameters. If you do not specify optional parameters, the values default to the indicated IEFMD environment variables.
        cleanup -u userid
    

    [-p dispatcher name][-v environment][-g encyclopedia group]

    Where:

    userid is the logon ID of the encyclopedia administrator

Optional Parameter

Description

Environment Variable (default)

-p dispatcher name

Name of the Message Dispatcher

IEF_MDNAME (iefmd)

-v environment

 

CSE_ENV

-g group

Encyclopedia group name

IEF_ENCYGROUP (ency)