Table B-20, Not VARCHAR2158, Engine VARCHAR264 | Sun Microsystems 3

Database Schema Reference

Table B-20	WFHSessionRole
Name	Index Null?	Type	Description

SESSIONID	NOT	NUMBER(38)	Unique identifier for the client session.
	NULL		Joins to WFHSESSION.ID.
ROLENAME	●	VARCHAR2(64)	A role held by the session.

Table B-21WFHTerminatedProcs

Name	Index	Null?	Type	Description

COMBINEDID	✔	NOT	VARCHAR2(158)	Internal use only.
		NULL
PROCESSID			NUMBER(38)	Unique identifier for a process instance
				in the engine.
ACTIVITYID			NUMBER(38)	Identifier for an activity instance within
				the process instance designated by
				PROCESSID.
ENVIRONMENT			VARCHAR2(64)	The name of the environment the engine
				is running in.
ENGINE			VARCHAR2(64)	The name of the engine.
COLDSEQID			NUMBER(38)	Internal use only.
COMPLETIONCODE			NUMBER(38)	Indicates the completion state of the
				process:
				440 – Aborted
				430 – Completed
USERNAME			VARCHAR2(64)	The user name for the user that started
				the process.
OTHERINFO			VARCHAR2(64)	The otherInfo attribute associated with a
				user profile.

344 iPlanet Integration Server • Process System Guide • August 2001

Image 344

Sun Microsystems manual Table B-20, Not VARCHAR2158, Environment VARCHAR264, Engine VARCHAR264, Completioncode NUMBER38

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 Preface Product Name Change Audience for This Guide Organization of This Guide Text Conventions ALL Caps Other Documentation Resources Syntax Statements Documentation Roadmap IPlanet Integration Server DocumentationOnline Help IIS Example Programs To copy the documentation to a client or server To view and search the documentation Toolbar Button Keyboard Command What Is an iIS Process Engine? Introduction iIS Process Management What Is an iIS Process Engine? Multiple Engine Systems Workshops Minimal Engine Configuration IIS Process Engine Components 2Minimal Engine Configuration Failover Configuration 3Engine Configuration with Failover IIS Process Engine Components Engine Full Configuration Failover and Load Balancing CombinedIIS Process What Does an iIS Process Engine Do? Setting up and Maintaining an iIS System IIS Process Management Tasks 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 Process Management Tools IIS Console Dump/Restore Facilities Conductor Script UtilityCustom 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 Process System Software IIS Backbone Process System Software Modules Details, see , Using the Conductor Compiled and Interpreted Engine Components Setccomp.sh True False 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 Engine Server Installation DLL Development Client Installation Configuring and Starting Your iIS Engines Runtime Client Installation To add a new node to an iIS system Maintaining an iIS Process SystemAdding New Nodes to an iIS System Moving an iIS Engine Creating a New iIS Repository ServerMoving 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 IIS Console Overview Overview Using the cconsole Command Starting the iIS ConsoleTo start the iIS Console on Windows or Windows NT To start the iIS Console on UNIX, OpenVMS, or Windows NT IIS Console Main Window IPlanet UDS System Management Guide for information about Online Engine has fully started and is online Off Engine is configured but has not been startedMain Viewing Panel Menu Bar Mouse Popup Menu Exiting iIS Console Setting Password Protection for iIS ConsoleTo set a password for iIS Console Using iIS Console Windows Using the MouseWindow Refresh Behavior To turn automatic refresh off or on To force an immediate refresh Filtering iIS Console ListsTo set the automatic refresh interval Operators Specifying Values Example Filter Expression Sorting iIS Console Lists Using List Views 2iIS Console Browser IIS Console Main Window Command Summary Environment Menu View Menu Engine Menu Monitor Menu Help Menu Page Managing Engines Production Engines Versus Development Engines Production Engines Versus Development Engines Configuring an Engine Engine Component Partitioning 1Engine Configuration with both Failover and Load Balancing Configuring an Engine Engine Startup Properties 2Typical Engine Partitioning Scheme Configuring an Engine Engine Configuration File Sample configuration file is reproduced below Dbservices NodenameservicenamepriorityDatabaseuserpassword Logtimers Dbservicememoryflag DbservicestacksizeUnitrecovercursorsize Governormemoryflag Customizing Engine Database Schema MonitordisplaylimitUnitsessionreconnectlimit Unitsessionreconnectaction FORTEROOT/sysdata/conductr/clN/environment/enginename.dbs How to Configure a New Engine Code Example 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 Duplicating an Engine Configuration Deleting an Engine ConfigurationTo duplicate an engine configuration To delete an engine configuration Starting an Engine Governor Both Engine UnitIdle Standby EmbryonicOnline Primary Engine Unit Startup Phases Startupcomplete Database ServiceInformpartner How to Start an Engine 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 How to Dynamically Modify Database Logging To modify database logging for an engine How to Tune Process Execution Monitoring and Changing Engine States Monitoring the Engine To check the engine runtime configurationMonitoring Engines and Engine Components Monitoring Engine Components To monitor individual 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 and Restoring Data Dumping Database Tables Using the Dump/Restore Application To use the Dump/Restore application to dump database tables 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 Dump/Restore Environment Variables WfdrengineWfdrdirectory Wfdrdatafile Managing Registrations About Registration About Registration What Does Registration Do? Install distribution on engine nodes Registration in Production Environments What Does Unregistration Do? Engine Registration Manager About Aliases 2Subprocess Activity References Registering iIS Distributions Registration Order Performing Registrations To register one or more distributions using the iIS Console Upgrading Registrations Unregistering iIS Distributions 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 Monitoring Instances of a Registered Process Definition To monitor instances of a registered process definition Performing Application Upgrades Monolithic Upgrades To perform a monolithic upgrade Rolling Upgrades To perform a rolling upgradePage Managing Process Execution Introduction Suspended Engine SessionsActive Disrupted Sessions Reconnectioninprogress Suspend TerminateReconnectallowed Reconnectprohibited Explicitly Suspended Sessions Explicitly Terminated Sessions Ready Activity StatesPending Completed Aborted Activity State Process Execution Activity Types Process Instance Creation Process Instance Execution Activity Creation Activity Execution Offered Activities Queued Activities Subprocess Activities Activity Termination Automatic Activities Completed Activities Monitoring and Managing Engine Sessions Process Instance TerminationCompleted Process Instances Aborted Process Instances Monitoring the State of a Session To obtain state information about 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 Monitoring and Managing Process Execution To broadcast a message to all sessions 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 Aborting a Process Instance To abort a process instance Managing Activity Instances Checking the Status of an Activity 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 Reprioritizing a Queued Activity To reprioritize a queued activity Monitoring and Managing Process Execution Managing Timer Instances Checking the Status of a Timer Changing the Timer State and Expiration Time To change the state and expiration time of a timer Managing Process Attributes Checking the Value and Lock State of a Process Attribute Changing a Process Attribute Value To remove a process attribute lock Removing a Process Attribute LockTo change the value of a process attribute Checking for Bottlenecks in Process Execution To find a process bottleneck Analyzing Process Execution History Log Schema State ValuesPreparecreate Created Monitoring and Managing Two-Phase Commit OFFExpired Terminated IIS Process Engine Operations Monitoring and Managing Two-Phase Commit Managing Two-Phase Commit Operations Troubleshooting Introduction Process Engine Alarms Window Monitoring Alarms To register an engine with the alarm service To unregister an engine from the Alarm service To filter alarms in the Process Engine Alarms window Viewing Alarms To search for an alarm in the Process Engine Alarms window To get detailed information about an alarm To remove an alarm from the Alarm window Engine Log Files To view an engine component log file IIS Console Trace Window Messages and Message Filters Specifying Message Filters 1Specifying iPlanet UDS Message Output Filters IIS Message Filters Message type trc debug 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 All Engine Events Displaying Process Instance 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 Using the Cscript Command To start Conductor Script on UNIX, OpenVMS, or Windows NT Working with Conductor Script General Conductor Script Operations See SetPath Writing and Executing Scripts Comments Operating System and File Management Commands File Copy a specified file in the local file system Managing iIS Process Engines with Conductor Script Starting an Engine To start an engine where delays might be involved Starting Individual Engine Components Start all components Example Manual Startup Scenario Monitoring Engines and Engine Components Monitoring Individual Engine Components FindDBService State Managing Registrations with Conductor Script Making iIS Library Distributions To make an iIS library distribution Include a plan as a Registering iIS Library Distributions To register an iIS distribution with an engine Unregistering iIS Library Distributions To unregister an iIS distribution from an engine Unregister the specified Alias from the current 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 Monitoring and Managing Process Execution Managing Process InstancesManaging 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 Managing Timers To check the status of a timerManaging Process Attributes To check the value or lock state of a process attribute Checking for Bottlenecks in Process Execution To remove an attribute lock Place the specified activity List all existing event filters for Current engine Monitoring and Managing Two-Phase Commit Transactions Monitoring Two-Phase Commit Operations Managing Two-Phase Commit Operations Commits the in-progress To resolve transactions after a client or engine failure Conductor Script Commands Conductor Script Command Summary 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 Generic component Engine Unit Conductor Script Commands AbortActivity AbortAllProcesses AbortProcess BroadcastMessage CommitTransaction CompleteActivity ConsultActivity Activity instance to be delegated CreateActivity CreateFilter Event Type Object Class Object Instance DelegateActivity Examples Active FindDBService DeleteFilter FindEngine FindGovernor FindPrimary FindNodeFindParentEngine FindUnit FlushLog ListActivityQueues IIOPServerListActivities ListConductorDistributions ListProcesses ListEnginesListFilters ListRegistrations Options ListTransactions ListTimersListSessions MakeConductorDistribution ModLogFlags ReadyActivity RegisterAlias RegisterAssignmentRules RegisterProcessDefinition RegisterUserProfile RegisterValidation RemoveReadLock RemoveWriteLock RollbackActivity RollbackTransaction SendMessage Critical SetPassword SetAttributeValue SetPrimary SetQueuedActivityPriority SetTimer SetState SetTimerDeadline SetTimerElapsed ShowActivity ShowActivityQueue ShowConfiguration ShowEngine ShowLogFlags ShowProcess ShowSession ShowStatus Engine Engine unit Primary engine unit Instrument Description ShowTimer Shutdown StartActivity StartDBService StartEngine StartGovernor StartTimer StartUnit Table A-2StartUnit Command Options StopTimer SuspendAllSessions SuspendSession TerminateAllSessions Uninstall TerminateSession UnRegisterAlias UnRegisterAssignmentRules UnRegisterProcessDefinition UnRegisterUserProfile WaitForStartup Conductor Script Commands Page Engine Database Schema Database Tables by Category Database Tables by Category Alphabetical Listing of Tables WFHActivityUsers Database Table See… Description Database Schema Reference WFHSessionRole Current State Tables Table B-2 Table B-3 Actname VARCHAR264 Abortraction NUMBER38Wuser VARCHAR264 Nolinkeduser Activityname VARCHAR264 Tokcounter NUMBER38Wuser Not NUMBER38 Not VARCHAR264 Table B-7 Table B-9 WFHControl Table B-10 WFHLocks Locktype NUMBER38 Atttype NUMBER38Attseglength NUMBER38 Attvalue VARCHAR2255 Table B-12 Table B-12 WFHProcess Table B-13 Table B-15 Seqnumber Not NUMBER38 Null Processid NUMBER38Reqstatus NUMBER38 Actionflag NUMBER38 Table B-19 WFHSession Table B-20 Not VARCHAR2158Environment VARCHAR264 Engine VARCHAR264 Table B-23 WFHTimer Timername State Relativetime Not NUMBER38Null Attname VARCHAR264 Attsegmentid NUMBER38 Registration Tables Table B-23Currelativetime VARCHAR232 Table B-24 History Log Tables Libraryname Not VARCHAR232Loadoptions Projectname Wusage Createtime Table B-26 Processid NUMBER38Logtime Date Table B-27 Table B-28 WFHAlarmLog Alarmtype VARCHAR264Details VARCHAR2255 Table B-29 WFHAliasLog Table B-30 Table B-31 Table B-32 Table B-33 Activepage Not NUMBER38Allocatepage Not NUMBER38 Parentprocid Table B-34Parentprocid NUMBER38 Table B-35 Table B-36 Table B-38 WFHTimerLog Timername VARCHAR264Table B-37 Sessname VARCHAR264 Table B-39 Relativetime VARCHAR232 State Values Page Index Section B Section D Section E 284 Section L Section Q See also recovery 309 Section U