Understanding
Batch Environment
·
Allows
you to RUN pre-programmed routines, either on demand or on a schedule.
·
A
common use of batch environment is generate a report and post it on regular
basis
·
You
can also use batch environment to schedule actual data changes, such as posting
entries to the general ledger.
Terminologies
·
Batch
Environment
o
Data
Bases
o
Batch
Servers
o
Process
Files
o
Clients
to Run batch Routines
o
All
Process Scheduler Servers
·
Batch
Server
o
Host
Machine that host one or more Process Scheduler Servers.
·
Process
Scheduler Server
o
Instance
of set Server Agents that connects to one database
o
Server
Agent
o
PSPRCSRV
is the main server process. Its responsible for queuing the processes that you
request
·
Distribution
Agent
o
PSDSTSRV
is a server process that is responsible for posting files to the report
repository on the web.
·
Process
Files
o
Files
required for defined process for e.g. Crystal Executables etc.
o
Tuxedo
o
Manages
server processes that are part of process scheduler server
o
Report
Repository
o
Place
to distribute the reports so that they are available to the users.
Process Scheduler Server Process
·
BBL
– Bulletin Board Liaison is the controlling process for all other processes on
a process scheduler server.
·
PSPRCSRV
– The Server agent programming running in the background. Its responsible for
starting all server processes. Every 15 secs. it looks into the Process Request
QUE to see if there are any processes scheduled. If nothing is scheduled then
the server agents sleeps for another 15 secs.
·
PSDSTSRV
– When PSPRCSRV detects that a process has finished, it sends PostRequest BEA
Tuxedo service request to the Distribution Agent to initiate the transfer of
the report.
Location of Process Scheduler
Where do
you install the batch server?
Where do
you keep the Process Files?
·
Batch
Server
o
Database
Server
§
Most
Efficient
o
Dedicated
Batch Server
§
Communication
with DB Slowed
o
Application
Server
§
For
scenario where batch processes are scheduled for off hours
·
Process
Files (Executables and Routines/reports)
o
File
Server – All batch servers will be drawing resource from a single consistent
location – But network traffic will increase.
o
Batch
Server – No network traffic , Best performance
Database Tables
- PSPRCSRQST: Row is added in this table when a request is initiated. Process Monitor and Report Monitor uses this table
- PSPRCSQUE: User by the PScheduler Server Agent.
- PSSERVERSTAT: Maintains server status and configuration
- PS_SERVERDEFN: List of parameters used by server agents to setup the process scheduler server when it starts. Information like what types of processes can be run, timings, where information will be distributed etc.
Process Flow
