This article presents one of the troubleshooting steps for Zend DBi MySQL daemon start ups, found in this article:
Troubleshoot Zend DBi MySQL daemon start up failures (mysql.sock)
To check this issue, please log on to a 5250 session as QSECOFR or a *SECOFR class user and enter this command:
DSPOBJD OBJ(ZMYSQL/ZMYSQLJBDA) OBJTYPE(*JOBD)
If the job description is displayed, this is probably not the problem. Please return to the troubleshooter to try another step.
If this message is displayed:
Object ZMYSQLJBDA in ZMYSQL type *JOBD not found.
Then this is a problem. You will need to create the job description. To assist with this task, here are the attributes for the job description:
Job description: ZMYSQLJBDA Library: ZMYSQL
User profile . . . . . . . . . . . . . . . . . . : MYSQL
CL syntax check . . . . . . . . . . . . . . . . : *NOCHK
Hold on job queue . . . . . . . . . . . . . . . : *NO
End severity . . . . . . . . . . . . . . . . . . : 30
Job date . . . . . . . . . . . . . . . . . . . . : *SYSVAL
Job switches . . . . . . . . . . . . . . . . . . : 00000000
Inquiry message reply . . . . . . . . . . . . . : *RQD
Job priority (on job queue) . . . . . . . . . . : 5
Job queue . . . . . . . . . . . . . . . . . . . : ZMYSQLJBQ
Library . . . . . . . . . . . . . . . . . . . : ZMYSQL
Output priority (on output queue) . . . . . . . : 5
Printer device . . . . . . . . . . . . . . . . . : *USRPRF
Output queue . . . . . . . . . . . . . . . . . . : *USRPRF
Library . . . . . . . . . . . . . . . . . . . :
Message logging:
Level . . . . . . . . . . . . . . . . . . . . : 4
Severity . . . . . . . . . . . . . . . . . . . : 0
Text . . . . . . . . . . . . . . . . . . . . . : *NOLIST
Log CL program commands . . . . . . . . . . . . : *YES
Job log output . . . . . . . . . . . . . . . . . : *SYSVAL
Accounting code . . . . . . . . . . . . . . . . : *USRPRF
Print text . . . . . . . . . . . . . . . . . . . : *SYSVAL
Routing data . . . . . . . . . . . . . . . . . . : ZMYSQL
Request data . . . . . . . . . . . . . . . . . . : QSYS/CALL ZMYSQL/ZMYSQLSTRT
DDM conversation . . . . . . . . . . . . . . . . : *KEEP
Device recovery action . . . . . . . . . . . . . : *SYSVAL
Time slice end pool . . . . . . . . . . . . . . : *SYSVAL
Job message queue maximum size . . . . . . . . . : *SYSVAL
Job message queue full action . . . . . . . . . : *SYSVAL
Allow multiple threads . . . . . . . . . . . . . : *NO
Initial ASP group . . . . . . . . . . . . . . . : *NONE
Spooled file action . . . . . . . . . . . . . . : *SYSVAL
Text . . . . . . . . . . . . . . . . . . . . . . : ZendDBi JOBD
Initial library list:
Sequence Sequence Sequence
number Library number Library number Library
10 ZMYSQL 30 QTEMP
20 QGPL
Here are the object authorities:
Object User Group Authority *PUBLIC *CHANGE QSECOFR *ALL