It's not fun... We have a .service file of type forking that calls a script of ours to start it and stop it. systemd is cool with that. However, if you stop and then start db2 outside of db2 it's no longer associated with that service and systemd whacks its processes at shutdown time, resulting generally in a database that needs repair :( (MQ qmgrs have the same issue). So one must remember to always use "systemctl stop/start" instead. That requires root authority. DBA's don't get that. We have something in place for them to use a script authorized in our security system. Think sudo on steroids. Now what if they forget? Well, we also had to make a monitoring process that detects if db2 is not started under systemd and nags them to stop it and start it the correct way.
Hope that helps. On Tue, Aug 18, 2020 at 3:07 PM Grzegorz Powiedziuk <[email protected]> wrote: > Hello, I realize that this is not a typical s390 question but I hope that's > > ok if I ask anyway. There is a high chance we have people here who run db2 > > on zLinux. > > How do you solve auto start and more importantly auto stop of DB2 on > > start/reboot/shutdowns ? > > Seems like the autostart may be handled by a db2fmcd service and db2iauto > > but what about autostops when reboot/shutdown is issued. > > I am afraid that db2 will be simply killed, am I right? I am not even sure > > if having my own stop script would do the trick as systemd might just kill > > the db2 processes before my script stops it gracefully > > thank you > > Gregory > > > > ---------------------------------------------------------------------- > > For LINUX-390 subscribe / signoff / archive access instructions, > > send email to [email protected] with the message: INFO LINUX-390 or > visit > > http://www2.marist.edu/htbin/wlvindex?LINUX-390 > > -- Marcy ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO LINUX-390 or visit http://www2.marist.edu/htbin/wlvindex?LINUX-390
