Alphabetical Listing of Tables | Sun Microsystems 3 guide

Alphabetical Listing of Tables

Alphabetical Listing of Tables

The following is an alphabetical list of all tables created in the engine database, with a page reference to details about each.

Table B-1Engine Database Tables

Database Table	See…	Description

WFHActiveTimer	page 332	Active timers that are not in memory.
WFHActivity	page 332	Activity instances that are current in the engine.
WFHActivityLog	page 348	Log of activity instances (both current and past)
		in the system.
WFHActivityTokens	page 335	Activity token counts—number of times the
		activity has completed—that are current in the
		system.
WFHActivityUsers	page 335	Activity link information: who has completed
		some activity. A row is held representing each
		activity that is listed as the activity link in some
		other activity.
WFHActStateLog	page 348	Log of state changes in activity instances in the
		engine.
WFHAlarmLog	page 349	A log of all alarms generated on this engine,
		recorded whenever history logging is turned on.
WFHAlias	page 346	Aliases currently registered with the engine.
WFHAliasLog	page 349	A log of aliases registered with the engine.
WFHAssignment	page 336	Used by the engine to track the stack of
		assignment rules generated by ConsultActivity
		and DelegateActivity method calls from client
		applications.
WFHAttribLockLog	page 350	Log of access obtained on all instances of process
		attributes.
WFHColdStart	page 336	System maintained table used by the engine
		before performing a cold start.
WFHColdStartLog	page 350	Always contains one row showing the last time
		the engine was cold started (thus dropping and
		re-creating all registration, state, and log tables).
WFHComplexRule	page 337	Used by the engine to track activities that
		contain complex assignment rules (assignment
		rules with custom Evaluate methods).

Appendix B Engine Database Schema 329

Image 329

Sun Microsystems 3 manual Alphabetical Listing of Tables, WFHActivityUsers

Contents

Process System Guide Page Contents Setting Up an iIS Process Management System Managing Engines Managing Registrations 137 Managing Process Execution 157 Troubleshooting 203 Appendix a Conductor Script Commands 261 Conductor Script Commands Conductor Script Commands Index List of Figures IPlanet Integration Server Process System Guide August List of Procedures IPlanet Integration Server Process System Guide August List of Procedures IPlanet Integration Server Process System Guide August Product Name Change Preface Organization of This Guide Audience for This Guide ALL Caps Text Conventions Syntax Statements Other Documentation Resources Documentation Roadmap IPlanet Integration Server DocumentationOnline Help To copy the documentation to a client or server IIS Example Programs To view and search the documentation Toolbar Button Keyboard Command Introduction iIS Process Management What Is an iIS Process Engine? What Is an iIS Process Engine? Multiple Engine Systems Workshops IIS Process Engine Components Minimal Engine Configuration 2Minimal Engine Configuration 3Engine Configuration with Failover Failover Configuration IIS Process Engine Components Engine Full Configuration Failover and Load Balancing CombinedIIS Process What Does an iIS Process Engine Do? IIS Process Management Tasks Setting up and Maintaining an iIS System Setting Up and Maintaining Central Development Repositories Setting Up an iPlanet UDS Runtime EnvironmentInstalling iIS Process Management Software Managing Process Execution Managing iIS Process EnginesManaging Registration IIS Console IIS Process Management Tools Conductor Script Utility Dump/Restore FacilitiesCustom System Management Tools Repository Management ToolsPage Setting Up an iIS Process Management System Preparation Setting up an iPlanet UDS Runtime Environment IIS Process System Components IIS Process Engines IIS Backbone IIS Process System Software Process System Software Modules Details, see , Using the Conductor Setccomp.sh True False Compiled and Interpreted Engine Components IIS Process System Configuration IIS Process System Software 2iIS Process System Configuration IIS Function Node type Server/Client Node Names To set up an iIS process system Setting Up an iIS Process SystemIIS Process System Setup Procedure IIS Installation Program Central Server Installation DLL Engine Server Installation Development Client Installation Runtime Client Installation Configuring and Starting Your iIS Engines To add a new node to an iIS system Maintaining an iIS Process SystemAdding New Nodes to an iIS System Creating a New iIS Repository Server Moving an iIS EngineMoving an iIS Repository Server To create a new iIS Repository Server To create a private iIS Repository on a development node Creating a Private iIS RepositoryUpgrading an iIS System Uninstalling an iIS System Overview IIS Console Overview Starting the iIS Console Using the cconsole CommandTo start the iIS Console on Windows or Windows NT To start the iIS Console on UNIX, OpenVMS, or Windows NT IPlanet UDS System Management Guide for information about IIS Console Main Window Online Engine has fully started and is online Off Engine is configured but has not been startedMain Viewing Panel Mouse Popup Menu Menu Bar Exiting iIS Console Setting Password Protection for iIS ConsoleTo set a password for iIS Console Using the Mouse Using iIS Console WindowsWindow Refresh Behavior To turn automatic refresh off or on To force an immediate refresh Filtering iIS Console ListsTo set the automatic refresh interval Specifying Values Operators Example Filter Expression Sorting iIS Console Lists 2iIS Console Browser Using List Views Environment Menu IIS Console Main Window Command Summary Engine Menu View Menu Monitor Menu Help Menu Page Production Engines Versus Development Engines Managing Engines Production Engines Versus Development Engines Engine Component Partitioning Configuring an Engine 1Engine Configuration with both Failover and Load Balancing Configuring an Engine 2Typical Engine Partitioning Scheme Engine Startup Properties Configuring an Engine Sample configuration file is reproduced below Engine Configuration File Nodenameservicenamepriority DbservicesDatabaseuserpassword Logtimers Dbservicestacksize DbservicememoryflagUnitrecovercursorsize Governormemoryflag Monitordisplaylimit Customizing Engine Database SchemaUnitsessionreconnectlimit Unitsessionreconnectaction FORTEROOT/sysdata/conductr/clN/environment/enginename.dbs Code Example How to Configure a New Engine To configure a new engine Property Description Configuring an Engine Configuring an Engine Configuring an Engine Minimum number of pages managed by the memory manager Configuring an Engine Process execution options are the following Deleting an Engine Configuration Duplicating an Engine ConfigurationTo duplicate an engine configuration To delete an engine configuration Governor Starting an Engine Both Engine UnitIdle Standby EmbryonicOnline Primary Engine Unit Startup Phases Startupcomplete Database ServiceInformpartner To start an engine How to Start an Engine Data on To start individual engine components To reconfigure an engine Reconfiguring an EngineHow to Reconfigure an Engine Reconfiguring an Engine To modify database logging for an engine How to Dynamically Modify Database Logging How to Tune Process Execution Monitoring and Changing Engine States Monitoring the Engine To check the engine runtime configurationMonitoring Engines and Engine Components To monitor individual engine components Monitoring Engine Components Unit Startup Phases on Property Description To change the state of an engine unit Changing Engine StatesChanging Engine Unit States About Recovering State Information Shutting Down Engine Components Database Management IssuesManaging an Engine Database Failure of the Database Recovering DataGrowth of the Database Dumping Database Tables Dumping and Restoring Data To use the Dump/Restore application to dump database tables Using the Dump/Restore Application Managing an Engine Database Managing an Engine Database Using the Dump Command-line Utility Restoring Database Tables Preserving Engine Database Schema Customizations Follow the instructions under Dumping Database Tables on Managing an Engine Database Using the Restore Command-line Utility Wfdrengine Dump/Restore Environment VariablesWfdrdirectory Wfdrdatafile About Registration Managing Registrations About Registration What Does Registration Do? Install distribution on engine nodes Registration in Production Environments Engine Registration Manager What Does Unregistration Do? 2Subprocess Activity References About Aliases Registering iIS Distributions Performing Registrations Registration Order To register one or more distributions using the iIS Console Unregistering iIS Distributions Upgrading Registrations Registering Aliases To register an alias using the iIS Console To unregister an alias Viewing Registrations for an EngineUnregistering Aliases To unregister a registered distribution Unregistering a DistributionTo view the registrations for a given engine To monitor instances of a registered process definition Monitoring Instances of a Registered Process Definition Performing Application Upgrades To perform a monolithic upgrade Monolithic Upgrades To perform a rolling upgrade Rolling UpgradesPage Introduction Managing Process Execution Suspended Engine SessionsActive Reconnectioninprogress Disrupted Sessions Terminate SuspendReconnectallowed Reconnectprohibited Explicitly Terminated Sessions Explicitly Suspended Sessions Ready Activity StatesPending Aborted Completed Activity State Activity Types Process Execution Process Instance Creation Activity Creation Process Instance Execution Offered Activities Activity Execution Queued Activities Subprocess Activities Automatic Activities Activity Termination Completed Activities Process Instance Termination Monitoring and Managing Engine SessionsCompleted Process Instances Aborted Process Instances To obtain state information about a session Monitoring the State of a Session Monitoring and Managing Engine Sessions To suspend a session Managing SessionsSuspending or Terminating Sessions To send a message to an active session Sending and Broadcasting Messages to SessionsTo terminate a session Monitoring and Managing Engine Sessions To broadcast a message to all sessions Monitoring and Managing Process Execution Session To check the current execution status of a process instance Managing Process InstancesChecking the Status of a Process Instance Monitoring and Managing Process Execution Monitoring and Managing Process Execution To abort a process instance Aborting a Process Instance Checking the Status of an Activity Managing Activity Instances Changing the State of an Activity To change the state of an activity Checking the Status of an Activity Queue To view the contents of an activity queueManaging Activity Queues To reprioritize a queued activity Reprioritizing a Queued Activity Monitoring and Managing Process Execution Checking the Status of a Timer Managing Timer Instances To change the state and expiration time of a timer Changing the Timer State and Expiration Time Checking the Value and Lock State of a Process Attribute Managing Process Attributes Changing a Process Attribute Value To remove a process attribute lock Removing a Process Attribute LockTo change the value of a process attribute To find a process bottleneck Checking for Bottlenecks in Process Execution Analyzing Process Execution State Values History Log SchemaPreparecreate Created OFF Monitoring and Managing Two-Phase CommitExpired Terminated IIS Process Engine Operations Monitoring and Managing Two-Phase Commit Managing Two-Phase Commit Operations Troubleshooting Introduction Process Engine Alarms Window To register an engine with the alarm service Monitoring Alarms To filter alarms in the Process Engine Alarms window To unregister an engine from the Alarm service To search for an alarm in the Process Engine Alarms window Viewing Alarms To remove an alarm from the Alarm window To get detailed information about an alarm Engine Log Files To view an engine component log file Messages and Message Filters IIS Console Trace Window 1Specifying iPlanet UDS Message Output Filters Specifying Message Filters Message type trc debug IIS Message Filters To open the iIS Console Trace window Using the iIS Console Trace WindowSetting Message Filters To set message filters for a selected engine To set the engine tracing IIS Console Engine Event Filter WindowSpecial Example Write Client Messages to Trace Window To open the Engine Event Filter window Using the iIS Console Engine Event Filter WindowEngine Event Types Displaying Process Instance Events Displaying All Engine EventsTo view all engine events for the selected engine To view all engine events for an existing process Events for the specified process instance display To specify a custom filter Performance ChartsFiltering Engine Events Viewing Performance Indicators To view performance indicators for an engine Performance Charts To stop logging performance information Logging Performance InformationTo log performance information Page Using the Conductor Script Utility To start Conductor Script on Windows or Windows NT Starting Conductor ScriptConductor Script Help To start Conductor Script on UNIX, OpenVMS, or Windows NT Using the Cscript Command Working with Conductor Script See SetPath General Conductor Script Operations Comments Writing and Executing Scripts File Operating System and File Management Commands Copy a specified file in the local file system Starting an Engine Managing iIS Process Engines with Conductor Script Starting Individual Engine Components To start an engine where delays might be involved Start all components Example Manual Startup Scenario Monitoring Engines and Engine Components Monitoring Individual Engine Components FindDBService State Making iIS Library Distributions Managing Registrations with Conductor Script To make an iIS library distribution Include a plan as a To register an iIS distribution with an engine Registering iIS Library Distributions Unregistering iIS Library Distributions Unregister the specified Alias from the current Engine To unregister an iIS distribution from an engine Managing Process Execution with Conductor Script To send a message to one or more sessions Monitoring and Managing Engine SessionsTo suspend or terminate a session Send a message with Managing Process Instances Monitoring and Managing Process ExecutionManaging Activity Instances To check the status of a process instance To reprioritize an activity in a queue To list the contents of an activity queueManaging Activity Queues To check the status of a timer Managing TimersManaging Process Attributes To check the value or lock state of a process attribute To remove an attribute lock Checking for Bottlenecks in Process Execution Place the specified activity List all existing event filters for Current engine Monitoring Two-Phase Commit Operations Monitoring and Managing Two-Phase Commit Transactions Commits the in-progress Managing Two-Phase Commit Operations To resolve transactions after a client or engine failure Conductor Script Command Summary Conductor Script Commands Environment Mode Engine Component Mode Environment Mode Commands Engine Mode Commands Engine Management Start the specified Engine Mode Commands Process Execution Management Abort all process instances Current engine Delegate the specified offered Activity from Pending to Set the specified timer to Component Mode Commands Engine Unit Generic component AbortActivity Conductor Script Commands AbortProcess AbortAllProcesses CommitTransaction BroadcastMessage ConsultActivity CompleteActivity Activity instance to be delegated CreateActivity Event Type CreateFilter Object Instance Object Class Examples DelegateActivity Active DeleteFilter FindDBService FindGovernor FindEngine FindPrimary FindNodeFindParentEngine FlushLog FindUnit ListActivityQueues IIOPServerListActivities ListConductorDistributions ListProcesses ListEnginesListFilters Options ListRegistrations ListTransactions ListTimersListSessions ModLogFlags MakeConductorDistribution ReadyActivity RegisterAssignmentRules RegisterAlias RegisterUserProfile RegisterProcessDefinition RegisterValidation RemoveWriteLock RemoveReadLock RollbackTransaction RollbackActivity Critical SendMessage SetAttributeValue SetPassword SetQueuedActivityPriority SetPrimary SetState SetTimer SetTimerDeadline ShowActivity SetTimerElapsed ShowActivityQueue ShowEngine ShowConfiguration ShowProcess ShowLogFlags ShowSession Engine ShowStatus Engine unit Primary engine unit Instrument Description ShowTimer StartActivity Shutdown StartEngine StartDBService StartGovernor StartUnit StartTimer Table A-2StartUnit Command Options SuspendAllSessions StopTimer TerminateAllSessions SuspendSession TerminateSession Uninstall UnRegisterAssignmentRules UnRegisterAlias UnRegisterProcessDefinition WaitForStartup UnRegisterUserProfile Conductor Script Commands Page Database Tables by Category Engine Database Schema Database Tables by Category WFHActivityUsers Alphabetical Listing of Tables Database Table See… Description WFHSessionRole Database Schema Reference Table B-2 Current State Tables Table B-3 Abortraction NUMBER38 Actname VARCHAR264Wuser VARCHAR264 Nolinkeduser Tokcounter NUMBER38 Activityname VARCHAR264Wuser Not NUMBER38 Not VARCHAR264 Table B-7 Table B-10 WFHLocks Table B-9 WFHControl Atttype NUMBER38 Locktype NUMBER38Attseglength NUMBER38 Attvalue VARCHAR2255 Table B-12 Table B-12 WFHProcess Table B-15 Table B-13 Null Processid NUMBER38 Seqnumber Not NUMBER38Reqstatus NUMBER38 Actionflag NUMBER38 Table B-19 WFHSession Not VARCHAR2158 Table B-20Environment VARCHAR264 Engine VARCHAR264 Timername State Relativetime Not NUMBER38 Table B-23 WFHTimerNull Attname VARCHAR264 Attsegmentid NUMBER38 Table B-23 Registration TablesCurrelativetime VARCHAR232 Table B-24 Libraryname Not VARCHAR232 History Log TablesLoadoptions Projectname Wusage Createtime Processid NUMBER38 Table B-26Logtime Date Table B-27 Alarmtype VARCHAR264 Table B-28 WFHAlarmLogDetails VARCHAR2255 Table B-29 WFHAliasLog Table B-31 Table B-30 Table B-32 Table B-33 Activepage Not NUMBER38Allocatepage Not NUMBER38 Parentprocid Table B-34Parentprocid NUMBER38 Table B-36 Table B-35 Timername VARCHAR264 Table B-38 WFHTimerLogTable B-37 Sessname VARCHAR264 Relativetime VARCHAR232 Table B-39 State Values Page Index Section B Section D Section E 284 Section L Section Q See also recovery 309 Section U