<html><body><p><font size="2">Hi Wally,</font><br><br><font size="2">I don't see a dedicated document for DB2 from Scale document sets, however, usually the workloads of database are doing direct I/O, so those documentation sections in Scale for direct I/O should be good to review. Here I have a list about tunings for direct I/O for your reference.</font><br><br><a href="https://www.ibm.com/docs/zh/spectrum-scale/5.1.1?topic=fpo-configuration-tuning-database-workloads" id="Body" title="Body"><font size="2">https://www.ibm.com/docs/zh/spectrum-scale/5.1.1?topic=fpo-configuration-tuning-database-workload</font></a><font size="2">s</font><br><br><a href="https://www.ibm.com/docs/zh/spectrum-scale/5.1.1?topic=applications-considerations-use-direct-io-o-direct"><font size="2">https://www.ibm.com/docs/zh/spectrum-scale/5.1.1?topic=applications-considerations-use-direct-io-o-direct</font></a><br><br><a href="https://www.ibm.com/docs/zh/spectrum-scale/5.1.1?topic=mfs-using-direct-io-file-in-gpfs-file-system"><font size="2">https://www.ibm.com/docs/zh/spectrum-scale/5.1.1?topic=mfs-using-direct-io-file-in-gpfs-file-system</font></a><br><br><br><br><font size="2">Regards, The Spectrum Scale (GPFS) team<br><br>------------------------------------------------------------------------------------------------------------------<br>If you feel that your question can benefit other users of Spectrum Scale (GPFS), then please post it to the public IBM developerWroks Forum at <a href="https://www.ibm.com/developerworks/community/forums/html/forum?id=11111111-0000-0000-0000-000000000479">https://www.ibm.com/developerworks/community/forums/html/forum?id=11111111-0000-0000-0000-000000000479</a>. <br><br>If your query concerns a potential software error in Spectrum Scale (GPFS) and you have an IBM software maintenance contract please contact 1-800-237-5511 in the United States or your local IBM Service Center in other countries. <br><br>The forum is informally monitored as time permits and should not be used for priority messages to the Spectrum Scale (GPFS) team.</font><br><br><img width="16" height="16" src="cid:1__=0ABB0C63DFA447C88f9e8a93df938690918c0AB@" border="0" alt="Inactive hide details for Wally Dietrich ---2021/06/07 11:03:52 PM---Hi. Is there documentation about tuning DB2 to perform wel"><font size="2" color="#424282">Wally Dietrich ---2021/06/07 11:03:52 PM---Hi. Is there documentation about tuning DB2 to perform well when using Spectrum Scale file systems?</font><br><br><font size="2" color="#5F5F5F">From: </font><font size="2">Wally Dietrich <wallyd@us.ibm.com></font><br><font size="2" color="#5F5F5F">To: </font><font size="2">"gpfsug-discuss@spectrumscale.org" <gpfsug-discuss@spectrumscale.org></font><br><font size="2" color="#5F5F5F">Date: </font><font size="2">2021/06/07 11:03 PM</font><br><font size="2" color="#5F5F5F">Subject: </font><font size="2">[EXTERNAL] [gpfsug-discuss] DB2 (not DB2 PureScale) and Spectrum Scale</font><br><font size="2" color="#5F5F5F">Sent by: </font><font size="2">gpfsug-discuss-bounces@spectrumscale.org</font><br><hr width="100%" size="2" align="left" noshade style="color:#8091A5; "><br><br><br>Hi. Is there documentation about tuning DB2 to perform well when using Spectrum Scale file systems? I'm interested in tuning both DB2 and Spectrum Scale for high performance. I'm using a stretch cluster for Disaster Recover (DR). I've found a document, but the last update was in 2013 and GPFS has changed considerably since then. <br><br>Wally Dietrich<br><a href="mailto:wallyd@us.im.com"><u><font color="#0000FF">wallyd@us.ibm.com</font></u></a><br><tt><font size="2">_______________________________________________<br>gpfsug-discuss mailing list<br>gpfsug-discuss at spectrumscale.org<br></font></tt><tt><font size="2"><a href="http://gpfsug.org/mailman/listinfo/gpfsug-discuss">http://gpfsug.org/mailman/listinfo/gpfsug-discuss</a></font></tt><tt><font size="2"> <br></font></tt><br><br><BR>
</body></html>