Hi Wally, 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. https://www.ibm.com/docs/zh/spectrum-scale/5.1.1?topic=fpo-configuration-tuning-database-workload s https://www.ibm.com/docs/zh/spectrum-scale/5.1.1?topic=applications-considerations-use-direct-io-o-direct https://www.ibm.com/docs/zh/spectrum-scale/5.1.1?topic=mfs-using-direct-io-file-in-gpfs-file-system Regards, The Spectrum Scale (GPFS) team ------------------------------------------------------------------------------------------------------------------ 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 https://www.ibm.com/developerworks/community/forums/html/forum?id=11111111-0000-0000-0000-000000000479. 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. The forum is informally monitored as time permits and should not be used for priority messages to the Spectrum Scale (GPFS) team. From: Wally Dietrich <wallyd at us.ibm.com> To: "gpfsug-discuss at spectrumscale.org" <gpfsug-discuss at spectrumscale.org> Date: 2021/06/07 11:03 PM Subject: [EXTERNAL] [gpfsug-discuss] DB2 (not DB2 PureScale) and Spectrum Scale Sent by: gpfsug-discuss-bounces at spectrumscale.org 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. Wally Dietrich wallyd at us.ibm.com _______________________________________________ gpfsug-discuss mailing list gpfsug-discuss at spectrumscale.org http://gpfsug.org/mailman/listinfo/gpfsug-discuss -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://gpfsug.org/pipermail/gpfsug-discuss_gpfsug.org/attachments/20210610/2dc7f41a/attachment.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: graycol.gif Type: image/gif Size: 105 bytes Desc: not available URL: <http://gpfsug.org/pipermail/gpfsug-discuss_gpfsug.org/attachments/20210610/2dc7f41a/attachment.gif>
