The JobRun table contains details of information about the IBM InfoSphere DataStage and QualityStage jobs that have run or are currently running. Column name RunType Column Type Code Reference (Ref) Column Description Column distinguishes a normal run from a validate or reset run. Source View runtyperef Source View Structure RUNTYPECODE Varchar(3 OCTETS) RUNTYPENAME Varchar(32 OCTETS) RUNTYPEDESCRIPTION Varchar(255 OCTETS) Current Values RUNTYPECODE RUNTYPENAME RUNTYPEDESCRIPTION ?!? Invalid value A non-numeric value was found ??? Unknown value An out-of-range numeric value was found RES Reset Reset run RUN Run Normal run mode VAL Validate Validation-only run Related Links JobRun table Job run audit …
Tag
Showing: 1 - 2 of 2 RESULTS
PureData
Data Warehouse – Effective Practices
Effective Practices Effective practices are enablers, which can improve performance, data availability, environment stability, resource consumption, and data accuracy. Use of an Enterprise Scheduler The scheduling service in InfoSphere Information Server (IIS) leverages the operating system (OS) scheduler, the common enterprise scheduler can provide these capabilities beyond those of a common OS scheduler: Centralized control, monitoring, and maintenance of job stream processes Improved insight into and control of cycle processes Improved intervention capabilities, including alerts, job stream suspension, auto-restarts, and upstream/downstream dependency monitoring Reduced time-to-recovery and increased flexibility in recovery options Improved ability to monitor and alert for a mission-critical …