Manuals / Sun Microsystems / Computer Equipment / Network Router

Sun Microsystems 3 manual Table B-19 WFHSession

Models: 3

1 368

Download 368 pages 47.9 Kb

Page 343

Database Schema Reference

Table B-18WFHSessAttributes

Name	Index	Null?	Type	Description

SESSIONID	✔	NOT	NUMBER(38)	Identifier for the session between the
		NULL		engine and client application.
ATTNAME		NOT	VARCHAR2(64)	Name of a process attribute in the
		NULL		session.
ATTTYPE		NOT	NUMBER(38)	The type of the process attribute.
		NULL
ATTSEGMENTID		NOT	NUMBER(38)	Internal use only.
		NULL
ATTSEGLENGTH		NOT	NUMBER(38)	Internal use only.
		NULL
ATTVALUE		NOT	VARCHAR2(255)	The value of the attribute (in text
		NULL		format).
SETNUMBER	✔	NOT	NUMBER(38)	Internal use only.
		NULL

Table B-19 WFHSession

Name	Index	Null?	Type	Description

ID	✔	NOT	NUMBER(38)	Unique identifier for this client session.
		NULL
SESSNAME			VARCHAR2(64)	The session name.
USERNAME			VARCHAR2(64)	The user name of the user on the session.
PROFILENAME			VARCHAR2(64)	The profile name of the user on the
				session.
STATE			NUMBER(38)	The state of the session:
				210 – WFSession.ACTIVE
				220 – WFSession.SUSPENDED
SESSMODE			NUMBER(38)	Internal use only.
SESSTXID			VARCHAR2(255)	The transaction ID, used only in iIS
				two-phase commit operations.
OTHERINFO			VARCHAR2(64)	The otherInfo attribute associated with a
				user profile.

Appendix B Engine Database Schema 343

Image 343

Sun Microsystems 3 manual Table B-19 WFHSession

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 PrefaceOrganization of This Guide Audience for This GuideALL Caps Text ConventionsSyntax Statements Other Documentation ResourcesOnline Help IPlanet Integration Server DocumentationDocumentation Roadmap To copy the documentation to a client or server IIS Example ProgramsTo 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 Configuration2Minimal Engine Configuration 3Engine Configuration with Failover Failover ConfigurationIIS Process Engine Components IIS Process Full Configuration Failover and Load Balancing CombinedEngine What Does an iIS Process Engine Do? IIS Process Management Tasks Setting up and Maintaining an iIS SystemInstalling iIS Process Management Software Setting Up an iPlanet UDS Runtime EnvironmentSetting Up and Maintaining Central Development Repositories Managing Registration Managing iIS Process EnginesManaging Process Execution IIS Console IIS Process Management ToolsRepository 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 SoftwareProcess System Software Modules Details, see , Using the Conductor Setccomp.sh True False Compiled and Interpreted Engine ComponentsIIS Process System Configuration IIS Process System Software 2iIS Process System Configuration IIS Function Node type Server/Client Node Names IIS Process System Setup Procedure Setting Up an iIS Process SystemTo set up an iIS process system IIS Installation Program Central Server Installation DLL Engine Server InstallationDevelopment Client Installation Runtime Client Installation Configuring and Starting Your iIS EnginesAdding New Nodes to an iIS System Maintaining an iIS Process 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 ServerUpgrading an iIS System Creating a Private iIS RepositoryTo create a private iIS Repository on a development node Uninstalling an iIS System Overview IIS ConsoleOverview 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 NTIPlanet UDS System Management Guide for information about IIS Console Main WindowMain Viewing Panel Off Engine is configured but has not been startedOnline Engine has fully started and is online Mouse Popup Menu Menu BarTo set a password for iIS Console Setting Password Protection for iIS ConsoleExiting iIS Console To turn automatic refresh off or on Using iIS Console WindowsUsing the Mouse Window Refresh BehaviorTo set the automatic refresh interval Filtering iIS Console ListsTo force an immediate refresh Specifying Values OperatorsExample Filter Expression Sorting iIS Console Lists 2iIS Console Browser Using List ViewsEnvironment Menu IIS Console Main Window Command SummaryEngine Menu View MenuMonitor Menu Help Menu Page Production Engines Versus Development Engines Managing EnginesProduction Engines Versus Development Engines Engine Component Partitioning Configuring an Engine1Engine Configuration with both Failover and Load Balancing Configuring an Engine 2Typical Engine Partitioning Scheme Engine Startup PropertiesConfiguring an Engine Sample configuration file is reproduced below Engine Configuration FileLogtimers DbservicesNodenameservicenamepriority DatabaseuserpasswordGovernormemoryflag DbservicememoryflagDbservicestacksize UnitrecovercursorsizeUnitsessionreconnectaction Customizing Engine Database SchemaMonitordisplaylimit UnitsessionreconnectlimitFORTEROOT/sysdata/conductr/clN/environment/enginename.dbs Code Example How to Configure a New EngineTo 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 configurationGovernor Starting an EngineIdle Engine UnitBoth Online EmbryonicStandby Primary Engine Unit Startup Phases Informpartner Database ServiceStartupcomplete To start an engine How to Start an EngineData on To start individual engine components How to Reconfigure an Engine Reconfiguring an EngineTo reconfigure an engine Reconfiguring an Engine To modify database logging for an engine How to Dynamically Modify Database LoggingHow to Tune Process Execution Monitoring and Changing Engine States Monitoring Engines and Engine Components To check the engine runtime configurationMonitoring the Engine To monitor individual engine components Monitoring Engine ComponentsUnit Startup Phases on Property Description Changing Engine Unit States Changing Engine StatesTo change the state of an engine unit About Recovering State Information Managing an Engine Database Database Management IssuesShutting Down Engine Components Growth of the Database Recovering DataFailure of the Database Dumping Database Tables Dumping and Restoring DataTo use the Dump/Restore application to dump database tables Using the Dump/Restore ApplicationManaging 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 WfdrdirectoryAbout Registration Managing RegistrationsAbout 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 AliasesRegistering iIS Distributions Performing Registrations Registration OrderTo register one or more distributions using the iIS Console Unregistering iIS Distributions Upgrading RegistrationsRegistering Aliases To register an alias using the iIS Console Unregistering Aliases Viewing Registrations for an EngineTo unregister an alias To view the registrations for a given engine Unregistering a DistributionTo unregister a registered distribution To monitor instances of a registered process definition Monitoring Instances of a Registered Process DefinitionPerforming Application Upgrades To perform a monolithic upgrade Monolithic UpgradesTo perform a rolling upgrade Rolling UpgradesPage Introduction Managing Process ExecutionActive Engine SessionsSuspended Reconnectioninprogress Disrupted SessionsReconnectprohibited SuspendTerminate ReconnectallowedExplicitly Terminated Sessions Explicitly Suspended SessionsPending Activity StatesReady Aborted CompletedActivity State Activity Types Process ExecutionProcess Instance Creation Activity Creation Process Instance ExecutionOffered Activities Activity ExecutionQueued Activities Subprocess Activities Automatic Activities Activity TerminationCompleted Activities Aborted Process Instances Monitoring and Managing Engine SessionsProcess Instance Termination Completed Process InstancesTo obtain state information about a session Monitoring the State of a SessionMonitoring and Managing Engine Sessions Suspending or Terminating Sessions Managing SessionsTo suspend a session To terminate a session Sending and Broadcasting Messages to SessionsTo send a message to an active session Monitoring and Managing Engine Sessions To broadcast a message to all sessions Monitoring and Managing Process ExecutionSession Checking the Status of a Process Instance Managing Process InstancesTo 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 InstanceChecking the Status of an Activity Managing Activity InstancesChanging the State of an Activity To change the state of an activity Managing Activity Queues To view the contents of an activity queueChecking the Status of an Activity Queue To reprioritize a queued activity Reprioritizing a Queued ActivityMonitoring and Managing Process Execution Checking the Status of a Timer Managing Timer InstancesTo change the state and expiration time of a timer Changing the Timer State and Expiration TimeChecking the Value and Lock State of a Process Attribute Managing Process AttributesChanging a Process Attribute Value To change the value of a process attribute Removing a Process Attribute LockTo remove a process attribute lock To find a process bottleneck Checking for Bottlenecks in Process ExecutionAnalyzing Process Execution Created History Log SchemaState Values PreparecreateTerminated Monitoring and Managing Two-Phase CommitOFF ExpiredIIS 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 AlarmsTo filter alarms in the Process Engine Alarms window To unregister an engine from the Alarm serviceTo search for an alarm in the Process Engine Alarms window Viewing AlarmsTo remove an alarm from the Alarm window To get detailed information about an alarmEngine Log Files To view an engine component log file Messages and Message Filters IIS Console Trace Window1Specifying iPlanet UDS Message Output Filters Specifying Message FiltersMessage type trc debug IIS Message FiltersSetting Message Filters Using the iIS Console Trace WindowTo open the iIS Console Trace window To set message filters for a selected engine Special Example Write Client Messages to Trace Window IIS Console Engine Event Filter WindowTo set the engine tracing Engine Event Types Using the iIS Console Engine Event Filter WindowTo 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 engineEvents for the specified process instance display Filtering Engine Events Performance ChartsTo specify a custom filter Viewing Performance Indicators To view performance indicators for an engine Performance Charts To log performance information Logging Performance InformationTo stop logging performance information Page Using the Conductor Script Utility Conductor Script Help Starting Conductor ScriptTo start Conductor Script on Windows or Windows NT To start Conductor Script on UNIX, OpenVMS, or Windows NT Using the Cscript CommandWorking with Conductor Script See SetPath General Conductor Script OperationsComments Writing and Executing ScriptsFile Operating System and File Management CommandsCopy a specified file in the local file system Starting an Engine Managing iIS Process Engines with Conductor ScriptStarting Individual Engine Components To start an engine where delays might be involvedStart 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 ScriptTo make an iIS library distribution Include a plan as a To register an iIS distribution with an engine Registering iIS Library DistributionsUnregistering iIS Library Distributions Unregister the specified Alias from the current Engine To unregister an iIS distribution from an engineManaging Process Execution with Conductor Script To suspend or terminate a session Monitoring and Managing Engine SessionsTo 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 InstancesManaging Activity Queues To list the contents of an activity queueTo 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 AttributesTo remove an attribute lock Checking for Bottlenecks in Process ExecutionPlace the specified activity List all existing event filters for Current engine Monitoring Two-Phase Commit Operations Monitoring and Managing Two-Phase Commit TransactionsCommits the in-progress Managing Two-Phase Commit OperationsTo resolve transactions after a client or engine failure Conductor Script Command Summary Conductor Script CommandsEnvironment 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 componentAbortActivity Conductor Script CommandsAbortProcess AbortAllProcessesCommitTransaction BroadcastMessageConsultActivity CompleteActivityActivity instance to be delegated CreateActivity Event Type CreateFilterObject Instance Object ClassExamples DelegateActivityActive DeleteFilter FindDBServiceFindGovernor FindEngineFindParentEngine FindNodeFindPrimary FlushLog FindUnitListActivities IIOPServerListActivityQueues ListConductorDistributions ListFilters ListEnginesListProcesses Options ListRegistrationsListSessions ListTimersListTransactions ModLogFlags MakeConductorDistributionReadyActivity RegisterAssignmentRules RegisterAliasRegisterUserProfile RegisterProcessDefinitionRegisterValidation RemoveWriteLock RemoveReadLockRollbackTransaction RollbackActivityCritical SendMessageSetAttributeValue SetPasswordSetQueuedActivityPriority SetPrimarySetState SetTimerSetTimerDeadline ShowActivity SetTimerElapsedShowActivityQueue ShowEngine ShowConfigurationShowProcess ShowLogFlagsShowSession Engine ShowStatusEngine unit Primary engine unit Instrument Description ShowTimer StartActivity ShutdownStartEngine StartDBServiceStartGovernor StartUnit StartTimerTable A-2StartUnit Command Options SuspendAllSessions StopTimerTerminateAllSessions SuspendSessionTerminateSession UninstallUnRegisterAssignmentRules UnRegisterAliasUnRegisterProcessDefinition WaitForStartup UnRegisterUserProfileConductor Script Commands Page Database Tables by Category Engine Database SchemaDatabase Tables by Category WFHActivityUsers Alphabetical Listing of TablesDatabase Table See… Description WFHSessionRole Database Schema ReferenceTable B-2 Current State TablesTable B-3 Nolinkeduser Actname VARCHAR264Abortraction NUMBER38 Wuser VARCHAR264Not VARCHAR264 Activityname VARCHAR264Tokcounter NUMBER38 Wuser Not NUMBER38Table B-7 Table B-10 WFHLocks Table B-9 WFHControlAttvalue VARCHAR2255 Locktype NUMBER38Atttype NUMBER38 Attseglength NUMBER38Table B-12 Table B-12 WFHProcess Table B-15 Table B-13Actionflag NUMBER38 Seqnumber Not NUMBER38Null Processid NUMBER38 Reqstatus NUMBER38Table B-19 WFHSession Engine VARCHAR264 Table B-20Not VARCHAR2158 Environment VARCHAR264Attsegmentid NUMBER38 Table B-23 WFHTimerTimername State Relativetime Not NUMBER38 Null Attname VARCHAR264Table B-24 Registration TablesTable B-23 Currelativetime VARCHAR232Wusage Createtime History Log TablesLibraryname Not VARCHAR232 Loadoptions ProjectnameTable B-27 Table B-26Processid NUMBER38 Logtime DateTable B-29 WFHAliasLog Table B-28 WFHAlarmLogAlarmtype VARCHAR264 Details VARCHAR2255Table B-31 Table B-30Table B-32 Allocatepage Not NUMBER38 Activepage Not NUMBER38Table B-33 Parentprocid NUMBER38 Table B-34Parentprocid Table B-36 Table B-35Sessname VARCHAR264 Table B-38 WFHTimerLogTimername VARCHAR264 Table B-37Relativetime VARCHAR232 Table B-39State Values Page Index Section B Section D Section E 284 Section L Section Q See also recovery 309 Section U