Sun Microsystems 3 History Log Tables

Database Schema Reference

Appendix B Engine Database Schema 347

History Log Tables

The following is an alphabetical list of all history log tables in the engine database.

“State Values” on page 357 lists the possible values for the State field present in

many of the history log tables.

For a description of each of these tables, refer to TableB-1 on page 329.

Table B -25 WFHRegistration

Name Index Null? Type Description

APPLICATIONID ✔NOT

NULL

VARCHAR2(32) Name of the installed application for this

iIS plan.

COMPATIBILITYLEVEL ✔NOT

NULL

NUMBER(38) Compatibility level of the installed

library of this iIS plan.

LIBRARYNAME VARCHAR2(64) Name of the installed library for this iIS

plan.

LOADOPTIONS NUMBER(38) Internal use only.

PROJECTNAME VARCHAR2(67) Name of the generated TOOL project of

the compiled iIS plan.

REGISTRATIONNAME ✔NOT

NULL

VARCHAR2(64) Name of the source iIS plan from which

the iIS component is derived.

TYPE ✔NOT

NULL

NUMBER(38) Type of iIS plan:

151-Process Definition

152-Validation

153-Assignment Rule

154-User Profile

WUSAGE NUMBER(38) Internal use only.

CREATETIME DATE Date and time of registration.

OBSOLETE ✔NOT

NULL

NUMBER(38) Internal use only.

Contents

Main Page Contents Page Page Page Page Page Page Page Page Page List of Figures Page List of Procedures Page Page Page Preface Product Name Change Audience for This Guide Organization of This Guide Text Conventions This section provides information about the conventions used in this document. Syntax Statements Other Documentation Resources iPlanet Integration Server Documentation Online Help Documentation Roadmap iIS Example Programs Viewing and Searching PDF Files Page Page Chapter 1 Introduction: iIS Process Management What Is an iIS Process Engine? Page Multiple Engine Systems Figure 1-1 An iIS Process Management System iIS Process Engine Components Minimal Engine Configuration Page Failover Configuration Page Full Configuration: Failover and Load Balancing Combined What Does an iIS Process Engine Do? iIS Process Management Tasks Setting up and Maintaining an iIS System Setting Up an iPlanet UDS Runtime Environment Installing iIS Process Management Software Setting Up and Maintaining Central Development Repositories Managing iIS Process Engines Managing Registration Managing Process Execution iIS Process Management Tools iIS Console Conductor Script Utility Custom System Management Tools Repository Management Tools Dump/Restore Facilities Page Chapter 2 Setting Up an iIS Process Management System Preparation: Setting up an iPlanet UDS Runtime Environment iIS Process System Components Figure 2-1 Components of an iIS Process System iIS Backbone iIS Process System Software Page Page Compiled and Interpreted Engine Components iIS Process System Configuration Page Figure 2-2 iIS Process System Configuration Page Setting Up an iIS Process System iIS Process System Setup Procedure The iIS Installation Program Central Server Installation Engine Server Installation Development Client Installation Runtime Client Installation Configuring and Starting Your iIS Engines Maintaining an iIS Process System Adding New Nodes to an iIS System Moving an iIS Engine Creating a New iIS Repository Server Moving an iIS Repository Server Creating a Private iIS Repository Upgrading an iIS System Uninstalling an iIS System Chapter 3 The iIS Console Overview Page Starting the iIS Console Using the cconsole Command The iIS Console Main Window Main Viewing Panel Menu Bar Mouse Popup Menu Online Help Setting Password Protection for iIS Console Exiting iIS Console Using iIS Console Windows Using the Mouse Window Refresh Behavior Filtering iIS Console Lists Operators Specifying Values Example Filter Expression Sorting iIS Console Lists Using List Views iIS Console Main Window Command Summary The following tables summarize the commands available from the iIS Console main window. Environment Menu View Menu Engine Menu Monitor Menu Help Menu Page Chapter 4 Managing Engines Production Engines Versus Development Engines NOTE Do not use the same engine for both development and production. Configuring an Engine Engine Component Partitioning Page Page Figure 4-2 Typical Engine Partitioning Scheme Engine Startup Properties Page Engine Configuration File A sample configuration file is reproduced below: The engine properties specified in the configuration file are described in the following table: Page Customizing Engine Database Schema Page How to Configure a New Engine Page Page Page Page Page Page Page Page Duplicating an Engine Configuration Deleting an Engine Configuration Starting an Engine Governor Engine Unit Page Primary Engine Unit Startup Phases Database Service How to Start an Engine Page Page Reconfiguring an Engine How to Reconfigure an Engine Page How to Dynamically Modify Database Logging How to Tune Process Execution Monitoring and Changing Engine States Monitoring Engines and Engine Components Monitoring the Engine Monitoring Engine Components Page Governor In the case of a governor the following information is provided: Database service In the case of a database service the following information is provided: Changing Engine States Changing Engine Unit States About Recovering State Information Shutting Down Engine Components Managing an Engine Database Database Management Issues Growth of the Database Failure of the Database Recovering Data Dumping and Restoring Data Dumping Database Tables Using the Dump/Restore Application Page Page Using the Dump Command-line Utility Restoring Database Tables Preserving Engine Database Schema Customizations Using the Dump/Restore Application Page Using the Restore Command-line Utility Dump/Restore Environment Variables Chapter 5 Managing Registrations About Registration Page What Does Registration Do? Page Registration in Production Environments What Does Unregistration Do? Engine Registration Manager About Aliases Registering iIS Distributions Registration Order Performing Registrations Page Upgrading Registrations Unregistering iIS Distributions Registering Aliases Page Unregistering Aliases Viewing Registrations for an Engine Unregistering a Distribution Monitoring Instances of a Registered Process Definition Performing Application Upgrades Monolithic Upgrades Rolling Upgrades Page Chapter 6 Managing Process Execution Introduction Engine Sessions Disrupted Sessions Page Explicitly Suspended Sessions Explicitly Terminated Sessions Activity States Page Figure 6-1 Activity State Transitionsfrom Creation to Termination Activity State Process Execution Step Activity Types Process Execution Process Instance Creation Process Instance Execution Activity Creation Activity Execution Offered Activities Queued Activities Subprocess Activities Automatic Activities Activity Termination Completed Activities Aborted Activities Process Instance Termination Completed Process Instances Aborted Process Instances Monitoring and Managing Engine Sessions Monitoring the State of a Session Page Managing Sessions Suspending or Terminating Sessions Sending and Broadcasting Messages to Sessions Page Monitoring and Managing Process Execution Page Managing Process Instances Checking the Status of a Process Instance Page Page Aborting a Process Instance Managing Activity Instances Checking the Status of an Activity Changing the State of an Activity Page Managing Activity Queues Checking the Status of an Activity Queue Reprioritizing a Queued Activity Page Managing Timer Instances Checking the Status of a Timer Page Managing Process Attributes Checking the Value and Lock State of a Process Attribute Changing a Process Attribute Value Removing a Process Attribute Lock Checking for Bottlenecks in Process Execution Analyzing Process Execution History Log Schema State Values Monitoring and Managing Two-Phase Commit Page Page Managing Two-Phase Commit Operations Chapter 7 Troubleshooting Introduction Page Process Engine Alarms Window Monitoring Alarms Page Viewing Alarms Page Engine Log Files Page iIS Console Trace Window Messages and Message Filters Specifying Message Filters iIS Message Filters Using the iIS Console Trace Window Setting Message Filters Page Special Example: Write Client Messages to Trace Window iIS Console Engine Event Filter Window Engine Event Types Using the iIS Console Engine Event Filter Window Page Page Filtering Engine Events Performance Charts Viewing Performance Indicators Page Page Logging Performance Information Page Chapter 8 Using the Conductor Script Utility Overview Conductor Script Help Starting Conductor Script Using the Cscript Command Working with Conductor Script General Conductor Script Operations Writing and Executing Scripts Comments Operating System and File Management Commands Page Managing iIS Process Engines with Conductor Script Starting an Engine Starting Individual Engine Components Page Example Manual Startup Scenario Monitoring Engines and Engine Components Monitoring the Engine Monitoring Individual Engine Components Page Changing Engine States Changing Engine Unit States Shutting Down Engine Components Managing Registrations with Conductor Script Making iIS Library Distributions Page Page Registering iIS Library Distributions Unregistering iIS Library Distributions Page Managing Process Execution with Conductor Script Monitoring and Managing Engine Sessions Page Monitoring and Managing Process Execution Managing Process Instances Managing Activity Instances Managing Activity Queues Managing Timers Managing Process Attributes Checking for Bottlenecks in Process Execution Page Page Monitoring and Managing Two-Phase Commit Transactions Monitoring Two-Phase Commit Operations Managing Two-Phase Commit Operations Page Appendix A Conductor Script Commands Conductor Script Command Summary Page Environment Mode Commands Engine Mode Commands: Engine Management Page Engine Mode Commands: Process Execution Management Page Page Page Page Component Mode Commands The Conductor Script engine component mode commands work only for the current component. Generic component A few commands work for any current component. One command applies only if the current component is an engine unit. Engine Unit Conductor Script Commands AbortActivity AbortAllProcesses AbortProcess BroadcastMessage CommitTransaction CompleteActivity ConsultActivity Page CreateActivity CreateFilter Event Type Object Class Object Instance Operators Examples DelegateActivity Page DeleteFilter FindDBService FindEngine FindGovernor FindNode FindParentEngine FindPrimary FindUnit FlushLog IIOPServer ListActivities ListActivityQueues ListConductorDistributions ListEngines ListFilters ListProcesses Options ListRegistrations ListSessions ListTimers ListTransactions MakeConductorDistribution ModLogFlags ReadyActivity RegisterAlias RegisterAssignmentRules RegisterProcessDefinition RegisterUserProfile RegisterValidation RemoveReadLock RemoveWriteLock RollbackActivity RollbackTransaction SendMessage SetAttributeValue SetPassword SetPrimary SetQueuedActivityPriority SetState SetTimer SetTimerDeadline SetTimerElapsed ShowActivity ShowActivityQueue ShowConfiguration ShowEngine ShowLogFlags ShowProcess ShowSession ShowStatus engine: engine unit: database service: governor: primary engine unit: Page ShowTimer Shutdown StartActivity StartDBService StartEngine StartGovernor StartTimer StartUnit Page StopTimer SuspendAllSessions SuspendSession TerminateAllSessions TerminateSession Uninstall UnRegisterAlias UnRegisterAssignmentRules UnRegisterProcessDefinition UnRegisterUserProfile WaitForStartup Page Page Appendix B Engine Database Schema Database Tables by Category Page Alphabetical Listing of Tables Page Database Schema Reference Current State Tables Page Page Page Page Page Page Page Page Page Page Page Page Page Registration Tables History Log Tables Page Page Page Page Page Page Page Page Page State Values Page Index A B C D E Page F G H I L M N O P Q R S T U V W