Db2

When running a scheduled report I see an error in the job log related to a missing service program of ours. This service program is in a library other than the data library. How/where do I configure the report scheduler to use a particular user profile or library list?

Error:

(FOC1400) SQLCODE IS -204 (HEX: FFFFFF34) XOPEN: 42704

(FOC1500) : [42704] UBS400UDTF in *LIBL type *SRVPGM not found.

Thanks,

Dan

I don't have much experience with scheduling but it seems the schedule is executed with the owner ID.

"An owner of a schedule can make a schedule available to other members of the top-level folder in which the schedule resides. The schedule owner remains the execution ID."

You would control the library list through run time environment and runtime environment assignments. This is set up in WRKWEBQRY, option 5=Work with Runtime Environments

This is the only documentation about Runtime Environment I was able to find https://www.ibm.com/support/pages/system/files/inline-files/$FILE/DB2%20Web%20Query%20Dynamic%20Runtime%20Environment%20Guide_0.pdf

Runtime environments turned out to be the key. I left off yesterday setting up a new environment and didn't realize that it was going to trickle down to the scheduled report side of things -- but it makes sense that it does.

Thanks for pointing me in the right direction!

Dan