I'd like to know if there's a simple way of getting IBM Mainframe DB2 (Version 7 and 8) to use a UTILID which is the same as the Jobname without having to hardcode the value in the JCL. We have hundreds of Utility jobs, and occasionally hit duplicate Utilid problems where people have cloned existing jobs and forgotten to change the Utilid value.
It appears that the only system symbolic that can be used in Batch JCL is &SYSUID. I know Assembler and Rexx can obtain the Jobname at runtime, but then how would I pass it to the EXEC statement in a subsequent step within the same job?
Can you invoke DB2 Utilities directly from Rexx?
The site where I work uses Jes2 and CA-7 job scheduler, but I'm told the latter can't pass any symbolic parameters into my JCL.