I was able to run this successfully in the past -
CALL QSYS.QCMDEXC('SBMJOB CMD(CALL PGM(J09110Z) PARM(P09110Z FORECAST)) JOB(BDFORECAST) JOBQ(QPGMR) USER(FORECAST) INLLIBL(*JOBD)', 000000110.00000)
but now I'm getting the following error:
Error opening connectionERROR [HY000] [IBM][iSeries Access ODBC Driver][DB2 UDB]CPF1338 - Errors occurred on SBMJOB command.
Any ideas what could cause this error message when it worked before? Is this a type of permissions issue on DB2? Or a configuration issue? What port is DB2 going over for its connection? They closed down a bunch of ports here recently. I'm using the i5 Series ODBC client driver. Or - this there something wrong with the command I'm sending?
thanks for your help!
string postCommand = @"CALL QSYS.QCMDEXC('SBMJOB CMD(CALL PGM(J09110Z) PARM(P09110Z FORECAST)) JOB(BDFORECAST) JOBQ(QPGMR) USER(FORECAST) INLLIBL(*JOBD)', 000000110.00000)";
using (OdbcCommand myCommand2 = new OdbcCommand(postCommand, myConnection))
if (myConnection.State == System.Data.ConnectionState.Closed)
int iRows = myCommand2.ExecuteNonQuery();
catch (Exception ex)
System.Diagnostics.Debug.WriteLine("Error opening connection" + ex.Message);