[gpfsug-discuss] DB2 (not DB2 PureScale) and Spectrum Scale

[IBM Spectrum Scale]

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.htm>
-------------- 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>