Engine Database Schema | Sun Microsystems 3 specification

Appendix B

Engine Database Schema

This appendix documents the engine database schema. It lists the database tables and the specification of each, according to the following categories:

•current state tables

•registration tables

•history log tables

The tables are grouped first by category, and then alphabetically within each category. For an alphabetical listing of all tables, see “Alphabetical Listing of Tables” on page 329.

Database Tables by Category

The tables comprising the engine database are listed in the following table. They are grouped into the following categories: current state, registration, and history log tables.

Current State Tables	Registration Tables	History Log Tables

	WFHRegistration	WFHRegistrationLog
	WFHAlias	WFHAliasLog
WFHProcess		WFHProcessLog*
		WFHProcessStateLog*
WFHProcAttributes		WFHProcAttribLog*
WFHLocks		WFHAttribLockLog*

* corresponds to History log configuration options. See “How to Configure a New Engine” on page 95.

327

Image 327

Sun Microsystems 3 manual Engine Database Schema, Database Tables by Category

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 IPlanet Integration Server Documentation Online HelpDocumentation Roadmap 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 Full Configuration Failover and Load Balancing Combined IIS ProcessEngine 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 SoftwareSetting Up and Maintaining Central Development Repositories Managing iIS Process Engines Managing RegistrationManaging Process Execution IIS Console IIS Process Management Tools Repository Management Tools Dump/Restore FacilitiesConductor Script Utility Custom System 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 Setting Up an iIS Process System IIS Process System Setup ProcedureTo set up an iIS process system IIS Installation Program Central Server Installation DLL 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 SystemTo add a new node to an iIS system To create a new iIS Repository Server Moving an iIS EngineCreating a New iIS Repository Server Moving an iIS Repository Server Creating a Private iIS Repository Upgrading an iIS SystemTo create a private iIS Repository on a development node Uninstalling an iIS System Overview IIS Console Overview To start the iIS Console on UNIX, OpenVMS, or Windows NT Using the cconsole CommandStarting the iIS Console To start the iIS Console on Windows or Windows NT IPlanet UDS System Management Guide for information about IIS Console Main Window Off Engine is configured but has not been started Main Viewing PanelOnline Engine has fully started and is online Mouse Popup Menu Menu Bar Setting Password Protection for iIS Console To set a password for iIS ConsoleExiting iIS Console To turn automatic refresh off or on Using iIS Console WindowsUsing the Mouse Window Refresh Behavior Filtering iIS Console Lists To set the automatic refresh intervalTo force an immediate refresh 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 Logtimers DbservicesNodenameservicenamepriority Databaseuserpassword Governormemoryflag DbservicememoryflagDbservicestacksize Unitrecovercursorsize Unitsessionreconnectaction Customizing Engine Database SchemaMonitordisplaylimit Unitsessionreconnectlimit 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 To delete an engine configuration Duplicating an Engine ConfigurationDeleting an Engine Configuration To duplicate an engine configuration Governor Starting an Engine Engine Unit IdleBoth Embryonic OnlineStandby Primary Engine Unit Startup Phases Database Service InformpartnerStartupcomplete To start an engine How to Start an Engine Data on To start individual engine components Reconfiguring an Engine How to Reconfigure an EngineTo 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 To check the engine runtime configuration Monitoring Engines and Engine ComponentsMonitoring the Engine To monitor individual engine components Monitoring Engine Components Unit Startup Phases on Property Description Changing Engine States Changing Engine Unit StatesTo change the state of an engine unit About Recovering State Information Database Management Issues Managing an Engine DatabaseShutting Down Engine Components Recovering Data Growth of the DatabaseFailure 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 Wfdrdatafile Dump/Restore Environment VariablesWfdrengine Wfdrdirectory 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 Viewing Registrations for an Engine Unregistering AliasesTo unregister an alias Unregistering a Distribution To view the registrations for a given engineTo unregister a registered distribution 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 Engine Sessions ActiveSuspended Reconnectioninprogress Disrupted Sessions Reconnectprohibited SuspendTerminate Reconnectallowed Explicitly Terminated Sessions Explicitly Suspended Sessions Activity States PendingReady 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 Aborted Process Instances Monitoring and Managing Engine SessionsProcess Instance Termination Completed Process Instances To obtain state information about a session Monitoring the State of a Session Monitoring and Managing Engine Sessions Managing Sessions Suspending or Terminating SessionsTo suspend a session Sending and Broadcasting Messages to Sessions To terminate a sessionTo send a message to an active session Monitoring and Managing Engine Sessions To broadcast a message to all sessions Monitoring and Managing Process Execution Session Managing Process Instances Checking the Status of a Process InstanceTo check the current execution 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 To view the contents of an activity queue Managing Activity QueuesChecking the Status of an Activity Queue 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 Removing a Process Attribute Lock To change the value of a process attributeTo remove a process attribute lock To find a process bottleneck Checking for Bottlenecks in Process Execution Analyzing Process Execution Created History Log SchemaState Values Preparecreate Terminated Monitoring and Managing Two-Phase CommitOFF Expired 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 Using the iIS Console Trace Window Setting Message FiltersTo open the iIS Console Trace window To set message filters for a selected engine IIS Console Engine Event Filter Window Special Example Write Client Messages to Trace WindowTo set the engine tracing Using the iIS Console Engine Event Filter Window Engine Event TypesTo open the Engine Event Filter window To view all engine events for an existing process Displaying All Engine EventsDisplaying Process Instance Events To view all engine events for the selected engine Events for the specified process instance display Performance Charts Filtering Engine EventsTo specify a custom filter Viewing Performance Indicators To view performance indicators for an engine Performance Charts Logging Performance Information To log performance informationTo stop logging performance information Page Using the Conductor Script Utility Starting Conductor Script Conductor Script HelpTo start Conductor Script on Windows or Windows NT 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 Monitoring and Managing Engine Sessions To suspend or terminate a sessionTo send a message to one or more sessions Send a message with To check the status of a process instance Monitoring and Managing Process ExecutionManaging Process Instances Managing Activity Instances To list the contents of an activity queue Managing Activity QueuesTo reprioritize an activity in a queue To check the value or lock state of a process attribute Managing TimersTo check the status of a timer Managing Process Attributes 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 FindNode FindParentEngineFindPrimary FlushLog FindUnit IIOPServer ListActivitiesListActivityQueues ListConductorDistributions ListEngines ListFiltersListProcesses Options ListRegistrations ListTimers ListSessionsListTransactions 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 Nolinkeduser Actname VARCHAR264Abortraction NUMBER38 Wuser VARCHAR264 Not VARCHAR264 Activityname VARCHAR264Tokcounter NUMBER38 Wuser Not NUMBER38 Table B-7 Table B-10 WFHLocks Table B-9 WFHControl Attvalue VARCHAR2255 Locktype NUMBER38Atttype NUMBER38 Attseglength NUMBER38 Table B-12 Table B-12 WFHProcess Table B-15 Table B-13 Actionflag NUMBER38 Seqnumber Not NUMBER38Null Processid NUMBER38 Reqstatus NUMBER38 Table B-19 WFHSession Engine VARCHAR264 Table B-20Not VARCHAR2158 Environment VARCHAR264 Attsegmentid NUMBER38 Table B-23 WFHTimerTimername State Relativetime Not NUMBER38 Null Attname VARCHAR264 Table B-24 Registration TablesTable B-23 Currelativetime VARCHAR232 Wusage Createtime History Log TablesLibraryname Not VARCHAR232 Loadoptions Projectname Table B-27 Table B-26Processid NUMBER38 Logtime Date Table B-29 WFHAliasLog Table B-28 WFHAlarmLogAlarmtype VARCHAR264 Details VARCHAR2255 Table B-31 Table B-30 Table B-32 Activepage Not NUMBER38 Allocatepage Not NUMBER38Table B-33 Table B-34 Parentprocid NUMBER38Parentprocid Table B-36 Table B-35 Sessname VARCHAR264 Table B-38 WFHTimerLogTimername VARCHAR264 Table B-37 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