urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best PracticesBest practices for DB2 for Linux, UNIX, and Windows, and InfoSphere Warehouse products. Find out about new technical papers and videos, and information about best practices from other groups.
352015-02-12T18:49:59-05:00IBM Connections - Blogsurn:lsid:ibm.com:blogs:entry-a2d617e0-ad65-4402-b6cd-4d1076433237Migrate from IBM InfoSphere Warehouse V9.5 to DB2 Warehouse V10.5sboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2014-12-19T10:52:45-05:002014-12-19T11:17:39-05:00<p dir="ltr">
<span style="font-size:14px;">Are you still using IBM InfoSphere Warehouse V9.5? If so, you should migrate to DB2 Warehouse V10.5 before V9.5 goes out of service in April 2015. Follow the instructions in this document to make the migration as easy as possible: <a href="https://ibm.biz/BdEhSa">https://ibm.biz/BdEhSa</a></span></p>
<p dir="ltr">
<span style="font-size:14px;">The following video is also useful in explaining the migration to&nbsp; InfoSphere Warehouse V9.7.7: <a href="https://www.youtube.com/watch?v=dkh9eMD5VQ4">https://www.youtube.com/watch?v=dkh9eMD5VQ4</a></span></p>
Are you still using IBM InfoSphere Warehouse V9.5? If so, you should migrate to DB2 Warehouse V10.5 before V9.5 goes out of service in April 2015. Follow the instructions in this document to make the migration as easy as possible: https://ibm.biz/BdEhSa
...00286urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-03d79a37-afea-40ef-b0d9-26ab92a9f849New Video: Using IBM dashDB with Esri ArcGISsboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2014-12-16T15:23:43-05:002014-12-16T15:23:43-05:00<p dir="ltr">
<span style="font-size:16px;">We published a new video on our Information Management Best practices Youtube channel: <a href="http://youtu.be/bOeYofrP_uA?list=UU_rR6DkLijpZo6NNcGNi17w" target="_blank">Using&nbsp;IBM&nbsp;dashDB&nbsp;with&nbsp;Esri&nbsp;ArcGIS</a></span></p>
<p dir="ltr">
<span style="font-size:16px;">This new video tutorial shows you how to use IBM dashDB with Esri ArcGIS software to analyze geospatial data.</span></p>
<p dir="ltr">
<span style="font-size:16px;">You&#39;ve heard about dashDB and how you can harness the power of Cloud Analytics. See it in action now!</span></p>
We published a new video on our Information Management Best practices Youtube channel: Using&nbsp;IBM&nbsp;dashDB&nbsp;with&nbsp;Esri&nbsp;ArcGIS
This new video tutorial shows you how to use IBM dashDB with Esri ArcGIS software to analyze geospatial...00240urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-5d2ae96c-5865-491b-a809-e5ff45fa159bIntroduction to DB2 HADRsboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2014-12-03T13:24:06-05:002014-12-03T14:12:40-05:00<p dir="ltr">
<span style="font-size:14px;">Do you want to know more about what DB2 High Availability Disaster Recovery (HADR) is, and how it works?</span></p>
<p dir="ltr">
<span style="font-size:14px;">Read this useful overview in the DB2 Knowledge Center and let us know what you think. It includes a great interactive diagram to show you the &quot;big picture&quot;: <a href="https://ibm.biz/BdEeYj">https://ibm.biz/BdEeYj</a></span></p>
Do you want to know more about what DB2 High Availability Disaster Recovery (HADR) is, and how it works?
Read this useful overview in the DB2 Knowledge Center and let us know what you think. It includes a great interactive diagram to show you the...00248urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-5f925ae4-3edc-4fde-9a42-17ea14ffccb3New DB2 best practices paper: Securely deploying and configuring the DB2 pureScale Feature by using db2sshsboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2014-09-22T16:00:54-04:002014-09-22T16:00:54-04:00<p dir="ltr">
<span style="font-size:14px;">We are pleased to announce the release of a new DB2 best practices paper: <a href="https://ibm.biz/BdFe24">Securely&nbsp;deploying&nbsp;and&nbsp;configuring&nbsp;the&nbsp;DB2&nbsp;pureScale&nbsp;Feature&nbsp;by&nbsp;using&nbsp;db2ssh</a></span></p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
<span style="font-size:14px;">This technical paper highlights the best practices for securely deploying and configuring the DB2 pureScale Feature by using db2ssh. The db2ssh is a wrapper around the Secure Shell (SSH) protocol and Secure Copy Protocol (SCP).</span></p>
<p dir="ltr">
<span style="font-size:14px;">This paper provides the following information:</span></p>
<ul dir="ltr">
<li>
<span style="font-size:14px;">an introduction to db2ssh and its configuration</span></li>
<li>
<span style="font-size:14px;">details about various methods for installing and configuring the DB2pureScale Feature with db2ssh enabled</span></li>
<li>
<span style="font-size:14px;">troubleshooting tips to resolve problems.</span></li>
</ul>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
<span style="font-size:14px;">Thank you.</span></p>
We are pleased to announce the release of a new DB2 best practices paper: Securely&nbsp;deploying&nbsp;and&nbsp;configuring&nbsp;the&nbsp;DB2&nbsp;pureScale&nbsp;Feature&nbsp;by&nbsp;using&nbsp;db2ssh
&nbsp;
This technical paper highlights the...00261urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-86472c7b-1234-4273-ab55-cff044e43cbaNew DB2 video: DB2 & CLI tracingsboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2014-09-12T12:18:49-04:002014-09-12T12:19:38-04:00<p dir="ltr">
<span style="font-size:16px;">We are pleased to announce a new video to help you capture and format DB2 and CLI traces:&nbsp;<a href="https://ibm.biz/BdFPxT">DB2&nbsp;&amp;&nbsp;CLI&nbsp;Tracing</a></span></p>
<div dir="ltr">
<div>
<span style="font-size:16px;"><span style="color:black;">This video explains the various DB2 trace facilities and how traces can be gathered by IBM business partners and customers when they request IBM software support to investigate problems involving DB2 applications. The DB2 trace facilities are available on all DB2 products.</span></span></div>
<div>
&nbsp;</div>
</div>
<p dir="ltr">
&nbsp;</p>
We are pleased to announce a new video to help you capture and format DB2 and CLI traces:&nbsp; DB2&nbsp;&amp;&nbsp;CLI&nbsp;Tracing
This video explains the various DB2 trace facilities and how traces can be gathered by IBM business partners and...00793urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-d1a3f239-4d34-4aa7-bf4a-f820240b401fNew technical article: Gain confidence about data security in the cloudsboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2014-08-12T16:25:12-04:002014-08-12T16:25:12-04:00<p dir="ltr">
<span style="font-size:14px;">This new technical article on developerWorks replaces the previous &quot;data Protection in the Cloud&quot; best practices paper. It is new and demonstrate a use case with IBM BLU Acceleration.</span></p>
<p dir="ltr">
<span style="font-size:14px;"><a href="http://www.ibm.com/developerworks/data/library/techarticle/dm-1408datasecuritycloud/index.html" target="_blank">http://www.ibm.com/developerworks/data/library/techarticle/dm-1408datasecuritycloud/index.html</a></span></p>
<p dir="ltr">
<span style="font-size:14px;"><em>IBM BLU Acceleration for Cloud: A use case</em></span></p>
<p dir="ltr">
<span style="font-size:14px;">This tutorial demystifies cloud security and arms you with the know-how to adopt the cloud with confidence. Learn how cloud security is a shared responsibility between the cloud service provider and the client. The responsibilities of each party are explored. Also walk through a data security use case involving IBM BLU Acceleration for the Cloud. When certain criteria are met, clients can achieve data security equal to or better than what they can achieve onsite.</span></p>
This new technical article on developerWorks replaces the previous &quot;data Protection in the Cloud&quot; best practices paper. It is new and demonstrate a use case with IBM BLU Acceleration.
http://www.ibm.com/developerworks/data/library/techarticle/...00282urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-52b92744-78c6-4d0b-b0d9-f01209f8bf3bNew best practices paper: Deploying the IBM Banking Data Warehouse to IBM DB2 10.5 with BLU Accelerationsboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2014-06-13T16:02:43-04:002014-06-13T16:02:43-04:00<p dir="ltr">
<span style="font-size:16px;">We are pleased to announce the release of a new DB2 Warehouse best practices paper: <a href="https://ibm.biz/BdRWFZ">Deploying&nbsp;the&nbsp;IBM&nbsp;Banking&nbsp;Data&nbsp;Warehouse&nbsp;to&nbsp;IBM&nbsp;DB2&nbsp;10.5&nbsp;with&nbsp;BLU&nbsp;Acceleration</a></span></p>
<p dir="ltr">
<span style="font-size:16px;">Implementing industry models can help accelerate projects and reduce risk in a wide variety of industry sectors when enterprises develop and implement business intelligence applications.<br />
The IBM Industry Models solutions cover a range of industries that include banking, healthcare, retail, and telecommunications. The IBM Industry Models solutions provide you with an extensive and extensible data model for your industry sector. Use the logical data model as provided by IBM to build a physical model that is customized for your reporting requirements, and then deploy and populate a best practice IBM DB2&reg; 10.5 with BLU Acceleration database.<br />
This paper introduces the logical data model concepts and then focuses on what you must do to transform a non-vendor-specific logical data model into a best-practice production IBM DB2 10.5 with BLU Acceleration schema. Specifically, this paper uses the IBM Industry Models Banking Data Warehouse model pertaining to Involved Party and Social Media entities. It guides you through the recommended process for transforming the logical data model for dimensional warehousing into a physical database design for production use in your environment.</span><br />
&nbsp;</p>
<p dir="ltr">
<span style="font-size:16px;">Thanks!</span></p>
We are pleased to announce the release of a new DB2 Warehouse best practices paper: Deploying&nbsp;the&nbsp;IBM&nbsp;Banking&nbsp;Data&nbsp;Warehouse&nbsp;to&nbsp;IBM&nbsp;DB2&nbsp;10.5&nbsp;with&nbsp;BLU&nbsp;Acceleration
Implementing industry models...00655urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-25a421d5-ff36-4884-bd34-0b8e6daf12dbNew technical article: Convert row-organized tables to column-organized tables in DB2 10.5 with BLU Accelerationsboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2014-06-12T16:59:44-04:002014-06-12T16:59:44-04:00<p dir="ltr">
<span style="font-size:16px;">Learn how to convert row-organized tables to column-organized tables with DB2 10.5 with BLU Acceleration: <a href="http://www.ibm.com/developerworks/library/dm-1406convert-table-db2105/index.html">http://www.ibm.com/developerworks/library/dm-1406convert-table-db2105/index.html</a><br />
<br />
This new developerWorks technical paper written by IBM experts shows you several methods to easily convert row-organized tables to column-organized tables in DB2 10.5 with BLU Acceleration. You will then be able to experience all the performance benefits of BLU Acceleration.</span><br />
&nbsp;</p>
Learn how to convert row-organized tables to column-organized tables with DB2 10.5 with BLU Acceleration: http://www.ibm.com/developerworks/library/dm-1406convert-table-db2105/index.html
This new developerWorks technical paper written by IBM experts...00450urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-2a876c4b-0370-4d18-941e-701a9a270b5aNew best practices paper: Integrating IBM PureData System for Transactions into a data center networksboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2014-05-05T11:38:17-04:002014-05-05T11:38:17-04:00<p dir="ltr">
<span style="font-size:16px;">We are pleased to announce the publication of a new best practices paper: <a href="https://ibm.biz/BdRurH">Integrating&nbsp;IBM&nbsp;PureData&nbsp;System&nbsp;for&nbsp;Transactions&nbsp;into&nbsp;a&nbsp;data&nbsp;center&nbsp;network</a></span></p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
<span style="font-size:16px;">IBM PureData System for Transactions is an expertly integrated system to help deploy optimized and continuously available mission-critical databases. </span></p>
<p dir="ltr">
<span style="font-size:16px;">This paper covers the network requirements for integrating PureData System for Transactions into a data center environment and provides popular sample network topologies. </span></p>
<p dir="ltr">
<span style="font-size:16px;">Using the graphical interfaces in the system, you can easily configure the network switches to integrate with a corporate network.</span></p>
<p dir="ltr">
<span style="font-size:16px;">Thanks!</span></p>
We are pleased to announce the publication of a new best practices paper: Integrating&nbsp;IBM&nbsp;PureData&nbsp;System&nbsp;for&nbsp;Transactions&nbsp;into&nbsp;a&nbsp;data&nbsp;center&nbsp;network
&nbsp;
IBM PureData System for Transactions is...00290urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-b8d2fdd9-0c18-44ba-aa01-29254f34e9f8New best practices paper: Deploying the IBM Banking Data Warehouse to IBM InfoSphere BigInsightssboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2014-03-26T13:42:17-04:002014-03-26T13:42:17-04:00<p dir="ltr">
We are pleased to announce the publication of a new best practices paper: <a href="https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Wc9a068d7f6a6_4434_aece_0d297ea80ab1/page/Deploying%20the%20IBM%20Banking%20Data%20Warehouse%20to%20IBM%20InfoSphere%20BigInsights"><span style="font-size:12px;">Deploying&nbsp;the&nbsp;IBM&nbsp;Banking&nbsp;Data&nbsp;Warehouse&nbsp;to&nbsp;IBM&nbsp;InfoSphere&nbsp;BigInsights</span></a></p>
<p dir="ltr">
&nbsp;</p>
<p class="western" dir="ltr" lang="en-US" style="margin-bottom: 0.08in">
<span style="font-family:verdana,geneva,sans-serif;">This paper shows how you can deploy the IBM Banking Data Warehouse (BDW) solution to BigInsights. This paper introduces the logical data model concept and then focuses on what you must do to transform a non-vendor-specific logical data model into a production-ready BigInsights BigSQL schema. The key steps of the deployment process are as follows:</span></p>
<ol dir="ltr">
<li>
<p class="western" lang="en-US" style="margin-bottom: 0.08in; widows: 2; orphans: 2; page-break-before: auto">
<span style="font-family:verdana,geneva,sans-serif;">Create a physical data model that is a subset of the supplied logical data model. </span></p>
</li>
<li>
<p class="western" lang="en-US" style="margin-bottom: 0.08in; widows: 2; orphans: 2">
<span style="font-family:verdana,geneva,sans-serif;">Refine the physical data model to reflect your reporting and analytics needs.</span></p>
</li>
<li>
<p class="western" lang="en-US" style="margin-bottom: 0.08in; widows: 2; orphans: 2">
<span style="font-family:verdana,geneva,sans-serif;">Create the physical schema from the physical data model.</span></p>
</li>
<li>
<p class="western" lang="en-US" style="margin-bottom: 0.08in; widows: 2; orphans: 2">
<span style="font-family:verdana,geneva,sans-serif;">Populate the test environment, to further optimize the physical design to reflect the anticipated query, ingest, and maintenance workload.</span></p>
</li>
</ol>
<p align="LEFT" class="western" dir="ltr" lang="en-US" style="margin-bottom: 0.08in; widows: 2; orphans: 2">
<span style="font-family:verdana,geneva,sans-serif;">The example used in this paper is the Involved Party coverage within the BDW.</span></p>
<p class="western" dir="ltr" lang="en-US" style="margin-bottom: 0.08in">
<span style="font-family:verdana,geneva,sans-serif;">Although BigInsights includes a SQL interface (BigSQL), there are unique considerations when deploying to BigInsights. This paper explains how to translate reporting needs into BigInsights design decisions as part of the transformation process. </span></p>
<p class="western" dir="ltr" lang="en-US" style="margin-bottom: 0.08in">
&nbsp;</p>
<p class="western" dir="ltr" lang="en-US" style="margin-bottom: 0.08in">
Thanks!</p>
We are pleased to announce the publication of a new best practices paper: Deploying&nbsp;the&nbsp;IBM&nbsp;Banking&nbsp;Data&nbsp;Warehouse&nbsp;to&nbsp;IBM&nbsp;InfoSphere&nbsp;BigInsights
&nbsp;
This paper shows how you can deploy the IBM...00375urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-a58fdca9-e410-4f87-bbea-43f9649eba8bTry the IBM Knowledge Center while it is still in Open Beta!sboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2014-02-27T11:26:19-05:002014-02-27T11:26:19-05:00<div dir="ltr">
<span style="font-size:14px;">Access to IBM DB2 information centers will be redirected to IBM Knowledge Center at <a href="http://ibm.biz/IBMKCgo">ibm.biz/IBMKCgo</a> very soon. &nbsp;We encourage you to explore IBM Knowledge Center now, as we are nearing the end of its open beta period.</span></div>
<div dir="ltr">
&nbsp;</div>
<div dir="ltr">
<span style="font-size:14px;">If you haven&#39;t already heard, IBM Knowledge Center offers many benefits that clients are excited about. One of the biggest causes for excitement is that the product documentation for all IBM products is now on one website rather than on 800 or more separate information centers. The interface lets you search, filter, and browse through this information efficiently so that you aren&#39;t slowed down by the volume of information that is there.&nbsp;</span></div>
<div dir="ltr">
&nbsp;</div>
<div dir="ltr">
<span style="font-size:14px;">So, if you haven&#39;t had time to check out IBM Knowledge Center, take some time to try it this week. You can find useful information about how to get the most out of IBM Knowledge Center by following this Technical Content blog @ ibm.biz/IBMKCTCBlog. &nbsp;</span></div>
<div dir="ltr">
&nbsp;</div>
<div dir="ltr">
<span style="font-size:14px;">After you have spent a little time exploring your favorite IBM product documentation in IBM Knowledge Center, you are invited to take a short survey about your first impressions: <a href="https://www-950.ibm.com/survey/oid/wsb.dll/s/ag554">https://www-950.ibm.com/survey/oid/wsb.dll/s/ag554</a>. &nbsp;We will use feedback that we get from you and other respondents as we consider possible future enhancements to the IBM Knowledge Center user experience.</span></div>
<div dir="ltr">
&nbsp;</div>
Access to IBM DB2 information centers will be redirected to IBM Knowledge Center at ibm.biz/IBMKCgo very soon. &nbsp;We encourage you to explore IBM Knowledge Center now, as we are nearing the end of its open beta period.
&nbsp;
If you haven&#39;t...00383urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-962b1975-3a75-4719-992e-096e84f531e1IBM Knowledge Center Open Beta is available!sboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2014-01-06T11:08:01-05:002014-01-06T11:09:30-05:00<p dir="ltr">
<font size="3"><b>IBM Knowledge Center Open Beta is available!&nbsp;</b></font><br />
<font size="3"><b>We are very happy to announce the availability of our open IBM Knowledge Center Beta, live on ibm.com.&nbsp;</b></font><br />
<font size="3"><b>&nbsp;</b></font><br />
<font size="3"><b>You can access IBM Knowledge Center here:</b></font><br />
<font color="blue" size="3"><b><u><a href="http://www.ibm.com/support/knowledgecenter/">www.ibm.com/support/knowledgecenter/</a></u></b></font><br />
<font size="3"><b>&nbsp;</b></font><br />
<font size="3"><b>The Beta will run until the end of February 2014.&nbsp;</b></font><br />
<font size="3"><b>&nbsp;</b></font><br />
<strong><u><font size="3">Improving your technical content experience</font></u></strong><br />
<font size="3"><b>IBM Knowledge Center is our new technology designed to bring IBM&#39;s technical publications together in a single location, and will replace our individual IBM Information Centers.&nbsp;</b></font><br />
<font size="3"><b>&nbsp;</b></font><br />
<font size="3"><b>For this release, we simplified the user experience, improved search, and refined the overall experience with many other enhancements. As always, you can get help on IBM Knowledge Center from the information icon in the upper right corner of the pane (also linked here): &nbsp;</b></font><br />
<font color="blue" size="3"><b><u><a href="http://www.ibm.com/support/knowledgecenter/doc/kc_help.html">http://www.ibm.com/support/knowledgecenter/doc/kc_help.html</a></u></b></font><br />
<font size="3"><b>&nbsp;</b></font><br />
<u><font size="3"><b>Send us your feedback!&nbsp;</b></font></u><br />
<font size="3"><b>After you&#39;ve worked with IBM Knowledge Center, sign in with your IBM ID and take a few moments to complete the survey on IBM Knowledge Center located here:</b></font><br />
<font color="blue" size="3"><b><u><a href="https://www-304.ibm.com/software/support/trial/cst/forms/survey.wss?id=5323">https://www-304.ibm.com/software/support/trial/cst/forms/survey.wss?id=5323</a></u></b></font><br />
<font size="3"><b>&nbsp;</b></font><br />
<u><font size="3"><b>Known Beta limitations</b></font></u><br />
<font size="3"><b>We are still:</b></font></p>
<ul dir="ltr">
<li>
<font size="3"><b>Fine tuning IBM Knowledge Center, so you might experience some minor functional issues </b></font></li>
<li>
<font size="3"><b>Configuring and adding content to IBM Knowledge Center, so the content you see might not be exactly what you expect </b></font></li>
<li>
<font size="3"><b>Configuring and indexing content for search, so search results might not be exactly what you expect, or might not be in all the languages you expect.&nbsp;</b></font></li>
</ul>
IBM Knowledge Center Open Beta is available!&nbsp;
We are very happy to announce the availability of our open IBM Knowledge Center Beta, live on ibm.com.&nbsp;
&nbsp;
You can access IBM Knowledge Center here:
www.ibm.com/support/knowledgecenter...001600urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-8cbaae04-6762-48b8-8aab-ddad4f826404First Waltham Cloud Foundry Meetup - Dec 11thDRussell488112000070EVactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2013-12-09T07:59:50-05:002013-12-09T07:59:50-05:00<p dir="ltr">
Come to the first Cloud Foundry Meetup in the Waltham area this coming Wednesday, December 11th!<br />
This meetup is your opportunity to learn more about Cloud Foundry and meet people excited about the technology. &nbsp;<br />
On the agenda is an Introduction to Cloud Foundry: the technology and the community by Chris Ferris of IBM.<br />
This will be followed by a talk by Renat Khasanshyn of Altoros on Implementing Cloud Foundry 2.0.<br />
More information at:&nbsp; //bit.ly/1azS5PX</p>
Come to the first Cloud Foundry Meetup in the Waltham area this coming Wednesday, December 11th!
This meetup is your opportunity to learn more about Cloud Foundry and meet people excited about the technology. &nbsp;
On the agenda is an Introduction to...00450urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-d07d092b-5ebe-497e-a8a4-330197ccdd9eWriting and tuning queries for optimal performance best practices updatedsboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2013-12-06T13:53:43-05:002013-12-06T13:53:43-05:00<p dir="ltr">
<span style="font-size:14px;">We are pleased to announce that the best practices&nbsp;<a href="https://ibm.biz/Bdx2ng">Writing&nbsp;and&nbsp;tuning&nbsp;queries&nbsp;for&nbsp;optimal&nbsp;performance</a>&nbsp;has been updated. </span></p>
<p dir="ltr">
<span style="font-size:14px;">The old PDF paper has been replaced by a roadmap to the most up-to-date information in the DB2 V10.5 Information Center. &nbsp;The best practices information covers the most current DB2 V10.5 products.&nbsp;</span></p>
We are pleased to announce that the best practices&nbsp; Writing&nbsp;and&nbsp;tuning&nbsp;queries&nbsp;for&nbsp;optimal&nbsp;performance &nbsp;has been updated.
The old PDF paper has been replaced by a roadmap to the most up-to-date information in the...00653urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-be8f27c1-b0e5-4cda-8532-b39dbb95adccUpdated best practices paper: Expanding an IBM Smart Analytics System database and redistributing datasboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2013-10-22T15:41:27-04:002013-10-22T15:41:27-04:00<p dir="ltr">
<span style="font-size:16px;">A updated version of the best practices paper entitled &nbsp;&quot;<span style="color: rgb(68, 68, 68); font-family: Arial, sans-serif; line-height: 1.2em;">Expanding an IBM Smart Analytics System database and redistributing data&quot; is now available:&nbsp;<a href="https://ibm.biz/Bdx2eF" target="_blank">https://ibm.biz/Bdx2eF</a></span></span></p>
<p dir="ltr">
<span style="font-size:16px;"><span style="color: rgb(68, 68, 68); font-family: Arial, sans-serif; line-height: 1.2em;">The paper incorporates updated information based on user testing and additional information for IBM PureData System for Operational Analytics.</span></span></p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
<span style="font-size:16px;"><span style="color: rgb(68, 68, 68); font-family: Arial, sans-serif; line-height: 1.2em;">Thanks!</span></span></p>
A updated version of the best practices paper entitled &nbsp;&quot; Expanding an IBM Smart Analytics System database and redistributing data&quot; is now available:&nbsp; https://ibm.biz/Bdx2eF
The paper incorporates updated information based on user...00391urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-cd1fa424-f552-4d5c-8e70-150e0179eac3NoSQL, MongoDB, Big Data and CloudDRussell488112000070EVactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2013-10-18T07:48:39-04:002013-10-18T07:48:39-04:00<p dir="ltr">
The trend in programming today is towards greater diversity in datastores that can be applied to a broad set of applications. Developers and Data Architects require the ability to not only work with traditional relational databases but also with document based databases<br />
<br />
A Meetup is scheduled for November 6 at the Mandalay Bay Convention Center in Las Vegas to highlight the significance of open interfaces and open source in the vibrant and rapidly evolving world of NoSQL, MongoDB, Big Data in the Cloud. Come meet with us to learn how open technologies are changing the face of computing and how they participate in the evolving open architecture<br />
This is a three hour event with a panel, demos, lightning talks, stimulating discussions, networking and refreshments. Register now for the Big Data Developers Meetup and, after registering, you will see the meetup location at the Mandalay Bay Convention Center in Las Vegas.<br />
<br />
More information on the meetup can be found at:&nbsp; <a href="http://bit.ly/MeetupIOD">http://bit.ly/MeetupIOD</a><br />
<br />
Interact with industry experts. Challenge your knowledge of open technologies. Join the discussion.</p>
The trend in programming today is towards greater diversity in datastores that can be applied to a broad set of applications. Developers and Data Architects require the ability to not only work with traditional relational databases but also with document based...20353urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-2625a51d-74a4-4fd6-b48b-2dabc24319acNEW Best practices paper: Troubleshooting DB2 serverssboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2013-10-04T10:18:32-04:002013-10-04T10:18:32-04:00<p class="western" dir="ltr" lang="en-US" style="margin: 5px 0px 0px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; font-family: Arial, sans-serif; line-height: 18px;">
<a href="https://www.ibm.com/developerworks/community/blogs/d4334e67-3b43-4d33-bf32-22a73685871c/resource/BLOGS_UPLOADED_IMAGES/IBM_BestPractices_notext.png" target="_blank"><img alt="image" src="https://www.ibm.com/developerworks/community/blogs/d4334e67-3b43-4d33-bf32-22a73685871c/resource/BLOGS_UPLOADED_IMAGES/IBM_BestPractices_notext.png" style=" width:200px; display:block; margin: 1em 1em 0pt 0pt; float: left;" /></a>We are pleased to announce the release of a new DB2 best practices paper:&nbsp;<a href="https://ibm.biz/BdDyUy" target="_blank">Troubleshooting&nbsp;DB2&nbsp;servers</a></p>
<p class="western" dir="ltr" lang="en-US" style="margin: 5px 0px 0px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; font-family: Arial, sans-serif; line-height: 18px;">
&nbsp;</p>
<p class="western" dir="ltr" lang="en-US" style="margin: 5px 0px 0px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; font-family: Arial, sans-serif; line-height: 18px;">
<span style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline; font-family: arial, helvetica, sans-serif;">Even in a perfectly engineered world, things can break.<span lang="en-US" style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline; font-family: Arial, sans-serif;"><font color="#000000" style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline;"><font style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline;">&nbsp;</font></font></span>Hardware that is not redundant can fail, or software can encounter a condition that requires intervention. You can automate some of this intervention. For example, you can enable<span lang="en-US" style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline; font-family: Arial, sans-serif;"><font color="#000000" style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline;"><font style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline;">&nbsp;</font></font></span>your DB2 server to automatically<span lang="en-US" style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline; font-family: Arial, sans-serif;"><font color="#000000" style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline;"><font style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline;">&nbsp;</font></font></span>collect diagnostic data when it encounters a significant problem. Eventually, however,<span lang="en-US" style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline; font-family: Arial, sans-serif;"><font color="#000000" style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline;"><font style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline;">&nbsp;</font></font></span>a human being must look at the data to diagnose and resolve the issue. When the need arises, you can use several DB2 troubleshooting tools that provide highly granular access to diagnostic data.</span></p>
<p class="western" dir="ltr" lang="en-US" style="margin: 5px 0px 0px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; font-family: Arial, sans-serif; line-height: 18px;">
<span style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline; font-family: arial, helvetica, sans-serif;">The information and scenarios in this paper show how you can use the DB2 troubleshooting tools to diagnose problems on your server.</span></p>
<p class="western" dir="ltr" lang="en-US" style="margin: 5px 0px 0px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; font-family: Arial, sans-serif; line-height: 18px;">
<span style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline; font-family: arial, helvetica, sans-serif;">In large database environments, the collection of diagnostic data can introduce an unwanted impact to the system. This paper shows how you can minimize this impact by tailoring the values of a few basic troubleshooting configuration parameters such as diagpath, DUMPDIR, and FODCPATH and by collecting data more selectively.</span></p>
<p class="western" dir="ltr" lang="en-US" style="margin: 5px 0px 0px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; font-family: Arial, sans-serif; line-height: 18px;">
<span style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline; font-family: arial, helvetica, sans-serif;">The result? When things do break, you are well prepared to make troubleshooting as quick and painless as possible.</span></p>
<p class="western" dir="ltr" lang="en-US" style="margin: 5px 0px 0px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; font-family: Arial, sans-serif; line-height: 18px;">
<span style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline; font-family: arial, helvetica, sans-serif;">The following DB2 troubleshooting scenarios are covered in this paper:</span></p>
<ul dir="ltr" style="border: 0px; outline: 0px; vertical-align: baseline; font-family: Arial, sans-serif; line-height: 18px;">
<li style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline;">
<p class="western" lang="en-US" style="margin: 5px 0px 0.17in; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline;">
<span style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline; font-family: arial, helvetica, sans-serif;">Troubleshooting high processor usage spikes</span></p>
</li>
<li style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline;">
<p class="western" lang="en-US" style="margin: 5px 0px 0.17in; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline;">
<span style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline; font-family: arial, helvetica, sans-serif;">Troubleshooting sort overflows</span></p>
</li>
<li style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline;">
<p class="western" lang="en-US" style="margin: 5px 0px 0.17in; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline;">
<span style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline; font-family: arial, helvetica, sans-serif;">Troubleshooting locking issues</span></p>
</li>
</ul>
<p class="western" dir="ltr" lang="en-US" style="margin: 5px 0px 0.17in; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; font-family: Arial, sans-serif; line-height: 18px;">
<span style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline; font-family: arial, helvetica, sans-serif;">For each scenario, this paper shows you how to identify the problem symptoms, how to collect the diagnostic data with minimal impact to your database environment, and how to diagnose the cause of the problem.</span></p>
<p class="western" dir="ltr" lang="en-US" style="margin: 5px 0px 0.17in; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; font-family: Arial, sans-serif; line-height: 18px;">
<span style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline; font-family: arial, helvetica, sans-serif;">The target audience for this paper is database and system administrators who have some familiarity with operating system and DB2 commands.</span></p>
<p class="western" dir="ltr" lang="en-US" style="margin: 5px 0px 0.17in; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; font-family: Arial, sans-serif; line-height: 18px;">
<span style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: inherit; vertical-align: baseline; font-family: arial, helvetica, sans-serif;">This paper applies to DB2 V10.1 FP2 and later, but many of the features that are described here are available in earlier DB2 versions as well.&nbsp;</span></p>
We are pleased to announce the release of a new DB2 best practices paper:&nbsp; Troubleshooting&nbsp;DB2&nbsp;servers
&nbsp;
Even in a perfectly engineered world, things can break. &nbsp; Hardware that is not redundant can fail, or software can...001048urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-db12e9f1-af86-404d-9d13-b84f298a6ecdNEW Best practices webcast: Deep-dive performance analysis with InfoSphere Optim Performance Manager V5.3sboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2013-09-13T15:35:15-04:002013-09-13T15:35:15-04:00<p dir="ltr">
<span style="font-size:16px;">We are pleased to announce the release of a new DB2 and Optim best practice webcast:&nbsp;<a href="https://ibm.biz/BdDjqL" target="_blank">Deep-dive&nbsp;performance&nbsp;analysis&nbsp;ysing&nbsp;InfoSphere&nbsp;Optim&nbsp;Performance&nbsp;Manager&nbsp;V5.3</a></span></p>
<p dir="ltr">
<span style="font-size:16px;">This new webcast by IBM DB2 preformance expert Steve Rees,&nbsp;<span style="font-family: Arial, sans-serif; line-height: 18px;">provides an in-depth tutorial to help you use IBM InfoSphere Optim Performance Manager V5.3 (OPM) to diagnose, analyse, and correct potential performance problems with your DB2 system. Some of the topics covered in the webcast include:</span></span></p>
<ul dir="ltr">
<li>
<span style="font-size:16px;">Overview of the new and improved features in OPM V5.3 <span class="Apple-tab-span" style="white-space:pre"> </span></span></li>
<li>
<span style="font-size:16px;">Setting a &nbsp;baseline for performance metrics&nbsp;</span></li>
<li>
<span style="font-size:16px;">Investigating system bottlenecks&nbsp;</span></li>
<li>
<span style="font-size:16px;">Recognizing a system-level disk bottleneck</span></li>
<li>
<span style="font-size:16px;">Recognizing a system-level CPU level bottleneck</span></li>
<li>
<span style="font-size:16px;">Recognizing a system-level locking bottleneck</span></li>
<li>
<span style="font-size:16px;">Drilling down &ndash; diagnosing slow queries with OPM <span class="Apple-tab-span" style="white-space:pre"> </span></span></li>
</ul>
<p dir="ltr">
<span style="font-size:16px;"><span class="Apple-tab-span" style="white-space:pre">​</span>... and more.</span></p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
<span style="font-size:16px;">Let us know what you think by leaving feedback on the webcast&#39;s description page.</span></p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
<span style="font-size:16px;">Thanks!</span></p>
We are pleased to announce the release of a new DB2 and Optim best practice webcast:&nbsp; Deep-dive&nbsp;performance&nbsp;analysis&nbsp;ysing&nbsp;InfoSphere&nbsp;Optim&nbsp;Performance&nbsp;Manager&nbsp;V5.3
This new webcast by IBM DB2 preformance...00825urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-be5ed981-c225-4040-9fa1-368c8e2057eaNEW best practices paper: Performance monitoring in a data warehousesboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2013-09-11T10:55:10-04:002013-09-11T10:55:10-04:00<p dir="ltr">
<span style="font-size:14px;">We have just published a new best practices paper for IBM Smart Analytics System and IBM PureData System for Operational Analytics customers:&nbsp;<a href="https://ibm.biz/BdDsKr" target="_blank">Performance&nbsp;monitoring&nbsp;in&nbsp;a&nbsp;data&nbsp;wartehouse</a>.</span></p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
<span style="font-size: 14px;">This best practices paper covers real-time monitoring of the IBM Smart Analytics System and IBM PureData System for Operational Analytics. You can apply most of the content to other types of clusters of servers running a data warehouse system with DB2 software and database partitioning under AIX and Linux operating systems. The focus of this paper is finding the reasons for performance problems. These can be bottlenecks that are in the operating system, are in the DB2 database software, or are related to a single query. The focus is on data warehouse systems with long-running queries rather than transactional systems with mostly short queries.</span></p>
<p dir="ltr">
&nbsp;</p>
<div dir="ltr">
<span style="font-size:14px;">A main goal of this paper is to provide a set of key performance indicators (KPIs) or metrics for the operating system and DB2 software, along with a methodology for analyzing performance problems in a distributed DB2 environment. This paper describes scenarios to help you gather the right information depending on the symptoms of the performance problem.</span></div>
<p dir="ltr">
&nbsp;</p>
<div dir="ltr">
<span style="font-size: 14px;">This paper first provides an overview of the approach and what to consider in general when monitoring the performance of a data warehouse. It then describes the most important operating system and DB2 metrics for multiserver data warehouse systems. The last section describes in detail several performance problem scenarios that are related to data warehouse or BI workloads and explains how to use the metrics for analyzing the problems.</span></div>
<p dir="ltr">
&nbsp;</p>
<div dir="ltr">
<span style="font-size:14px;">Most of the information about KPIs that are described in the paper has sample commands that extract actual values. However, these examples are not intended to provide comprehensive tooling. You can use this best practices paper as a guideline for selecting the metrics to focus on when using monitoring tools such as IBM InfoSphere&reg; Optim&trade; Performance Manager.</span></div>
<div dir="ltr">
&nbsp;</div>
<div dir="ltr">
<span style="font-size:14px;">You can use this paper to complement the best practices paper <a href="https://www.ibm.com/developerworks/community/wikis/home?lang=en#/wiki/Wc9a068d7f6a6_4434_aece_0d297ea80ab1/page/Managing%20data%20warehouse%20performance%20with%20IBM%20InfoSphere%20Optim%20Performance%20Manager" target="_blank">Managing&nbsp;data&nbsp;warehouse&nbsp;performance&nbsp;with&nbsp;IBM&nbsp;InfoSphere&nbsp;Optim&nbsp;Performance&nbsp;Manager</a>, which covers historical and end-to-end monitoring.</span></div>
We have just published a new best practices paper for IBM Smart Analytics System and IBM PureData System for Operational Analytics customers:&nbsp; Performance&nbsp;monitoring&nbsp;in&nbsp;a&nbsp;data&nbsp;wartehouse .
&nbsp;
This best practices...101165urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-591c8074-8911-41c3-9e08-66efe20e4fa2NEW Best Practices paper on DB2 V10.5 with BLU Accelerationsboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2013-09-06T10:53:53-04:002013-09-06T10:53:53-04:00<p dir="ltr">
<span style="font-family:arial,helvetica,sans-serif;"><span style="font-size:16px;">We are happy to announce the publication of a new best practices paper to help you understand and get the most from the new BLU Acceleration technology introduced in DB2 for Linux, UNIX, and Windows V10.5:&nbsp;<a href="https://ibm.biz/BdDrnq">Optimizing&nbsp;analytic&nbsp;workoads&nbsp;using&nbsp;DB2&nbsp;10.5&nbsp;with&nbsp;BLU&nbsp;Acceleration&nbsp;(https://ibm.biz/BdDrnq)</a></span></span></p>
<p dir="ltr">
<span style="line-height: 18px; font-size: 16px; font-family: arial, helvetica, sans-serif;">BLU Acceleration is a new collection of technologies for analytic queries that are introduced in DB2 for Linux, UNIX, and Windows Version 10.5. At its heart, BLU Acceleration is about providing faster answers to more questions and analyzing more data at a lower cost. DB2 with BLU Acceleration is about providing order-of-magnitude benefits in performance, storage savings, and time to value.</span></p>
<p dir="ltr" style="margin: 5px 0px 0px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; font-family: Arial, sans-serif; line-height: 18px;">
<span style="font-family:arial,helvetica,sans-serif;"><span style="font-size:16px;"><span style="margin: 0px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline;"><span style="margin: 0px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline;">This paper gives you an overview of these technologies, recommendations on hardware and software selection, guidelines for identifying the optimal workloads for BLU Acceleration, and information about capacity planning, memory, and I/O.&nbsp;</span></span></span></span></p>
<p dir="ltr" style="margin: 5px 0px 0px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; font-family: Arial, sans-serif; line-height: 18px;">
&nbsp;</p>
<p dir="ltr" style="margin: 5px 0px 0px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; font-family: Arial, sans-serif; line-height: 18px;">
<span style="font-family:arial,helvetica,sans-serif;"><span style="font-size:16px;"><span style="margin: 0px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline;"><span style="margin: 0px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline;">Thanks you.</span></span></span></span></p>
We are happy to announce the publication of a new best practices paper to help you understand and get the most from the new BLU Acceleration technology introduced in DB2 for Linux, UNIX, and Windows V10.5:&nbsp; Optimizing&nbsp;analytic&nbsp;workoads&nbsp;usin...001659urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-be6a7e5f-30aa-4b06-9725-92d641be9e30New best practices community for IBM PureData System for Analytics!sboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2013-08-08T16:59:40-04:002013-08-08T17:00:27-04:00<p dir="ltr">
<span style="font-size:14px;">If you are currently using IBM PureData System for Analytics, powered by Netezza technology, or are interested in learning more about it, you will be happy to know that we have a new best practices community for it:</span></p>
<ul dir="ltr">
<li>
<a href="https://www.ibm.com/developerworks/community/groups/service/html/communityview?communityUuid=1eaa9994-78e8-42c0-bfea-ca7a74b106b1" target="_blank"><span style="font-size:14px;">IBM&nbsp;PureData&nbsp;System&nbsp;for&nbsp;Analytics&nbsp;Best&nbsp;Practices</span></a></li>
</ul>
<p dir="ltr">
<span style="font-size:14px;">In this community you will find a number of useful articles a</span><span style="font-size: 14px;">nd papers to help you learn about the product&#39;s features, and get valuable recommendations and tips to get the most from it.</span></p>
<p dir="ltr">
<span style="font-size: 14px;">Provide us with feedback by leaving comments after you have downloaded and read the papers.&nbsp;</span></p>
<p dir="ltr">
<span style="font-size: 14px;">Thank you.</span></p>
If you are currently using IBM PureData System for Analytics, powered by Netezza technology, or are interested in learning more about it, you will be happy to know that we have a new best practices community for it:
IBM&nbsp;PureData&nbsp;System&nb...00514urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-0860f2e2-32e4-4584-ba7d-d73a18bdf928Completely Revised!! Tuning and monitoring database system performancesboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2013-07-30T16:31:12-04:002013-07-30T16:31:12-04:00<p dir="ltr">
<span style="font-size:16px;">One of our most popular best practices paper is now completely revised and updated to provide recommendations for the latest DB2 environments, including DB2 V10.1, DB2 V10.5, and PureData System for Operational Analytics.</span></p>
<p dir="ltr">
<a href="https://ibm.biz/Bdx2nt"><span style="font-size:16px;">Tuning&nbsp;and&nbsp;monitoring&nbsp;database&nbsp;system&nbsp;performance&nbsp;(https://ibm.biz/Bdx2nt)</span></a> <span style="font-size:16px;">is available for download from our DB2 best practices community.</span></p>
<p dir="ltr">
<span style="font-size:14px;"><strong>Summary:</strong></span></p>
<p dir="ltr">
<span style="font-size:16px;">Most DB2 systems go through something of a &ldquo;performance evolution&rdquo;. The system must first be configured, both from hardware and software perspectives. In many ways, this sets the stage for how the system behaves when it is in operation. Then, after the system is deployed, a diligent DBA monitors system performance, in order to detect any problems that might develop. If such problems develop, we come to the next phase &ndash; troubleshooting. Each phase depends on the previous ones, in that without proper preparation in the previous phase, we are much more likely to have difficult problems to solve in the current phase.</span></p>
<p dir="ltr">
<span style="font-size:16px;">This paper presents DB2 system performance best practices following this same progression. We begin by touching on a number of important principles of hardware and software configuration that can help ensure good system performance. Then we discuss various monitoring techniques that help you understand system performance under both operational and troubleshooting conditions. Lastly, because performance problems can occur despite our best preparations, we talk about how to deal with them in a step-wise,methodical fashion.</span></p>
One of our most popular best practices paper is now completely revised and updated to provide recommendations for the latest DB2 environments, including DB2 V10.1, DB2 V10.5, and PureData System for Operational Analytics.
Tuning&nbsp;and&nbsp;monitoring...001165urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-f8945c49-58c1-4b85-9c0f-6022f35131a6Don't miss the latest DB2 for z/OS best practices video webcastssboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2013-07-22T12:01:35-04:002013-07-22T12:01:35-04:00<p dir="ltr">
<span style="color: rgb(0, 0, 0); font-family: Arial, sans-serif; font-size: 13px; line-height: 15px;">Are you also a DB2 for z/OS user? If so, don&#39;t miss the latest best practices webcasts published by the DB2 for z/OS team:</span></p>
<ul dir="ltr">
<li>
<span style="color: rgb(0, 0, 0); font-family: Arial, sans-serif; font-size: 13px; line-height: 15px;">Steps to investigate CPU performance on release migration:&nbsp;</span><a href="https://ibm.biz/BdxwWL">https://ibm.biz/BdxwWL</a></li>
<li>
<span style="color: rgb(0, 0, 0); font-family: Arial, sans-serif; font-size: 13px; line-height: 15px;">DB2 for z/OS Data Sharing Tuning Group Buffer Pools:&nbsp;</span><a href="https://ibm.biz/BdxwW9">https://ibm.biz/BdxwW9</a></li>
<li>
<span style="color: rgb(0, 0, 0); font-family: Arial, sans-serif; font-size: 13px; line-height: 15px;">Best Practices for Optimal Access Path Selection During Migration:&nbsp;</span><a href="https://ibm.biz/BdxwWQ">https://ibm.biz/BdxwWQ</a></li>
</ul>
<p dir="ltr">
<br style="color: rgb(0, 0, 0); font-family: Arial, sans-serif; font-size: 13px; line-height: 15px;" />
<span style="color: rgb(0, 0, 0); font-family: Arial, sans-serif; font-size: 13px; line-height: 15px;">Check out these new titles and many more at the DB2 for z/OS Best Practice community --</span><a href="https://ibm.biz/BdxkKb">https://ibm.biz/BdxkKb</a></p>
Are you also a DB2 for z/OS user? If so, don&#39;t miss the latest best practices webcasts published by the DB2 for z/OS team:
Steps to investigate CPU performance on release migration:&nbsp; https://ibm.biz/BdxwWL
DB2 for z/OS Data...00621urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-a6b0c9da-fe83-4e3d-b028-125d01981efcWhat Best Practices are most useful to you?sboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2013-06-03T11:39:26-04:002013-06-03T11:39:26-04:00<p dir="ltr">
<span style="font-size:14px;"><span style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; line-height: 17px;">Have you downloaded and read any of the DB2 LUW best practices papers and videos in the past year? Has any of them helped you solve a DB2 problem, implement a new scenario, or helped you learn something new? If so, which ones? </span></span></p>
<p dir="ltr">
<span style="font-size:14px;"><span style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; line-height: 17px;">Let us know what you think! Post your comments here to help us continue to write and publish best practices that are useful to you.</span></span></p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
<span style="font-size:14px;"><span style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; line-height: 17px;">Thanks!</span></span></p>
Have you downloaded and read any of the DB2 LUW best practices papers and videos in the past year? Has any of them helped you solve a DB2 problem, implement a new scenario, or helped you learn something new? If so, which ones?
Let us know what you...00578urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-ea4bff54-6cff-49ad-919a-39cda09ec3f4What Best Practices topics do you need to learn about?sboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2013-05-08T15:24:43-04:002013-05-08T15:24:43-04:00<p dir="ltr">
<span style="font-size:16px;">Help us provide you with the best practices you need the most.</span></p>
<p dir="ltr">
<span style="font-size:16px;">What business scenarios do you need to implement with DB2 products that you need practical recommendations to help you?</span></p>
<p dir="ltr">
<span style="font-size:16px;">What issues are you facing for which you have not found practical recommendations to help solve them?</span></p>
<p dir="ltr">
<span style="font-size:16px;">Let us know what topics would be the most helpful for us to write and publish best practices in this community. &nbsp;<strong>Simply add a comment to this blog post with your ideas</strong>. The more detailed the better! </span></p>
<p dir="ltr">
<span style="font-size:16px;">We will review and evaluate them with our product experts, so that we can prioritize our projects to help as many of you as possible.</span></p>
<p dir="ltr">
<span style="font-size:16px;">We cannot promise to publish best practices that will answer all of your questions, but we will definitely review all of them so that we can prioritize our efforts.</span></p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
<span style="font-size:16px;">Thank you!</span></p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
<span style="font-size:16px;">P.S. You will need to login with your IBM developerWorks userid in order to add comments.</span></p>
<p dir="ltr">
&nbsp;</p>
Help us provide you with the best practices you need the most.
What business scenarios do you need to implement with DB2 products that you need practical recommendations to help you?
What issues are you facing for which you have not found...00641urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-0b68bc9c-e2aa-4886-aa3a-10afe65f0710New DB2 best practices paper: DB2 V10 silent installation and uninstallationsboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2013-04-09T16:25:19-04:002013-04-09T16:25:19-04:00<br /><div>
</div><div> We are pleased to announce the publication of a new DB2 for Linux, UNIX, and Windows best practices paper: <a href="https://ibm.biz/Bdx8Hr">DB2 V10 silent installation and uninstallation</a>.</div><div> </div><div>You can use DB2 silent installation and uninstallation to install or uninstall DB2 products and components without user interaction. Silent installation is useful for large-scale deployments of DB2 product editions. It is also useful when you need to embed the DB2 installation and uninstallation processes within the installation process of solutions that include DB2 products. <br /></div><div> </div><div>This paper covers the following tasks:</div><div><ul><li>silent DB2 installation and uninstallation</li><li>silent DB2 fix pack updates</li><li>silent DB2 upgrades to later product versions.</li></ul>In addition to providing detailed recommendations for each task, the paper also includes practical scenarios to help you implement silent DB2 installation and uninstallation in your own environments. <br /></div><div> </div><div><span style="color: rgb(34, 34, 34); font-family: Arial, Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 18px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;">Share your impressions and questions about this paper by adding a comment<span class="Apple-converted-space"> on the paper's web page: </span></span><a href="https://ibm.biz/Bdx8Hr">https://ibm.biz/Bdx8Hr</a> You will need to login to developerWorks with your IBM ID first. </div> We are pleased to announce the publication of a new DB2 for Linux, UNIX, and Windows best practices paper: DB2 V10 silent installation and uninstallation . You can use DB2 silent installation and uninstallation to install or uninstall DB2 products and...102602urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-ac46afd0-b312-4d9d-a2bd-686d5292bc29UPDATED Best Practices: DB2 databases and the IBM General Parallel File System (GPFSsboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2013-03-05T16:11:23-05:002013-03-05T16:19:27-05:00
<div>The popular DB2 best practices paper <a href="https://ibm.biz/Bdx2ni">DB2 databases and the IBM General Parallel File System</a> is now updated and includes DB2 V10.1 support.
</div><div><div> </div><div>The examples in this paper are based on DB2 V10 fix pack 2 and GPFS 3.5.0.4 efix13 installed on AIX 6.1 TL6 SP5 but can be extended to more recent versions and other supported platforms. All versions of GPFS are supported with DB2 for Linux, UNIX, and Windows, however, the latest supported fix packs are recommended to ensure the best quality experience.</div><div> <b><br /><br />Technical paper summary:</b><br />In today’s highly competitive marketplace, it is important to deploy a data processing architecture that not only meets your immediate tactical needs, but that also provides the flexibility to grow and change to adapt to your future strategic requirements. To help reduce management costs, add flexibility, and simplify the storage management of your DB2® for Linux®, UNIX®, and Windows® installation, you need to choose a file system that is designed to provide a dynamic and scalable platform. The IBM® General Parallel File System™ (GPFS™) is a powerful platform on which to build this type of relational database architecture. This paper describes why GPFS is the right file system to use with DB2 databases by outlining the benefits and providing best practices for deploying GPFS with DB2 software. In addition, a section has been added to this paper to describe the DB2 pureScale feature, and how it configures and uses GPFS.</div>
</div>The popular DB2 best practices paper DB2 databases and the IBM General Parallel File System is now updated and includes DB2 V10.1 support.
The examples in this paper are based on DB2 V10 fix pack 2 and GPFS 3.5.0.4 efix13 installed on AIX 6.1 TL6 SP5...003001urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-cc7bbecf-fbad-4165-afb5-d71d298ae503New DB2 best practices webcast: Best practices for DB2 pureScale performance and monitoringsboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2013-01-11T10:41:17-05:002013-01-11T14:48:52-05:00
You are a busy professional and you don't always have the time and resources to travel to a technical conference, or call into a live web presentation, to listen to technical experts give great presentations about the products and technology you care about. Recorded webcasts offer you the benefits of listening to the same experts, at your own convenience, at the office or at home.<br /><div> </div><div> </div>In this new DB2 best practices webcast, <a href="https://ibm.biz/BdxMvG">DB2 pureScale performance and monitoring</a>, watch and listen as Steve Rees, Senior Technical Staff Member and performance expert at the IBM lab, explains a wide array of configuration and tuning best practices to make your DB2 pureScale environments perform in an optimal fashion.<br />The tips and techniques presented in this webcast reflect information validated through the DB2 team's internal performance testing, as well as performance benchmark tests and customer engagements in real life DB2 pureScale environments.<br /><div> </div><div> </div>In addition to the webcast video, you can download the presentation slides and transcript for easy offline viewing and reading.<br /><div> </div><div> </div>If you have questions for the authors please add a comment to this blog or on the webcast's web page.
You are a busy professional and you don't always have the time and resources to travel to a technical conference, or call into a live web presentation, to listen to technical experts give great presentations about the products and technology you care about....002294urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-736dbabf-3f04-437a-99cc-52dcea48c698New best practices paper: "Building a data migration strategy with IBM InfoSphere Optim High Performance Unload"sboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2012-12-20T16:23:26-05:002012-12-20T16:24:53-05:00
Announcing a new best practice paper: &quot;<a href="https://ibm.biz/BdxyGC">Building a data migration strategy with IBM InfoSphere Optim High Performance Unload</a>&quot;<br /><br />This paper addresses the topic of data migration and how you can use HPU to build a data migration strategy that can be scheduled to be migrated, automatically, from source to target database with no manual steps.<br />No longer do you have to grapple with reserving large amounts of storage capacity on the source or target database to stage data; no longer do you have to worry about preserving identity (surrogate) keys; no longer do you have to worry about generating subsets (ranges) of data to be migrated; and no longer do you have to worry about different DB2 software levels or distribution maps.<br /><div>This newly published and second paper on HPU, the first paper looked at <a href="https://ibm.biz/Bdx2nk">using HPU as part of a recovery strategy</a>, looks at how you can build and implement a data migration strategy using HPU. In testing the recommendations in this paper, we used both an IBM Smart Analytics System and an IBM PureData for Operational Analytics System. </div><div> </div>If you have questions for the authors please add a comment to this blog or against the relevant paper.<br /><br />
Announcing a new best practice paper: &quot; Building a data migration strategy with IBM InfoSphere Optim High Performance Unload &quot; This paper addresses the topic of data migration and how you can use HPU to build a data migration strategy that can be...021808urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00urn:lsid:ibm.com:blogs:entry-843cda1b-d500-4ef2-b60f-7543073d24a0New supplement to DB2 Workload Management best practicessboivin060000F8YYactived4334e67-3b43-4d33-bf32-22a73685871cComment Entriesapplication/atom+xml;type=entryLikes2012-12-18T16:24:18-05:002012-12-18T16:24:18-05:00<div>A new supplement to the popular DB2 best practices paper &quot;Implementing DB2 Workload Management&quot; has just been published. The supplement will help you set the DB2 client information fields for a variety of common middleware applications.<br /><br />You can find it, along with other useful supplements, on the paper's information web page:<a href="https://ibm.biz/Bdx2n6">https://ibm.biz/Bdx2n6</a></div><div> </div><div>The DB2 client information fields are available on each connection to a database. These fields enable an external application that is using a connection to provide additional information to the DB2 database server that can be used to discriminate among connections based on end-user identification. The values in the client information fields are reported by DB2 for Linux®, UNIX®, and Windows® and other members of the DB2 family through various database monitoring and auditing interfaces. They are also leveraged by the DB2 workload definition in DB2 for Linux, UNIX, and Windows Version 9.5 and later as another way to aggregate connections to the database for purposes of monitoring and control.<br /><br />Share your impressions and questions about the paper and supplements by adding comments to the web page (you need to join developerWorks and login first).<br /></div>A new supplement to the popular DB2 best practices paper &quot;Implementing DB2 Workload Management&quot; has just been published. The supplement will help you set the DB2 client information fields for a variety of common middleware applications. You can find...002545urn:lsid:ibm.com:blogs:entries-e14299ae-0fd2-4147-ab21-5152e1b4c26aDB2 for Linux, UNIX, and Windows Best Practices2015-02-12T18:49:59-05:00