Problem starting mysql

General discussion on Zend Server for IBM System i
Post Reply
cantorh
Posts: 5
Joined: Fri May 13, 2011 5:05 pm

Problem starting mysql

Post by cantorh » Thu Jan 17, 2013 5:00 pm

Hello,
We have QGPL in the system part of the library list. When trying to start Mysql from the ZSMENU menu the submit job fails because QGPL is specified in the INLLIBL parameter ... "SBMJOB CMD(***) JOB(ZMYSQLD) JOBQ(ZMYSQL/ZMYSQLJBQ) USER(MYSQL) INLLIBL(QTEMP QGPL ZMYSQL)". What is the full sbmjob command here so I can remove the QGPL from INLLIBL?

-thanks,
Hugo

zend_i5
Posts: 158
Joined: Mon Mar 23, 2009 5:22 pm

Re: Problem starting mysql

Post by zend_i5 » Tue Feb 05, 2013 7:14 am

Use this command to start MySQL daemon:

SBMJOB CMD(CALL PGM(QP2SHELL) +
PARM('/QOpenSys/usr/bin/sh' +
'/usr/local/MySQL/bin/mysql.sh start')) +
JOB(ZMYSQLD) JOBQ(ZMYSQL/ZMYSQLJBQ) +
USER(MYSQL) INLLIBL(ZMYSQL)

Post Reply