Missing job description ZMYSQLJBDA prevents Zend DBi MySQL daemon from starting

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