A fix is available
APAR status
Closed as program error.
Error description
Auto-purge of job log set to "Up to previous 3 job runs", at the project level. When I run a DataStage job and there are not 3 existing sets of log files (ie there is nothing yet to auto-purge" I get the following log entry in the job log, immediately following the "Finished Job" log entry. Message:: From previous run DataStage Job 1417 Phantom 10340 [8128] Done : DSD.StageRun DWOASTGLoadWKASG. DWOASTGLoadWKASG.Transform1 1 0/0/2 DataStage Phantom Finished. Retrieve: syntax error. Unexpected symbol. Token was "@ID". Scanned command was SELECT RT_LOG1417 WITH @ID < AND @ID
Local fix
This fix is included in 8.0.1 fix pack 3
Problem summary
**************************************************************** USERS AFFECTED: All platforms: Log purging and running multi-instance jobs. **************************************************************** PROBLEM DESCRIPTION: A status=99 is returned: 1. If a sequence job or dsjob is reporting a status=99 when running multi-instance jobs with auto-purging enabled. 2. If more than 25 instances are run simultaneuosly, a status=99 may returned. 3. If a sequence/dsjob starts many multi-instance jobs and one or more instances are set to reset, the may be a timing windows when a status=99 is returned for the resetting instance. An error code=-99 is returned : 4. If insufficient system resources are available to start a PX job or if the PX job process failed to notify that it has finished. **************************************************************** RECOMMENDATION: Apply patch for APAR JR30015. Changes up to and including JR30015v6 are included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
Fixed sequence/dsjob to get notification that a child job has started before polling for their status. Updated auto-purge logic for cleaning of status information. Added extra check for PX job completion.
Temporary fix
Comments
APAR Information
APAR number
JR30015
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-07-25
Closed date
2008-08-15
Last modified date
2013-07-24
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
CLIENT
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R801 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 October 2021