Manuals / Sun Microsystems / Computer Equipment / Network Router

Sun Microsystems manual Table B-35, Table B-36

Models: 3

1 368

Download 368 pages 47.9 Kb

Page 354

Database Schema Reference

Table B-35	WFHProcessStateLog
Name	Index Null? Type	Description

ID	NUMBER(38)	Unique identifier for the process instance
		in this engine.
STATE	NUMBER(38)	New state of the process instance:
		405	– WFProcess.PREPARE_CREATE
		410	– WFProcess.CREATED
		420	– WFProcess.ACTIVE
		430	– WFProcess.COMPLETED
		435	– WFProcess.PREPARE_ABORT
		440	– WFProcess.ABORTED
LOGTIME	DATE	Time of this logging.

Table B-36	WFHRegistrationLog
Name	Index Null?	Type	Description

APPLICATIONID		VARCHAR2(32)	Name of the installed application for this
			iIS plan.
COMPATIBILITYLEVEL		NUMBER(38)	Compatibility level of the installed
			library of this iIS plan.
PROJECTNAME		VARCHAR2(67)	Name of the generated TOOL project of
			the compiled iIS plan.
REGISTRATIONNAME		VARCHAR2(64)	Name of the source iIS plan from which
			the iIS component is derived.
TYPE		NUMBER(38)	Type of iIS plan:
			151-Process Definition
			152-Validation
			153-Assignment Rule
			154-User Profile
OBSOLETE		NUMBER(38)	Internal use only.

354 iPlanet Integration Server • Process System Guide • August 2001

Image 354

Sun Microsystems manual Table B-35, Table B-36

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 ChangeAudience for This Guide Organization of This GuideText Conventions ALL CapsOther Documentation Resources Syntax StatementsIPlanet Integration Server Documentation Online HelpDocumentation Roadmap IIS Example Programs To copy the documentation to a client or serverTo view and search the documentation Toolbar Button Keyboard Command What Is an iIS Process Engine? Introduction iIS Process ManagementWhat Is an iIS Process Engine? Multiple Engine Systems Workshops Minimal Engine Configuration IIS Process Engine Components2Minimal Engine Configuration Failover Configuration 3Engine Configuration with FailoverIIS Process Engine Components Full Configuration Failover and Load Balancing Combined IIS ProcessEngine What Does an iIS Process Engine Do? Setting up and Maintaining an iIS System IIS Process Management TasksSetting 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 Process Management Tools IIS ConsoleCustom System Management Tools Dump/Restore FacilitiesConductor Script Utility 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 BackboneProcess System Software Modules Details, see , Using the Conductor Compiled and Interpreted Engine Components Setccomp.sh True FalseIIS 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 Engine Server Installation DLLDevelopment Client Installation Configuring and Starting Your iIS Engines Runtime Client InstallationMaintaining an iIS Process System Adding New Nodes to an iIS SystemTo add a new node to an iIS system Moving an iIS Repository Server Moving an iIS EngineCreating a New iIS Repository Server To create a new iIS Repository ServerCreating a Private iIS Repository Upgrading an iIS SystemTo create a private iIS Repository on a development node Uninstalling an iIS System IIS Console OverviewOverview To start the iIS Console on Windows or Windows NT Using the cconsole CommandStarting the iIS Console To start the iIS Console on UNIX, OpenVMS, or Windows NTIIS Console Main Window IPlanet UDS System Management Guide for information aboutOff Engine is configured but has not been started Main Viewing PanelOnline Engine has fully started and is online Menu Bar Mouse Popup MenuSetting Password Protection for iIS Console To set a password for iIS ConsoleExiting iIS Console Window Refresh Behavior Using iIS Console WindowsUsing the Mouse To turn automatic refresh off or onFiltering iIS Console Lists To set the automatic refresh intervalTo force an immediate refresh Operators Specifying ValuesExample Filter Expression Sorting iIS Console Lists Using List Views 2iIS Console BrowserIIS Console Main Window Command Summary Environment MenuView Menu Engine MenuMonitor Menu Help Menu Page Managing Engines Production Engines Versus Development EnginesProduction Engines Versus Development Engines Configuring an Engine Engine Component Partitioning1Engine Configuration with both Failover and Load Balancing Configuring an Engine Engine Startup Properties 2Typical Engine Partitioning SchemeConfiguring an Engine Engine Configuration File Sample configuration file is reproduced belowDatabaseuserpassword DbservicesNodenameservicenamepriority LogtimersUnitrecovercursorsize DbservicememoryflagDbservicestacksize GovernormemoryflagUnitsessionreconnectlimit Customizing Engine Database SchemaMonitordisplaylimit UnitsessionreconnectactionFORTEROOT/sysdata/conductr/clN/environment/enginename.dbs How to Configure a New Engine Code ExampleTo 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 duplicate an engine configuration Duplicating an Engine ConfigurationDeleting an Engine Configuration To delete an engine configurationStarting an Engine GovernorEngine Unit IdleBoth Embryonic OnlineStandby Primary Engine Unit Startup Phases Database Service InformpartnerStartupcomplete How to Start an Engine To start an engineData on To start individual engine components Reconfiguring an Engine How to Reconfigure an EngineTo reconfigure an engine Reconfiguring an Engine How to Dynamically Modify Database Logging To modify database logging for an engineHow to Tune Process Execution Monitoring and Changing Engine States To check the engine runtime configuration Monitoring Engines and Engine ComponentsMonitoring the Engine Monitoring Engine Components To monitor individual engine componentsUnit 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 and Restoring Data Dumping Database TablesUsing the Dump/Restore Application To use the Dump/Restore application to dump database tablesManaging 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 Wfdrdirectory Dump/Restore Environment VariablesWfdrengine WfdrdatafileManaging Registrations About RegistrationAbout Registration What Does Registration Do? Install distribution on engine nodes Registration in Production Environments What Does Unregistration Do? Engine Registration ManagerAbout Aliases 2Subprocess Activity ReferencesRegistering iIS Distributions Registration Order Performing RegistrationsTo register one or more distributions using the iIS Console Upgrading Registrations Unregistering iIS DistributionsRegistering 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 Monitoring Instances of a Registered Process Definition To monitor instances of a registered process definitionPerforming Application Upgrades Monolithic Upgrades To perform a monolithic upgradeRolling Upgrades To perform a rolling upgradePage Managing Process Execution IntroductionEngine Sessions ActiveSuspended Disrupted Sessions ReconnectioninprogressReconnectallowed SuspendTerminate ReconnectprohibitedExplicitly Suspended Sessions Explicitly Terminated SessionsActivity States PendingReady Completed AbortedActivity State Process Execution Activity TypesProcess Instance Creation Process Instance Execution Activity CreationActivity Execution Offered ActivitiesQueued Activities Subprocess Activities Activity Termination Automatic ActivitiesCompleted Activities Completed Process Instances Monitoring and Managing Engine SessionsProcess Instance Termination Aborted Process InstancesMonitoring the State of a Session To obtain state information about a sessionMonitoring 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 Monitoring and Managing Process Execution To broadcast a message to all sessionsSession 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 Aborting a Process Instance To abort a process instanceManaging Activity Instances Checking the Status of an ActivityChanging 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 Reprioritizing a Queued Activity To reprioritize a queued activityMonitoring and Managing Process Execution Managing Timer Instances Checking the Status of a TimerChanging the Timer State and Expiration Time To change the state and expiration time of a timerManaging Process Attributes Checking the Value and Lock State of a Process AttributeChanging a Process Attribute Value Removing a Process Attribute Lock To change the value of a process attributeTo remove a process attribute lock Checking for Bottlenecks in Process Execution To find a process bottleneckAnalyzing Process Execution Preparecreate History Log SchemaState Values CreatedExpired Monitoring and Managing Two-Phase CommitOFF TerminatedIIS 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 serviceTo unregister an engine from the Alarm service To filter alarms in the Process Engine Alarms windowViewing Alarms To search for an alarm in the Process Engine Alarms windowTo get detailed information about an alarm To remove an alarm from the Alarm windowEngine Log Files To view an engine component log file IIS Console Trace Window Messages and Message FiltersSpecifying Message Filters 1Specifying iPlanet UDS Message Output FiltersIIS Message Filters Message type trc debugUsing 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 the selected engine Displaying All Engine EventsDisplaying Process Instance Events To view all engine events for an existing processEvents 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 Using the Cscript Command To start Conductor Script on UNIX, OpenVMS, or Windows NTWorking with Conductor Script General Conductor Script Operations See SetPathWriting and Executing Scripts CommentsOperating System and File Management Commands FileCopy a specified file in the local file system Managing iIS Process Engines with Conductor Script Starting an EngineTo start an engine where delays might be involved Starting Individual Engine ComponentsStart 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 DistributionsTo make an iIS library distribution Include a plan as a Registering iIS Library Distributions To register an iIS distribution with an engineUnregistering iIS Library Distributions To unregister an iIS distribution from an engine Unregister the specified Alias from the current EngineManaging 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 Managing Activity Instances Monitoring and Managing Process ExecutionManaging Process Instances To check the status of a process instanceTo list the contents of an activity queue Managing Activity QueuesTo reprioritize an activity in a queue Managing Process Attributes Managing TimersTo check the status of a timer To check the value or lock state of a process attributeChecking for Bottlenecks in Process Execution To remove an attribute lockPlace the specified activity List all existing event filters for Current engine Monitoring and Managing Two-Phase Commit Transactions Monitoring Two-Phase Commit OperationsManaging Two-Phase Commit Operations Commits the in-progressTo resolve transactions after a client or engine failure Conductor Script Commands Conductor Script Command SummaryEnvironment 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 UnitConductor Script Commands AbortActivityAbortAllProcesses AbortProcessBroadcastMessage CommitTransactionCompleteActivity ConsultActivityActivity instance to be delegated CreateActivity CreateFilter Event TypeObject Class Object InstanceDelegateActivity ExamplesActive FindDBService DeleteFilterFindEngine FindGovernorFindNode FindParentEngineFindPrimary FindUnit FlushLogIIOPServer ListActivitiesListActivityQueues ListConductorDistributions ListEngines ListFiltersListProcesses ListRegistrations OptionsListTimers ListSessionsListTransactions MakeConductorDistribution ModLogFlagsReadyActivity RegisterAlias RegisterAssignmentRulesRegisterProcessDefinition RegisterUserProfileRegisterValidation RemoveReadLock RemoveWriteLockRollbackActivity RollbackTransactionSendMessage CriticalSetPassword SetAttributeValueSetPrimary SetQueuedActivityPrioritySetTimer SetStateSetTimerDeadline SetTimerElapsed ShowActivityShowActivityQueue ShowConfiguration ShowEngineShowLogFlags ShowProcessShowSession ShowStatus EngineEngine unit Primary engine unit Instrument Description ShowTimer Shutdown StartActivityStartDBService StartEngineStartGovernor StartTimer StartUnitTable A-2StartUnit Command Options StopTimer SuspendAllSessionsSuspendSession TerminateAllSessionsUninstall TerminateSessionUnRegisterAlias UnRegisterAssignmentRulesUnRegisterProcessDefinition UnRegisterUserProfile WaitForStartupConductor Script Commands Page Engine Database Schema Database Tables by CategoryDatabase Tables by Category Alphabetical Listing of Tables WFHActivityUsersDatabase Table See… Description Database Schema Reference WFHSessionRoleCurrent State Tables Table B-2Table B-3 Wuser VARCHAR264 Actname VARCHAR264Abortraction NUMBER38 NolinkeduserWuser Not NUMBER38 Activityname VARCHAR264Tokcounter NUMBER38 Not VARCHAR264Table B-7 Table B-9 WFHControl Table B-10 WFHLocksAttseglength NUMBER38 Locktype NUMBER38Atttype NUMBER38 Attvalue VARCHAR2255Table B-12 Table B-12 WFHProcess Table B-13 Table B-15Reqstatus NUMBER38 Seqnumber Not NUMBER38Null Processid NUMBER38 Actionflag NUMBER38Table B-19 WFHSession Environment VARCHAR264 Table B-20Not VARCHAR2158 Engine VARCHAR264Null Attname VARCHAR264 Table B-23 WFHTimerTimername State Relativetime Not NUMBER38 Attsegmentid NUMBER38Currelativetime VARCHAR232 Registration TablesTable B-23 Table B-24Loadoptions Projectname History Log TablesLibraryname Not VARCHAR232 Wusage CreatetimeLogtime Date Table B-26Processid NUMBER38 Table B-27Details VARCHAR2255 Table B-28 WFHAlarmLogAlarmtype VARCHAR264 Table B-29 WFHAliasLogTable B-30 Table B-31Table B-32 Activepage Not NUMBER38 Allocatepage Not NUMBER38Table B-33 Table B-34 Parentprocid NUMBER38Parentprocid Table B-35 Table B-36Table B-37 Table B-38 WFHTimerLogTimername VARCHAR264 Sessname VARCHAR264Table B-39 Relativetime VARCHAR232State Values Page Index Section B Section D Section E 284 Section L Section Q See also recovery 309 Section U