<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hello everybody,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am DBA and trying to setup systemd service for DB2 V11 fix pack 2a (multiple instances).<o:p></o:p></p>
<p class="MsoNormal">I’ve spent quite a bit of time on this setup without success so far.<o:p></o:p></p>
<p class="MsoNormal">I was able to get “ExecStart” part to work, but system reboot is giving me troubles.<o:p></o:p></p>
<p class="MsoNormal">DB2 crashes since “ExecStop” for some reason is not executed.<o:p></o:p></p>
<p class="MsoNormal">Please find the contents of db2.service file below.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The help on this is greatly appreciated.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Regards<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:red">[Unit]<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:red">Description=DB2 StartUp-Shutdown<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:red">After=network.target<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:red">Before=shutdown.target reboot.target halt.target<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:red">Conflicts=shutdown.target<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:red"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:red">[Service]<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:red">Type=forking<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:red">RemainAfterExit=yes<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:red">User=achdut2<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:red">ExecStart=/bin/sh -c '/var/db2/home/achdut2/sqllib/adm/db2start'<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:red">ExecStop=/bin/sh -c '/var/db2/home/achdut2/sqllib/adm/db2stop force'<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:red">Restart=always<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:red">Environment="DB2INSTANCE=achdut2"<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:red"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:red">[Install]<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:red">WantedBy=multi-user.target</span><o:p></o:p></p>
</div>
<DIV><P><HR>
<p>Please note the MUFG logo and name is a service mark of Mitsubishi UFJ Financial Group, Inc. (“MUFG”) and may be used by it or other Group companies for marketing purposes, including MUFG Americas Holdings Corporation affiliates and subsidiaries. Lending, deposit, securities, investment banking, and other banking services are provided by banking and/or broker-dealer affiliates of MUFG, including, MUFG Bank, Ltd. (“MUFG Bank”), MUFG Union Bank, N.A. (“Union Bank”), MUFG Securities Americas Inc. (“MUSA”), and MUFG Securities (Canada), Ltd. (“MUS(CAN)”). MUFG Bank is not an FDIC-insured bank. MUB is an FDIC-insured bank. MUSA is a member of FINRA and SIPC. MUS(CAN) is a member of IIROC and CIPF. </p>
<p>This message is intended for the named addressee(s) only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mis-transmission. If you receive this message in error, please delete it and all copies from your system, destroy any hard copies and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print or copy any part of this message if you are not the intended recipient. MUFG, its affiliates and subsidiaries reserve the right to monitor all electronic communications through their respective networks. Any views expressed in this message are those of the individual sender and do not constitute investment advice or recommendation, except where the message expressly states otherwise and the sender is authorized to furnish the same. MUFG (and its subsidiaries) shall (will) not be liable for the message if modified. </p>
</P></DIV>
</body>
</html>