I thought I was going mad!Â I had started 2 sessions on the i5 and was trying to start the MySQL server so that it would allow me to test out the new ADDENVVAR code! I was able to start the server in a QP2TERM session but could not start it using the code I had developed for automating the start and stop process.Â Having spent hours trying to understand why it kept stating it could not find the host.frm file in the program but it could in the manual start in QP2TERM I was lost!Â I was about to walk away and come back another day when I had an idea, I was signed onto each session with different users, the session that allowedÂ me to start theÂ server in QP2TERM was signed on as my profile, the other which I was trying to start using the programs was QSECOFR.Â So IÂ exited the QP2TERM session, stopped the server (cant have 2 instances running) using theÂ WRKACTJOB options and then called the programs. It started OK! I was surprised that calling the programs with QSECOFR would give such a problem! My profile has allÂ authority just the same as QSECOFR (but its not QSECOFR) so it must be the name or some flag in the profile which caused the problem.
Basically dont use QSECOFR for starting MySQL!
Now I have to look at theÂ security problems I was looking at earlier..