Job manager tables

The job manager relies on a set of tables containing job descriptions, execution reports and user management data.

These tables can be created in any SQL database supported by the Adelia runtime and on the following platforms: Windows, AS/400, AIX, Solaris, Linux.

On a non-AS/400 database, tables must be created in the GSSOUM schema.

A set of script files (gestsoum.dbd, gestsoum.gen, gestsoum.dat) is provided with the job manager for creating tables in an existing database.

It is possible to run the Job manager without having to create the GSSOUM schema. For more information, see Deleting a schema.

These tables are as follows:

GSVER/HGVER	Versions table
GSAUTH/HGAUTH	User privilege table
GSID/HGID	IDs table
GSJOBS/HGJOBS	Jobs table
GSJOBS HIST/HGJOBS HIST	Jobs table - History
GSREPORT/HGREPORT	Execution reports table
GSREPORT HIST/HGREPORT HIST	Execution reports table - History
GSPARAM/HGPARAM	Parameters table
GSQUEUES/HGQUEUES	Queues table

Note: the GSSERVERTOP and GSRUNNINGQUEUES tables are reserved for the internal operation of the job manager and are not documented here.

9 pages subordonnées