How To
Summary
You may find the p1 pending reason in table grid_jobs_pendreasons and the type column in (15, 2) are the job's p1 pending reasons.
Take one job 1234 as an example, if you want to get the p1 pending reasons from RTM database, the SQL is like below:
select t1.reason,t1.subreason,t1.type,t2.reason from grid_jobs_pendreasons t1 join grid_jobs_pendreason_maps t2 on t1.reason = t2.reason_code and t1.subreason = t2.sub_reason_code where jobid=1234 and type in (15,2) order by type desc;
If you want to find a finished job's pending reason, please replace the table grid_jobs_pendreasons with grid_jobs_pendreasons_finished_v<partition number>.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZT2D","label":"IBM Spectrum LSF RTM"},"Component":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
10 December 2018
UID
ibm10717769