Re: Auto starting ZEND and MYSQL subsystem and MYSQL Daemon

[Jim Essinger <dilbernator@xxxxxxxxx>]

Ok, I now have the start of the ZEND subsystem starting the ZMYSQL
subsystem.  The auto start job for the ZMYSQL system runs ZMYSQLSTRT program
in ZMySQL library, but the daemon is still not running when everything
completes.  I don't see any joblogs, and I don't know where to look for any
log files.

I know that when I start a PASE qshell session and start the daemon with the
"mysqld_safe &" command, then I have the daemon running in the QINTER
subsystem under my name, and things work.

Can anyone point me to a log file that will help me debug this issue?

Thanks!

Jim

On Wed, Jun 24, 2009 at 3:21 PM, <BMay@xxxxxxxxx> wrote:

> I have seen this happen more than once.
>
> 1.  Did you use the windows installer or the SAVF?
> 2.  When installing via either method, did you log in using QSECOFR?
> 3. Does the ZMYSQLJBQ jobq in library ZMYSQL exist?  Is it attached to the
> ZMYSQL subsystem?
>
> Brian May
> Project Lead
> Management Information Systems
> Garan, Incorporated
> Starkville, Mississippi
>
> Young i Professionals
> http://www.youngiprofessionals.com
>
>
>
> Jim Essinger <dilbernator@xxxxxxxxx>
> Sent by: web400-bounces@xxxxxxxxxxxx
> 06/24/2009 04:14 PM
> Please respond to
> Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
>
>
> To
> "Web Enabling the AS400 / iSeries" <web400@xxxxxxxxxxxx>
> cc
>
> Subject
> [WEB400] Auto starting ZEND and MYSQL subsystem and MYSQL Daemon
>
>
>
>
>
>
> After a quick check of the archives, where I did not see this addressed,
> and
> looking at the ZEND forums, where It is only partially addressed, I am
> looking for how to gracefully end and start the ZEND and ZMYSQL
> subsystems,
> the ZEND http server instance, and the MYSQL daemon.  The only way I have
> gotten the daemon to start is to start a PASE shell session, then issue
> the
> 'mysqld_safe &' command.  This puts the daemon running in QINTER.
>
> What am I missing in getting the MYSQL daemon to start in the ZMYSQL
> subsystem?  It does not seem to start when I start either the ZEND or
> ZMYSQL
> subsystems, nor does it start when taking the "4. Start MySQL daemon" menu
> option off of the "Zend MYSQL Management" menu.
>
> Thanks!
>
> Jim
> --
> This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
> To post a message email: WEB400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.
>
>
> --
> This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
> To post a message email: WEB400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.