Problem starting mysql

General discussion on Zend Server for IBM System i

Problem starting mysql

Postby cantorh on 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
cantorh
 
Posts: 5
Joined: Fri May 13, 2011 5:05 pm

Re: Problem starting mysql

Postby zend_i5 on 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)
zend_i5
 
Posts: 149
Joined: Mon Mar 23, 2009 5:22 pm


Return to Zend Server for IBM i

Who is online

Users browsing this forum: No registered users and 4 guests