Re: JOB_INFO when system job tables are really large.

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

Agreed.  To paraphrase, when the DB2 services work, they're very, very 
good, but when they are broke they are horrid.  :)

Maybe they need a way to store more robust error information that you 
could access with a variant of GET DIAGNOSTICS.


On 1/3/2019 8:19 AM, Rob Berendt wrote:
> Joe,
>
> I took your words to heart and tried again.
>
> I removed the WHERE clause and put it into the UDTF parms.  I also used
> other UDTF parms and I'm getting further
> SELECT JOB_NAME, JOB_STATUS, JOB_LOG_PENDING, J.*
> FROM TABLE(QSYS2.JOB_INFO(
>      JOB_USER_FILTER =>'<redacted>',
>      JOB_STATUS_FILTER => '*OUTQ',
>      JOB_TYPE_FILTER => '*BATCH'
>      )) J
> FETCH first 100 ROWS ONLY;
>
> I can chunk this however I still thing IBM could improve the error
> handling for this API
>
> Rob Berendt