urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum0301672017-03-03T15:13:11-05:00IBM Connections - Blogsurn:lsid:ibm.com:blogs:entry-203a59b4-4499-4974-b45f-8a5d0477f40cIBM DB2 11 extended LRSN and RBA format support enhances availability and addresses business riskMichael_D.1100004WAHactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2015-07-01T10:29:56-04:002015-07-01T10:29:56-04:00<p dir="ltr">T<strong>he technical white paper, IMW14819USEN-00, IBM DB2 11 extended LRSN and RBA format support enhances availability and addresses business risk, has been published.</strong></p>
<p dir="ltr">Whether you are installing a new IBM DB2 application, designing your recovery strategy or preparing for increased workloads, your plans must account for the impact on the DB2 log. This vital feature keeps a record of every change to data within DB2 and provides the functionality needed for DB2 restart, transaction backout, and data and object recovery. Since the release of DB2 Version 1 for IBM MVS&trade;, an RBA has been used to identify the location of records within the DB2 log. The original design of the RBA, as a 6-byte value, meant that DB2 could address up to 256 GB of log data. Thirty years ago, that amount of data seemed huge, enough for the foreseeable future.</p>
<p dir="ltr">However, over recent years, it has become clear that the amount of data stored in DB2 has increased exponentially, as has the transaction volume and the number of concurrent users. At the same time, disk performance and capacity have evolved dramatically to accommodate the volume of data and to allow applications speedy and reliable access to it, with increased storage capacity and improved data transfer times. With the introduction of DB2 10 for z/OS and the elimination of almost all virtual storage constraints, customers have taken the opportunity to vertically scale their DB2 systems even further.</p>
<p dir="ltr">These developments have made it clear that the current design of the DB2 log with a 6-byte RBA&mdash;and additionally a 6-byte LRSN in data sharing&mdash;no longer provides sufficient log capacity. The solution to this problem, as described in this white paper, is to extend the RBA and the LRSN to 10 bytes. This optional feature was delivered in DB2 11 for z/OS, giving customers the ability to choose whether to implement the extended RBA and LRSN during the lifetime of DB2 11 for z/OS.</p>
<p dir="ltr">This white paper was written primarily for DB2 for z/OS systems programmers and DBAs who are responsible for implementing the extended RBA and LRSN. It is also intended for IT executives and project managers who are involved in the decision-making and planning processes.</p>
<p dir="ltr">&nbsp;</p>
<p dir="ltr"><strong>Read more and/or download:&nbsp;</strong> <a href="http://www.ibm.com/common/ssi/cgi-bin/ssialias?subtype=WH&amp;infotype=SA&amp;htmlfid=IMW14819USEN&amp;attachment=IMW14819USEN.PDF">http://www.ibm.com/common/ssi/cgi-bin/ssialias?subtype=WH&amp;infotype=SA&amp;htmlfid=IMW14819USEN&amp;attachment=IMW14819USEN.PDF</a></p>T he technical white paper, IMW14819USEN-00, IBM DB2 11 extended LRSN and RBA format support enhances availability and addresses business risk, has been published. Whether you are installing a new IBM DB2 application, designing your recovery strategy or...002524urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-1de43e87-e6bc-4b31-8a77-0c297924bb6dNew for High Performance DBATsagburke060001QPDNactivefalseagburke060001QPDNactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2015-05-26T14:14:11-04:002015-06-25T10:11:11-04:00<p dir="ltr">DB2 10 re-introduced the ability for remote connections to benefit from the dynamic JCC packages being bound with RELEASE(DEALLOCATE). With DEALLOCATE the runtime structures like xPROCS, PTs, and sequential detection are kept across a commit and can result in significant CPU savings. The applications which get the highest return on investment for this would be ones that do the most COMMITs before physically disconnecting, and those which run frequently while issuing SQL against multiple tables. In order for the RELEASE(DEALLOCATE) to take effect 2 steps must be accomplished.</p>
<p dir="ltr">1) The package that the remote application will use must be bound with RELEASE(DEALLOCATE) i.e. SYSLN200 for cursor stability without HOLD and SYSLH200 for cursor stability WITH HOLD.&nbsp; We would not suggest rebinding all of the dynamic JCC packages that are used by all applicaitons to use DEALLOCATE. You should bind a copy of the packages under another collection (other than NULLID), and use the&nbsp; currentPackageSet special register to point those privileged applications to those packages.</p>
<p dir="ltr">2) To enable or disable DDF from treating the packages as DEALLOCATE you would use the -MODIFY DDF PKGREL(BNDOPT) command to turn on and -MODIFY DDF PKGREL(COMMIT) to turn off the high performance DBAT behavior. This allows you to force the packages to behave as RELEASE(COMMIT) when you need DDL, BINDs, or utilities to be able to break-in.</p>
<p dir="ltr">As a safety valve the high performance DBATs could only be reused 200 times before they were destroyed, in order to avoid thread footprint growth, and release certain locks.</p>
<p dir="ltr">None of this is new, but IBM released PI20352 (UI19900) mid-2014 to help scenarios where the connections were dropping before the thread was reused 200 times. When this occurred the DIST non-preemptible SRB cpu time could be driven up and the performance benefit of high performance DBATS would degrade. PI20352 allowed high performance DBATs to be pooled, and reused.</p>
<p dir="ltr">However it was discovered that when these pooled DBATs were reused by a new request from a different application some of the locks could persist from the previous thread. Due to these package allocation and table space intent locks hanging around IBM has now introduced the -MODIFFY DDF PKGREL(BNDPOOL) option with PI31597. This option is for customers that want the DBATs to be pooled in case the connection goes away. Meaning you want the same application to come in and reuse that DBAT because the locks could persist on that thread.</p>
<p dir="ltr">Here is a description for the 3 options for PKGREL.</p>
<p dir="ltr">With PI31597 there is another option for the -MODIFY DDF PKGREL() command:</p>
<p dir="ltr"><a href="http://www-01.ibm.com/support/docview.wss?uid=swg1PI31597">http://www-01.ibm.com/support/docview.wss?uid=swg1PI31597</a></p>
<pre dir="ltr">
<strong>BNDPOOL</strong> - <strong><em>New</em></strong>
- The rules of the RELEASE bind option that was specified when
the package was bound are applied to any package that is used
for remote client processing. The <strong>high performance DBAT</strong> used
by a terminating client connection will be <strong>pooled</strong>.
BNDOPT - <strong>if you have PI20352 applied WITHOUT PI31597</strong> <strong>then the BNDOPT behavior is like that of BNDPOOL where the DBAT will be pooled, possibly leading to the accumulation of locks.</strong>
- The rules of the RELEASE bind option that was specified when
the package was bound are applied to any package that is used
for remote client processing. The <strong>high performance DBAT</strong> used
by a terminating client connection will be <strong>deallocated</strong>.
BNDOPT is the default value of the MODIFY DDF PKGREL command.
COMMIT
- The rules of the RELEASE(COMMIT) bind option are applied to
any package that is used for remote client processing. COMMIT
is the default value when the CMTSTAT subsystem parameter is
set to ACTIVE. If the MODIFY DDF PKGREL command had never been
issued, then COMMIT is the default value. No high performance
DBATs exist while the PKGREL option is set to COMMIT.</pre>
<p dir="ltr"><strong><u>So how do I know which option to use?</u></strong></p>
<p dir="ltr">The 2 key points here are whether or not the application does more than 200 commits before deallocating or disconnecting, AND whether or not you have segregated different applications to different collections for the DEALLOCATE packages.</p>
<p dir="ltr">To determine such candidates you can look at IFCID 365, as below and compare the &#39;INITIATED FROM REMOTE SITE&#39; vs. the &#39;DEALLOCATED CONVERSATIONS&#39;. If the ratio is 200:1 or greater then it is a great candidate for DEALLOCATE in general.</p>
<p dir="ltr"><a href="https://www.ibm.com/developerworks/community/blogs/22586cb0-8817-4d2c-ae74-0ddcc2a409bc/resource/BLOGS_UPLOADED_IMAGES/deallocate.jpg" style="width: 100%; display: inline-block;" target="_blank"><img alt="image" height="137" src="https://www.ibm.com/developerworks/community/blogs/22586cb0-8817-4d2c-ae74-0ddcc2a409bc/resource/BLOGS_UPLOADED_IMAGES/deallocate.jpg" style="display: block; margin: 1em 0pt 0pt; float: left;" width="618"></img></a></p>
<p dir="ltr">&nbsp;</p>
<p dir="ltr">You can also look in the accounting short report and compare the #DDFS (occurrences) vs. the CONV (conversations). Here we see 244 occurrences and 0 conversations ended, so it would be a prime candidate.<a href="https://www.ibm.com/developerworks/community/blogs/22586cb0-8817-4d2c-ae74-0ddcc2a409bc/resource/BLOGS_UPLOADED_IMAGES/deallocate_2.png" style="width: 100%; display: inline-block;" target="_blank"><img alt="image" height="104" src="https://www.ibm.com/developerworks/community/blogs/22586cb0-8817-4d2c-ae74-0ddcc2a409bc/resource/BLOGS_UPLOADED_IMAGES/deallocate_2.png" style="display: block; margin: 1em 0pt 0pt; float: left;" width="550"></img></a></p>
<p dir="ltr">Given you know the behavior of the application as shown above the settings for PKGREL() could be:</p>
<p dir="ltr"><u><strong>COMMIT</strong></u> - is the default and you are not utilizing High Performance DBATs</p>
<p dir="ltr"><u><strong>BNDOPT</strong></u> - if you your applications do not deallocate/disconnect frequently,&nbsp; 200 commits/occurrences per connect request would be ideal, and you have many different applications running against the same JCC package collection using RELEASE(DEALLOCATE), then BNDOPT is the best choice because you would avoid the DIST SRB overhead due to good thread reuse, while still releasing the intent locks at commit</p>
<p dir="ltr"><u><strong>BNDPOOL</strong></u> - if the applications do not reuse the thread 200 times as shown above, but there is only 1 application per JCC package collection (not using the default NULLID collection name) then it would not matter as much that the locks persist across threads, because they are accessing the same objects. However you would get the CPU savings of having the threads pooled so the thread could actually be reused 200 times before it is destroyed.</p>DB2 10 re-introduced the ability for remote connections to benefit from the dynamic JCC packages being bound with RELEASE(DEALLOCATE). With DEALLOCATE the runtime structures like xPROCS, PTs, and sequential detection are kept across a commit and can result in...023902urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-5ee47fc2-642a-47be-96d7-b9812e133677Striping of DB2 for z/OS VSAM datasets for active logs and pagesetsCAMPBELJ developeWorks2000001428activefalseCAMPBELJ developeWorks2000001428activefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2015-05-07T10:25:55-04:002015-05-07T10:25:55-04:00<p dir="ltr">
<font face="Helv" size="2"><font face="Helv" size="2">DFSMS Striping was first introduced in 1993 and it was a success. Striping has served a dual purpose. The first purpose was to avoid hot spots on individual disks, and the second purpose was to increase sequential throughput for individual data streams. Since 1993, alternative techniques have been developed to avoid or dissipate a &ldquo;hot spot&rdquo; . Some examples:</font></font></p>
<ul dir="ltr">
<li>
<font face="Helv" size="2"><font face="Helv" size="2">RAID 5 helping to spread the I/O for each volume to 7 or 8 disk</font></font></li>
<li>
<font face="Helv" size="2"><font face="Helv" size="2">Storage Pool Striping in the DS8000 control unit to spreads volume across multiple RAID ranks in chunks of 1GB. </font></font></li>
</ul>
<p dir="ltr">
<font face="Helv" size="2"><font face="Helv" size="2">Consequently, DFSMS striping is perhaps not needed or is not the best technique for avoiding hot spots. </font></font></p>
<p dir="ltr">
<font face="Helv" size="2"><font face="Helv" size="2">IBM DB2 for z/OS Development used to recommend striping because parallelism helped over slow channels, but channel speed is now so high that the disadvantage of doing more I/Os tends to outweigh any advantage of parallelism.</font></font></p>
<p dir="ltr">
<font face="Helv" size="2"><font face="Helv" size="2">Just because one particular workload might benefit from log striping, does not mean that no workloads will suffer. </font></font></p>
<p dir="ltr">
<font face="Helv" size="2"><font face="Helv" size="2">DB2 uses various data transfer sizes. In all current versions of DB2, dynamic prefetch reads at least 128K, but DB2 utilities read or write at least 256K. Depending on the buffer pool size, sequential prefetch may read up to 256K and utilities may read and write up to 512K. However, if a DB2 query or Insert stream or utility is CPU bound, then striping will not make it faster. This is a common situation, except when creating or restoring image copies are concerned. </font></font></p>
<p dir="ltr">
<font face="Helv" size="2"><font face="Helv" size="2">Striping also will not help if any of the components in the data paths are saturated. These paths consist of channels, host adapters, and the bus in each control unit. Take for example the DB2 RECOVER utility. When you want to recover an individual table space, the paths are not saturated and striping will reduce the time to restore the table space. However, if you want to recover the entire system, there will be many parallel RECOVER jobs which will use parallelism, and the paths may get saturated, in which case striping may well not reduce the time to restore the system.</font></font></p>
<p dir="ltr">
<font face="Helv" size="2"><font face="Helv" size="2">A category of I/O that can possibly benefit from striping is list prefetch. Log apply makes extensive use of list prefetch. If a table space is striped across a single RAID rank, list prefetch may possibly improve modestly if the devices consist of HDDs , and may show more improvement if the devices consist of SSDs. Heavy parallelism tends to reduce the striping benefits with HDDs, but striping continues to do well with SSDs under heavy amounts of parallelism.</font></font></p>
<p dir="ltr">
<font face="Helv" size="2"><font face="Helv" size="2">To summarize the value of striping for table spaces, the most benefit may occur with list prefetch when using SSDs, and the applications that benefit the most will likely be long running queries and utilities. Striping may help with RECOVER: restore from image copies, and to then apply log records. However, everyday workloads will not necessarily get any benefit from striping. </font></font></p>
<p dir="ltr">
<font face="Helv" size="2"><font face="Helv" size="2">During normal OLTP operations, DB2 active logs are written, and are read only to archive the log records and for software replication. Most log writes are synchronous I/Os and each I/O consists of a small number of 4K pages. Faster channels has increased log bandwidth. However, most OLTP workloads never push the log throughput beyond 10 MB/sec. I/O response times for online transactions gradually degrade when log buffers queue up waiting for the previous I/O to complete. </font></font></p>
<p dir="ltr">
<font face="Helv" size="2"><font face="Helv" size="2">As technology has evolved, many customers have used remote DASD replication to protect themselves against disasters. Remote replication is often the cause of I/O performance problems. Since all log writes caused by OLTP are synchronous, log I/O is very susceptible to problems caused by remote DASD replication. Each I/O introduces a risk of another delay, and since striping causes more I/Os, striping increases the risk of a delay. Remote replication is not the only thing that causes stress on a control unit, but it is one of the biggest causes.</font></font></p>
<p dir="ltr">
<font face="Helv" size="2"><font face="Helv" size="2">Striping the active log may help the performance of active log reads as from DB2 9 as the I/O quantity for active log reads was increased from 12 pages to 120 pages. However, given 4 Gbps and faster links, the risks of striping the active logs will likely outweigh the risks - see below.</font></font></p>
<p dir="ltr">
<font face="Helv" size="2"><font face="Helv" size="2">DFSMS striping of the DB2 active log is no longer a tuning option that DB2 for z/OS Development is actively testing and recommending. There have been &#39;hole in the recovery log stream&#39; issues with the use of striping with DB2 10 for z/OS in failure scenarios involving albeit in a tiny number of customers. The problem is that there is no encapsulation of a striped I/O i.e, some stripes make it and some may not when there are failures. DFSMS striping has always worked that way. So we in DB2 for z/OS Development are now actively discouraging customers from using striping when the benefits are speculative at best. For customers who are already striping active log datasets there is performance risk in removing striping, but on the otherhand the chance of hitting above problem is very rare. But nevertheless there is risk. There is also risk in using striping with table spaces with large page size i.e., torned page as not all the stripes made it</font></font></p>
<p dir="ltr">
<font face="Helv" size="2"><font face="Helv" size="2">As has been true in the past, hardware technology is forever changing and the value of DFSMS striping will probably continue to erode. Just because one particular workload may possibly benefit, does not mean that no workloads will suffer. </font></font></p>
DFSMS Striping was first introduced in 1993 and it was a success. Striping has served a dual purpose. The first purpose was to avoid hot spots on individual disks, and the second purpose was to increase sequential throughput for individual data streams. Since...115316urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-1ed8d1cf-5516-4d88-b957-a50554333e39Infosphere Replication Server for z/OS and DB2 migrationagburke060001QPDNactivefalseagburke060001QPDNactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-08-25T17:33:24-04:002014-08-25T17:33:24-04:00<p dir="ltr">
There are two APARs to point out when looking to upgrade DB2 for z/OS when you are using QRep or SQL Replication (now referred to as Infosphere Replication Server).</p>
<p dir="ltr">
The first, PM96954, addresses several issues customers have seen.&nbsp; Most notably high CPU overhead in Qapply when the same row is being updated repeatedly, as well as Qapply ending with ASN0543E due to changes occurring in the DB2 catalog during an online migration.</p>
<ul dir="ltr">
<li>
<span style="font-size:12px;">PM96954 &ndash; Address QRep failures during DB2 10 CM and NFM migration</span>
<ul style="list-style-type:circle;">
<li>
<span style="font-size:12px;"><a href="https://www-304.ibm.com/support/docview.wss?uid=swg1PM96954">https://www-304.ibm.com/support/docview.wss?uid=swg1PM96954</a></span></li>
</ul>
</li>
</ul>
<p dir="ltr">
This informational APAR tracks PTFs for Infosphere Replication server which constitute the recommended service level during an upgrade of DB2 for z/OS.</p>
<ul dir="ltr">
<li>
<span style="font-size:12px;">II11809 &ndash; Informational APAR for Infosphere Replication Server for z/OS (QRep and SQL Replication)</span>
<ul>
<li>
<span style="font-size:12px;"><span style="font-family: times new roman;"><a href="http://www-01.ibm.com/support/docview.wss?uid=isg1II11809">http://www-01.ibm.com/support/docview.wss?uid=isg1II11809</a></span></span></li>
</ul>
</li>
</ul>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
Remember that if you plan on going to DB2 11 you must be on Infosphere Replication Server V10.2.1 prior to migrating to V11 CM mode due to the 10 byte extended RBA values.&nbsp; The IFCID 306 record is changed in CM mode and any product which reads them will need to be on the appropriate maintenance level.</p>
There are two APARs to point out when looking to upgrade DB2 for z/OS when you are using QRep or SQL Replication (now referred to as Infosphere Replication Server). The first, PM96954, addresses several issues customers have seen.&nbsp; Most notably high CPU...002070urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-be99b7f9-0100-45c8-9fd7-452fe22ce995Increased Log Write I/O delay and Other Write I/O delayagburke060001QPDNactivefalseagburke060001QPDNactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-08-25T17:33:02-04:002014-08-25T17:33:02-04:00<p dir="ltr">
There are 2 APARs for DB2 10 which could affect Class 3 wait time in DB2.</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
The first was a fix for an ISO(UR) application not returning recently updated rows. If the updates to a GBP dependent object create overflow records, the side effect of this APAR, is that each over flow page will result in a force log write, and forced write to the coupling facility of the overflow page. If there are many occurrences of this in a batch application for instance then the Log Write I/O suspense could become a noticeable performance degradation. The way to avoid this Log Write I/O is to avoid the writing of overflow records by increasing PCTFREE on the object. Overflow records can occur with compressed rows or VARCHAR fields which change length after the update, and will not fit back into the row&#39;s original place on the data page.</p>
<ul dir="ltr">
<li>
<span style="font-size:12px;"><strong>PM82279 &ndash; closed a gap for ISO(UR) readers when a table space is GBPDEP, but this will force the write of the overflow page and log record if the update causes the row to overflow</strong></span>
<ul style="list-style-type:circle;">
<li>
<span style="font-size:12px;"><strong><a href="http://www-01.ibm.com/support/docview.wss?uid=swg1PM82279">http://www-01.ibm.com/support/docview.wss?uid=swg1PM82279</a></strong></span></li>
</ul>
</li>
</ul>
<p dir="ltr">
Here is a simple SELECT statement to determine the number of overflow records in an object. By determining the percent of rows that have overflowed you can determine the amount of free space that should be preserved in the object to avoid them. In DB2 11 the PCTFREE FOR UPDATE clause can help with this issue and avoid the need for a REORG.</p>
<p dir="ltr" style="margin-left: 80px;">
<span style="font-size:12px;"><span style="color: maroon;"><span style="font-family: consolas;">SELECT</span></span> <span style="color: maroon;"><span style="font-family: consolas;">name</span></span><span style="color: black;"><span style="font-family: consolas;">,</span></span><span style="color: maroon;"><span style="font-family: consolas;">partition</span></span><span style="color: black;"><span style="font-family: consolas;">, (</span></span><span style="color: maroon;"><span style="font-family: consolas;">DEC</span></span><span style="color: black;"><span style="font-family: consolas;">(REORGNEARINDREF)+</span></span><span style="color: maroon;"><span style="font-family: consolas;">DEC</span></span><span style="color: black;"><span style="font-family: consolas;">(REORGFARINDREF))</span></span></span></p>
<p dir="ltr" style="text-autospace:none;">
<span style="font-size:12px;"><span style="color: black;"><span style="font-family: consolas;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /</span></span><span style="color: maroon;"><span style="font-family: consolas;">DEC</span></span><span style="color: black;"><span style="font-family: consolas;">(TOTALROWS) </span></span><span style="color: maroon;"><span style="font-family: consolas;">AS</span></span><span style="color: black;"><span style="font-family: consolas;"> OVERFLOW</span></span></span></p>
<p dir="ltr" style="text-autospace:none;">
<span style="font-size:12px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color: maroon;"><span style="font-family: consolas;">FROM</span></span><span style="color: black;"><span style="font-family: consolas;"> SYSIBM.SYSTABLESPACESTATS </span></span></span></p>
<p dir="ltr" style="text-autospace:none;">
<span style="font-size:12px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color: maroon;"><span style="font-family: consolas;">WHERE</span></span><span style="color: black;"><span style="font-family: consolas;"> TOTALROWS&gt;0 </span></span><span style="color: maroon;"><span style="font-family: consolas;">and</span></span><span style="color: black;"><span style="font-family: consolas;"> dbname = </span></span><span style="color: blue;"><span style="font-family: consolas;">&#39;DSNDB06&#39;</span></span> <span style="color: maroon;"><span style="font-family: consolas;">and</span></span> <span style="color: maroon;"><span style="font-family: consolas;">name</span></span><span style="color: black;"><span style="font-family: consolas;">=</span></span></span></p>
<p dir="ltr" style="margin-left:1.0in;text-indent:.5in;text-autospace:none;">
<span style="font-size:12px;"><span style="color: blue;"><span style="font-family: consolas;">&#39;SYSSTATS&#39;</span></span> <span style="color: maroon;"><span style="font-family: consolas;">and</span></span> <span style="color: maroon;"><span style="font-family: consolas;">partition</span></span><span style="color: black;"><span style="font-family: consolas;"> = 0</span></span><span style="font-family: consolas;"> <span style="color: maroon;">WITH</span> <span style="color: maroon;">UR</span></span><span style="color: black;">;</span></span></p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
This APAR addresses high Other Write I/O due to space map pages taking up space on the vertical deferred write queue and causing more frequent writes. The space map pages themselves are not changed and will not be written out, but a page p-lock is taken against them especially in cases where Member Cluster is used and the object is GBP dependent. The APAR ensures those spacemap pages are not left on the VDWQT queue.</p>
<ul dir="ltr">
<li>
<span style="font-size:12px;"><strong>PI07513 - VDWQT being hit frequently due to unchanged pages being left on the queue resulting in high Other Write I/O</strong></span>
<ul>
<li>
<span style="font-size:12px;"><strong><strong><span style="font-family: times new roman;"><a href="http://www-01.ibm.com/support/docview.wss?uid=swg1PI07513">http://www-01.ibm.com/support/docview.wss?uid=swg1PI07513</a></span></strong></strong></span></li>
</ul>
</li>
</ul>
There are 2 APARs for DB2 10 which could affect Class 3 wait time in DB2. &nbsp; The first was a fix for an ISO(UR) application not returning recently updated rows. If the updates to a GBP dependent object create overflow records, the side effect of this APAR,...142872urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-8019a6de-bf05-46a4-94d1-b6b7139cf6d4Insert performance with UTS PBGagburke060001QPDNactivefalseagburke060001QPDNactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-08-25T17:32:37-04:002014-08-25T17:32:37-04:00<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
If an application uses multi-row insert against a Universal table space, which is partition by growth, the getpage count could be unusually high. This APAR adjusts the space search algorithm as it pertains to multi-row insert.</p>
<p dir="ltr">
&quot;During the exhaustive search prior to the physical extend of the data set, the Multi-Row insert operation encounters a high get page count. In this case, insert operation fails to find available space to insert and will search the same set of space map pages or data pages for each insert operation within<span style="font-size:12px;"> the same Muli-Row insert statement.</span>&quot;</p>
<ul dir="ltr">
<li>
<span style="font-size:12px;"><strong>PI12398 &ndash; slow insert performance on PBG UTS with multi-row insert</strong></span>
<ul style="list-style-type:circle;">
<li>
<span style="font-size:12px;"><strong><a href="http://www-01.ibm.com/support/docview.wss?uid=swg1PI12398&amp;myns=apar&amp;mynp=DOCTYPEcomponent&amp;mync=E">http://www-01.ibm.com/support/docview.wss?uid=swg1PI12398&amp;myns=apar&amp;mynp=DOCTYPEcomponent&amp;mync=E</a></strong></span></li>
</ul>
</li>
</ul>
&nbsp; If an application uses multi-row insert against a Universal table space, which is partition by growth, the getpage count could be unusually high. This APAR adjusts the space search algorithm as it pertains to multi-row insert. &quot;During the...002748urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-cf4b8fd8-ce38-4c35-9a21-d59ff614447cPRO (Persistent Read Only) Status for table partitionsagburke060001QPDNactivefalseagburke060001QPDNactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-08-25T17:32:08-04:002014-08-25T17:32:08-04:00<p dir="ltr">
Customers requested a new object state which would allow readers access to data, eliminate the need to, or effect of a -STOP or -START command to place it in Read Only Status.&nbsp; This Persistent Read Only status causes UPDATE/INSERT/DELETE statements to fail with SQLCODE -904 and RC00C90635. ALTER ROTATE PARTITION as well as other Utilities will fail if there are rows in that partition.</p>
<ul dir="ltr">
<li>
<span style="font-size:12px;"><strong>PM95731 &ndash; new PRO (Persistent Read Only) Status to keep an object in read only status</strong></span>
<ul style="list-style-type:circle;">
<li>
<span style="font-size:12px;"><strong><a href="http://www-01.ibm.com/support/docview.wss?uid=swg1PM95731">http://www-01.ibm.com/support/docview.wss?uid=swg1PM95731</a></strong></span></li>
</ul>
</li>
</ul>
<div dir="ltr">
<span style="font-size:12px;">Recommended procedure for setting the PRO restricted status on a table space partition:<br />
1. -STOP DB() SP() PART() - wait for the command to complete<br />
&nbsp;&nbsp; successfully, verify that the object is in STOP status<br />
&nbsp;&nbsp; (not STOPP) with the -DIS DB command.<br />
2. -START DB() SP() PART() ACCESS(UT)<br />
3. Create two full image copies of the table space partition<br />
&nbsp;&nbsp; with COPY SHRLEVEL REFERENCE<br />
4. Use REPAIR utility to turn on PRO status<br />
5. -START DB() SP() PART() ACCESS(RW)</span></div>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
Along with the preceding APAR the lab has modified the DSNACCOX stored procedure to be able to handle the new PRO status to avoid unnecessary Utility suggestions.</p>
<ul dir="ltr">
<li>
<span style="font-size:12px;"><strong>PI15366 &ndash; adjust DSNACCOX to avoid utilities on objects in persistent read only status</strong></span>
<ul style="list-style-type:circle;">
<li>
<span style="font-size:12px;"><strong><a href="http://www-01.ibm.com/support/docview.wss?crawler=1&amp;uid=swg1PI15366&amp;ce=ism0062&amp;ct=swg&amp;cmp=ibmsocial&amp;cm=h&amp;cr=im&amp;ccy=us">http://www-01.ibm.com/support/docview.wss?crawler=1&amp;uid=swg1PI15366&amp;ce=ism0062&amp;ct=swg&amp;cmp=ibmsocial&amp;cm=h&amp;cr=im&amp;ccy=us</a></strong></span></li>
</ul>
</li>
</ul>
Customers requested a new object state which would allow readers access to data, eliminate the need to, or effect of a -STOP or -START command to place it in Read Only Status.&nbsp; This Persistent Read Only status causes UPDATE/INSERT/DELETE statements to...003263urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-bea81c42-4442-4715-83b3-67fd791a760cDB2 11 auditing with profile tablesagburke060001QPDNactivefalseagburke060001QPDNactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-08-25T17:31:46-04:002014-08-25T17:31:46-04:00<p dir="ltr">
With the increased attention on auditing capabilities around the DB2 engine this new feature adds the capability to do some simple auditing using the system time capability of temporal tables, as well as with some generated expression columns.</p>
<p dir="ltr">
APAR text: &quot; The PTFs for PM99683 (the preconditioning APAR), <a href="http://www-01.ibm.com/support/docview.wss?uid=swg1PI15298">PI15298</a> (the enabling APAR), and <a href="http://www-01.ibm.com/support/docview.wss?uid=swg1PI15666">PI15666</a> (the LOAD utility feature APAR) deliver integrated auditing support using non-deterministic generated expression columns to allow for automatic tracking of some audit information including: a. who modified the data in the table b. what SQL operation modified the data in the table.&quot;</p>
<ul dir="ltr">
<li>
<span style="font-size:12px;"><strong>PM99683- new auditing capability in DB2 11 with profile tables</strong></span>
<ul style="list-style-type:circle;">
<li>
<span style="font-size:12px;"><strong><a href="http://www-01.ibm.com/support/docview.wss?uid=swg1PM99683&amp;myns=apar&amp;mynp=DOCTYPEcomponent&amp;mync=E">http://www-01.ibm.com/support/docview.wss?uid=swg1PM99683&amp;myns=apar&amp;mynp=DOCTYPEcomponent&amp;mync=E</a></strong></span></li>
<li>
<span style="font-size:12px;"><strong>PI15298 &ndash; enabling APAR for PM99683</strong></span>
<ul>
<li>
<span style="font-size:12px;"><strong><strong><span style="font-family: times new roman;"><a href="https://www-304.ibm.com/support/entdocview.wss?uid=swg1PI15298">https://www-304.ibm.com/support/entdocview.wss?uid=swg1PI15298</a></span></strong></strong></span></li>
</ul>
</li>
</ul>
</li>
</ul>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
<span style="font-size:12px;">As a rudimentary example if you are looking at a table of account balances and on Monday an account is inserted with a Balance of $10,000 you would see it enter the base table.</span></p>
<p dir="ltr">
<span style="font-size:12px;"><strong><em>&nbsp;BASE_TABLE</em></strong> <strong>on Monday</strong></span></p>
<table border="1" dir="ltr" height="60" width="499">
<tbody>
<tr>
<td style="width: 166px;">
<span style="font-size:12px;">BALANCE</span></td>
<td style="width: 166px;">
<span style="font-size:12px;">USERID</span></td>
<td style="width: 168px;">
<span style="font-size:12px;">DATA CHANGE OPERATION</span></td>
</tr>
<tr>
<td style="width: 166px;">
<span style="font-size:12px;">10,000</span></td>
<td style="width: 166px;">
<span style="font-size:12px;">&#39;AGB&#39;</span></td>
<td style="width: 168px;">
<span style="font-size:12px;">INSERT</span></td>
</tr>
</tbody>
</table>
<p dir="ltr">
<span style="font-size:12px;"><strong><em>&nbsp;AUDIT_TABLE </em>on Monday</strong> (empty)</span></p>
<table border="1" dir="ltr" height="60" width="499">
<tbody>
<tr>
<td style="width: 166px;">
<span style="font-size:12px;">BALANCE</span></td>
<td style="width: 166px;">
<span style="font-size:12px;">USERID</span></td>
<td style="width: 168px;">
<span style="font-size:12px;">DATA CHANGE OPERATION</span></td>
</tr>
<tr>
<td style="width: 166px;">
&nbsp;</td>
<td style="width: 166px;">
&nbsp;</td>
<td style="width: 168px;">
&nbsp;</td>
</tr>
</tbody>
</table>
<p dir="ltr">
<strong><em>&nbsp;</em></strong></p>
<p dir="ltr">
Now someone else comes in and updates the balance raising it to $20,000 on Tuesday.</p>
<p dir="ltr">
<span style="font-size:12px;"><strong><em>BASE_TABLE</em></strong> <strong>on Tuesday</strong></span></p>
<table border="1" dir="ltr" height="60" width="499">
<tbody>
<tr>
<td style="width: 166px;">
<span style="font-size:12px;">BALANCE</span></td>
<td style="width: 166px;">
<span style="font-size:12px;">USERID</span></td>
<td style="width: 168px;">
<span style="font-size:12px;">DATA CHANGE OPERATION</span></td>
</tr>
<tr>
<td style="width: 166px;">
<span style="font-size:12px;">20,000</span></td>
<td style="width: 166px;">
<span style="font-size:12px;">&#39;NOT_AGB&#39;</span></td>
<td style="width: 168px;">
<span style="font-size:12px;">UPDATE</span></td>
</tr>
</tbody>
</table>
<p dir="ltr">
<span style="font-size:12px;"><strong><em>AUDIT_TABLE</em></strong> <strong>on Tuesday</strong></span></p>
<table border="1" dir="ltr" height="60" width="499">
<tbody>
<tr>
<td style="width: 166px;">
<span style="font-size:12px;">BALANCE</span></td>
<td style="width: 166px;">
<span style="font-size:12px;">USERID</span></td>
<td style="width: 168px;">
<span style="font-size:12px;">DATA CHANGE OPERATION</span></td>
</tr>
<tr>
<td style="width: 166px;">
<span style="font-size:12px;">10,000</span></td>
<td style="width: 166px;">
<span style="font-size:12px;">&#39;AGB&#39;</span></td>
<td style="width: 168px;">
<span style="font-size:12px;">INSERT</span></td>
</tr>
</tbody>
</table>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
I have left off the mandatory beginning timestamp,ending timestamp, and trans_id columns for the system time to simplify the example.</p>
With the increased attention on auditing capabilities around the DB2 engine this new feature adds the capability to do some simple auditing using the system time capability of temporal tables, as well as with some generated expression columns. APAR text:...102980urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-eec3bf21-dfab-45d0-b399-6851ee9e3f42High Performance DBAT performanceagburke060001QPDNactivefalseagburke060001QPDNactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-08-25T17:31:23-04:002014-08-25T17:31:23-04:00<p dir="ltr">
High Performance DBATs were introduce in DB2 10. In order to utilize this feature you must have the JCC packages (i.e. SYSNL200) bound with RELEASE(DEALLOCATE) as well as the&nbsp; -MODIFY DDF PKGREL(BNDOPT) option in place.</p>
<p dir="ltr">
This allows distributed requests to benefit from the performance aspects of not going through deallocation after each commit.&nbsp; Caution should be used when employing this option, as you would not want every distributed application coming in as RELEASE(DEALLOCATE) and using up all of the available DBATs. You can more granularly control these If you bind the dynamic JCC packages into an alternate collection and then allow specific applications to use this by having them specify this collection in the CurrentPackageSet.</p>
<p dir="ltr">
APAR PI20352 was opened because there were times of increased DDF SRB time seen when the thread was deallocated prior to the 200 uses. In order to alleviate this, code has been modified to allow the High Performance DBAT to be pooled if it has not reach the 200 use mark.&nbsp; The POOLINAC timeout value can be used to limit the time the DBAT remains in the pool.</p>
<ul dir="ltr">
<li>
<strong>PI20352 &ndash; high performance DBATs increase DDF SRB time if not reused 200 times</strong>
<ul style="list-style-type:circle;">
<li>
<strong><a href="http://www-01.ibm.com/support/docview.wss?uid=swg1PI20352&amp;myns=apar&amp;mynp=DOCTYPEcomponent&amp;mync=E">http://www-01.ibm.com/support/docview.wss?uid=swg1PI20352&amp;myns=apar&amp;mynp=DOCTYPEcomponent&amp;mync=E</a></strong></li>
</ul>
</li>
</ul>
High Performance DBATs were introduce in DB2 10. In order to utilize this feature you must have the JCC packages (i.e. SYSNL200) bound with RELEASE(DEALLOCATE) as well as the&nbsp; -MODIFY DDF PKGREL(BNDOPT) option in place. This allows distributed requests to...004365urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-4098b7af-2df8-457f-9158-201396cedb1bDB2 11 install job not creating enough BSDS entries to support 10,000 archivesagburke060001QPDNactivefalseagburke060001QPDNactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-08-25T17:30:34-04:002014-08-25T17:30:34-04:00<p dir="ltr">
This only affects new installations of DB2 11, not migrations.</p>
<p dir="ltr">
After a <u><strong>new</strong></u> Version 11 installation of DB2 has created approximately 6534 archive log data set pairs, the offload task can begin failing with MSGDSNJ116I ERROR ATTEMPTING TO ADD ARCHIVE ENTRY TO BSDS.&nbsp; To bypass this problem, you can reduce the maximum number of archive log entries in the BSDS data sets by changing the DSN6LOGP MAXARCH value to 6500 in DSNZPARM.<br />
&nbsp;</p>
<ul dir="ltr">
<li>
<strong>PI22934 &ndash; DSNJU102 not creating enough BSDS entries to support 10,000 archives</strong>
<ul>
<li>
<strong><strong><span style="font-family:times new roman;"><span style="font-size:12.0pt;"><a href="https://www-304.ibm.com/support/entdocview.wss?uid=swg1PI22934">https://www-304.ibm.com/support/entdocview.wss?uid=swg1PI22934</a></span></span></strong></strong></li>
</ul>
</li>
</ul>
<p dir="ltr">
From the APAR text, and how to determine if you rae affected:</p>
<p dir="ltr">
------------------</p>
<p dir="ltr">
DSNJU102 does not create enough log data set records in the&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
BSDS data sets to support 10,000 archive log data set pairs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
when the BSDS data sets are formatted under DB2 Version 11.1.&nbsp;&nbsp;&nbsp; &nbsp;<br />
To verify that this problem has occurred, print the BSDS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
control record (key = 04000001) with IDCAMS.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
//STEP1&nbsp;&nbsp;&nbsp; EXEC PGM=IDCAMS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
//SYSPRINT DD&nbsp; SYSOUT=*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
//SYSUDUMP DD&nbsp; SYSOUT=*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
//BSDS&nbsp;&nbsp;&nbsp; DD DISP=SHR,DSN=DSNC000.DB2A.BSDS01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
//SYSIN&nbsp;&nbsp;&nbsp; DD&nbsp; *&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PRINT -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INFILE(BSDS) -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROMKEY(X&#39;04000001&#39;) -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TOKEY(X&#39;04000001&#39;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
From the output, the BCR1HIKY value is at offset x&#39;18&#39;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
into this record.&nbsp; If the BCR1HIKY value is 040001E7, the BSDS&nbsp;&nbsp; &nbsp;<br />
was not formatted correctly.&nbsp; If DSNZPARM specifies a DSN6LOGP&nbsp;&nbsp; &nbsp;<br />
MAXARCH value over 6534 and TWOARCH=YES, the log offload task&nbsp;&nbsp;&nbsp; &nbsp;<br />
could start failing with MSGDSNJ116I after approximately 6534&nbsp;&nbsp;&nbsp; &nbsp;<br />
archive log pairs have been added to the BSDS data sets.&nbsp; If&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
the BCR1HIKY value is 040002F0 or 040002F1, then the BSDS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
data sets will have enough data set records to support up to&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
the maximum of 10,000 archive log data set pairs and no&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
action is needed.<br />
&nbsp;</p>
This only affects new installations of DB2 11, not migrations. After a new Version 11 installation of DB2 has created approximately 6534 archive log data set pairs, the offload task can begin failing with MSGDSNJ116I ERROR ATTEMPTING TO ADD ARCHIVE ENTRY TO...002164urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-a4c6b90f-d7d6-41f3-a903-5fd69228d094REORGCLUSTERSENS column is NULL after DB2 10 NFMagburke060001QPDNactivefalseagburke060001QPDNactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-08-25T17:29:58-04:002014-08-25T17:29:58-04:00<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
DB2 10 added a new column, REORGCLUSTERSENS, to RTS tablespace SYSIBM.SYSTABLESPACESTATS. This indicates the number of times data has been read by SQL statements that are sensitive to the clustering sequence since the last REORG or LOAD REPLACE, and is used by DSNACCOX to determine whether a REORG is required. Once in NFM, creating a tablespace or running REORG or LOAD REPLACE sets REORGCLUSTERSENS to zero. However, the ENFM process sets this column to NULL for existing tablespaces, which means they will never be considered for REORG by DSNACCOX, until you run a REORG or LOAD REPLACE to initially populate REORGCLUSTERSENS. The recommended work-around is to set REORGCLUSTERSENS for existing tablespaces to a non-zero value after ENFM.</p>
<p dir="ltr">
&nbsp;</p>
<ul dir="ltr">
<li>
<strong>PI22121 &ndash; RTS column REORGCLUSTERSENS is set to NULL during NFM processing for existing tablespaces</strong>
<ul>
<li>
<span style="font-size:12px;"><strong><strong><span style="font-family: times new roman;"><a href="https://www-304.ibm.com/support/entdocview.wss?uid=swg1PI22121&amp;myns=apar&amp;mynp=DOCTYPEcomponent&amp;mync=E">https://www-304.ibm.com/support/entdocview.wss?uid=swg1PI22121&amp;myns=apar&amp;mynp=DOCTYPEcomponent&amp;mync=E</a></span></strong></strong></span></li>
</ul>
</li>
</ul>
&nbsp; DB2 10 added a new column, REORGCLUSTERSENS, to RTS tablespace SYSIBM.SYSTABLESPACESTATS. This indicates the number of times data has been read by SQL statements that are sensitive to the clustering sequence since the last REORG or LOAD REPLACE, and is...002671urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-e3301a8a-758d-4168-b1bb-654e1de98c7fCRITICALPAGING function in z/OSagburke060001QPDNactivefalseagburke060001QPDNactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-08-25T17:29:20-04:002014-08-25T17:29:20-04:00<p dir="ltr">
Many customers these days are utilizing DASD mirroring solutions as well as Hyperswap technology to automate fail-over to an alternate site or to local DASD hardware in the event of a failure or disaster. z/OS APAR OA31707 was put out to aid in the event of a fail-over by ensuring any pages it might need would not be paged out to AUX.</p>
<p dir="ltr">
From OA31707:<span style="font-size:12px;"> &quot;</span>During a Hyperswap, it is possible for the system to require page fault resolution via page devices that may be part of the scope of devices being recovered by the Hyperswap. If this occurs, it is possible that a page fault will not be able to be resolved leading to deadlock and Hyperswap failures.&quot;</p>
<p dir="ltr">
The downside of this is a massive amount of page fixed storage which includes the following:</p>
<ol dir="ltr">
<li style="margin-top: 0in; margin-right: 0in; margin-bottom: 12pt;">
31- bit common storage (both above and below 16M)</li>
<li style="margin-top: 0in; margin-right: 0in; margin-bottom: 12pt;">
Address spaces that are defined as critical for paging</li>
<li style="margin-top: 0in; margin-right: 0in; margin-bottom: 12pt;">
All data spaces associated with those address spaces that are critical for paging (unless CRITICALPAGING=NO was specified on the DSPSERV CREATE)</li>
<li style="margin-top: 0in; margin-right: 0in; margin-bottom: 12pt;">
Pageable link pack area (PLPA)</li>
<li style="margin-top: 0in; margin-right: 0in; margin-bottom: 12pt;">
Shared pages</li>
<li style="margin-top: 0in; margin-right: 0in; margin-bottom: 12pt;">
All HVCOMMON objects</li>
<li style="margin-top: 0in; margin-right: 0in; margin-bottom: 12pt;">
All HVSHARED objects</li>
</ol>
<p dir="ltr" style="margin-top: 0in; margin-right: 0in; margin-bottom: 12pt;">
The purpose of this entry is to ensure customers are aware of the effect on real storage when this function is enabled, and to plan for it in advance.&nbsp; A system that is already running lean on REAL storage may see increased demand paging once this function is enabled, which can lead to DB2 entering DISCARD MODE (contraction) due to the REALSTORAGE_MANAGEMENT setting. Toggling in and out of DISCARD MODE frequently will increase CPU consumption on the LPAR and can result in parts of the DB2 address space (not protected by CRITICAL PAGING) being pushed out to AUX.</p>
<p dir="ltr" style="margin-top: 0in; margin-right: 0in; margin-bottom: 12pt;">
If you have page fixed your buffer pools then the vast majority of the DBM1 PRIVATE address space will never be paged to AUX either, so you could end up with a severe shortage of REAL storage on the LPAR.&nbsp;</p>
<p dir="ltr">
You can issue the D XCF,COUPLE command to determine if the function is enabled.</p>
<p dir="ltr">
Further important information about the protection provided by this APAR and the service it introduces can be found as follows:</p>
<ul dir="ltr">
<li>
<strong>OA31707 &ndash; CRITICALPAGING introduced to harden page sets deemed important to Hiperswap </strong>
<ul style="list-style-type:circle;">
<li>
<strong><a href="http://www-01.ibm.com/support/docview.wss?uid=isg1OA31707">http://www-01.ibm.com/support/docview.wss?uid=isg1OA31707</a></strong></li>
</ul>
</li>
<li>
<strong>OA43101 -HIPER update to CRITICALPAGING documentation</strong>
<ul>
<li>
<strong><a href="http://www-01.ibm.com/support/docview.wss?rs=0&amp;q1=OA43101&amp;uid=isg1OA43101&amp;loc=en_US&amp;cs=utf-8&amp;cc=us&amp;lang=en">http://www-01.ibm.com/support/docview.wss?rs=0&amp;q1=OA43101&amp;uid=isg1OA43101&amp;loc=en_US&amp;cs=utf-8&amp;cc=us&amp;lang=en</a></strong></li>
</ul>
</li>
<li>
<strong>White Paper on Critical Paging</strong>
<ul>
<li>
<strong><a href="http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP101800">http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP101800</a></strong></li>
</ul>
</li>
</ul>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
Two other APARs relate to the REAL storage growth seen in DB2 due z/OS not reclaiming frames when CRITICAL PAGING was enabled....</p>
<ul dir="ltr">
<li>
<strong>PM99575 &ndash; change the DISCARD DATA logic based on customer settings for REALSTORAGE_MANAGEMENT</strong>
<ul style="list-style-type:circle;">
<li>
<strong><a href="http://www-01.ibm.com/support/docview.wss?uid=swg1PM99575">http://www-01.ibm.com/support/docview.wss?uid=swg1PM99575</a></strong></li>
</ul>
</li>
<li>
<strong>OA44193 &ndash; RSM does not steal frames with DISCARD KEEPREAL YES backing HVSHARE when customers have CRITICAL PAGING enabled</strong>
<ul>
<li>
<span style="font-size:14px;"><strong><strong><span style="font-family: times new roman;"><a href="http://www-01.ibm.com/support/docview.wss?crawler=1&amp;uid=isg1OA44913">http://www-01.ibm.com/support/docview.wss?crawler=1&amp;uid=isg1OA44913</a></span></strong></strong></span></li>
</ul>
</li>
</ul>
Many customers these days are utilizing DASD mirroring solutions as well as Hyperswap technology to automate fail-over to an alternate site or to local DASD hardware in the event of a failure or disaster. z/OS APAR OA31707 was put out to aid in the event of a...003592urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-6207b2d4-4a44-4724-837f-c1a7f5631551Where do I find PDFs of the DB2 for z/OS information?mjparker120000QPNAactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-07-08T15:11:53-04:002014-07-08T15:11:53-04:00<p dir="ltr">
Some of you might have noticed that IBM Knowledge Center does not include topic footers that provide a link to the information in PDF format. However, the DB2 for z/OS information is still available in PDF format.<br />
<br />
From the product welcome page of each version in IBM KC (for example: <a href="http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc/src/alltoc/db2z_11_prodhome.html">http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc/src/alltoc/db2z_11_prodhome.html</a>), click the <strong>DB2 for z/OS PDF books</strong> link in the <strong>More information</strong> column. This link takes you to the <strong>DB2 for z/OS Product Documentation</strong> web page, where you can download the information in PDF format:<br />
<a href="http://www-01.ibm.com/support/docview.wss?uid=swg27039165">http://www-01.ibm.com/support/docview.wss?uid=swg27039165</a><br />
<br />
Just like in the information center, the content in IBM KC is the most current.</p>
Some of you might have noticed that IBM Knowledge Center does not include topic footers that provide a link to the information in PDF format. However, the DB2 for z/OS information is still available in PDF format. From the product welcome page of each version...002269urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-bc0e8a2b-d64b-4e4d-b84c-561461f54b3bDB2 for z/OS documentation has a new home - the Knowledge CenterGZJ1100006WMTactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-07-04T11:54:36-04:002014-07-04T11:54:36-04:00<p dir="ltr">
The DB2 for z/OS Information Center has been replaced as the source for for all official DB2 for z/OS product information on the web by <a href="http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc/src/alltoc/db2z_11_prodhome.html" target="_blank">the&nbsp;DB2&nbsp;11&nbsp;for&nbsp;z/OS&nbsp;Knowledge&nbsp;Center</a>. The IBM Knowledge Center also provides links to additional information resources and alternative documentation formats, such as the PDF manuals in the IBM Publications Center. You should update your bookmarks to ensure that you move from the Information Center to the better-performing Knowledge Center.</p>
The DB2 for z/OS Information Center has been replaced as the source for for all official DB2 for z/OS product information on the web by the&nbsp;DB2&nbsp;11&nbsp;for&nbsp;z/OS&nbsp;Knowledge&nbsp;Center . The IBM Knowledge Center also provides links to...101721urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-3dad0c81-d33b-4c12-8c78-1199be6f4fceDB2 10 and DB2 11 usage of 1MB pageable large frames.GZJ1100006WMTactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-07-04T11:43:45-04:002014-07-04T11:43:45-04:00<p dir="ltr">
<span style="font-family:arial,helvetica,sans-serif;"><span style="font-size: 12px;">It is a common belief that DB2 10 and 11 for z/OS can only use 1MB size pageable large pages, other than for buffers, if the CEC has Flash Express installed. For example, the&nbsp; text for APAR PM85944 infers just that. However, this is not true. The only requirement is that the CEC be SCM-capable (SCM = </span></span><span style="font-family:arial,helvetica,sans-serif;"><span style="font-size: 12px;">Storage-Class Memory)</span></span><span style="font-family:arial,helvetica,sans-serif;"><span style="font-size: 12px;">.&nbsp;In other words, it does not matter whether Flash Express is actually installed or not.&nbsp; So if a customer is running on a zEC12 CEC without Flash Express, DB2 could request, and be given, a 1MB size pageable large page, residing in a 1MB size large page frame.&nbsp; However if that page needs to get paged out for some reason, at that point it will be broken down into 4KB page frames. To put it another way, pageable large pages are available on a zEC12 capable CEC with the caveat that if Flash Express is <em>not</em> installed, then if those pages are ever paged out they will be demoted to 4KB page frames. 1MB pageable large pages that are demoted to 4KB page frames as they paged out will never be coalesced</span></span><span style="font-family:arial,helvetica,sans-serif;"><span style="font-size: 12px;">:</span></span><span style="font-family:arial,helvetica,sans-serif;"><span style="font-size: 12px;"> that is, they will remain 4KB page frames for the remaining life of the IPL.</span></span></p>
It is a common belief that DB2 10 and 11 for z/OS can only use 1MB size pageable large pages, other than for buffers, if the CEC has Flash Express installed. For example, the&nbsp; text for APAR PM85944 infers just that. However, this is not true. The only...004317urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-d909061f-e046-48dc-93ff-a166679131efMonitor open APAR PI18475 which addresses ABEND0C4 in DXRRL770 after PI07853/UI14551GZJ1100006WMTactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-07-02T08:52:14-04:002014-07-02T08:52:14-04:00<p dir="ltr">
Watch out for open APAR PI18475. This describes a situation where IRLM V2.3 fails with ABEND0C4 in DXRRL770 after PI07853/UI14551 is applied.<br />
<br />
The error occurs during P-lock processing. The full range of symptoms is unknown, but include DB2 termination with reason code 00C90093, indicating an invalid request to update an object allocated to a utility, preceded by message DSNT501I with reason code 00C202AA.<br />
<br />
However, be aware of the warning implied in the APAR text indicating that &quot;other symptoms may be possible&quot;. It is strongly recommended that you monitor this APAR and apply the corrective maintenance when available.</p>
Watch out for open APAR PI18475. This describes a situation where IRLM V2.3 fails with ABEND0C4 in DXRRL770 after PI07853/UI14551 is applied. The error occurs during P-lock processing. The full range of symptoms is unknown, but include DB2 termination with...001559urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-44e3976a-00dd-4c28-a619-58e7eefec34fGuard against a failed RECOVER with TOCOPY, TOLOGPOINT or TORBAGZJ1100006WMTactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-07-02T08:49:07-04:002014-07-02T08:49:07-04:00<p dir="ltr">
The last thing you want to deal with when in a recovery situation is a failed RECOVER, so keep an eye on APAR PI17986, which was closed very recently. This affects customers DB2 10 and DB2 11 customers who have APAR PM88455, PTF UK97229/UK97230 applied. The APAR abstract indicates that this affects customers who use RECOVER TOCOPY, but closer examination of the APAR text reveals that this can also affect customers who use RECOVER TOLOGPOINT or TORBA, so in other words this can affect any PIT recovery.<br />
<br />
The RECOVER can fail with RC 8, and something like the following message is issued:<br />
<br />
<span style="font-family:courier new,courier,monospace;">DSNU556I - RECOVER CANNOT PROCEED FOR TABLESPACE db.ts DSNUM x<br />
TOCOPY copy_data_set BECAUSE A SYSIBM.SYSCOPY RECORD HAS BEEN<br />
ENCOUNTERED WHICH HAS DBNAME=db TSNAME=ts DSNUM=y ICTYPE=M<br />
STYPE=R STARTRBA=X&#39;nnnnnnnnnnnn&#39; LOWDSNUM=0 HIGHDSNUM=0</span><br />
<br />
Although the APAR is closed, the PTFs are not yet available. It is strongly advised that you monitor this APAR and apply the corrective maintenance when available.</p>
The last thing you want to deal with when in a recovery situation is a failed RECOVER, so keep an eye on APAR PI17986, which was closed very recently. This affects customers DB2 10 and DB2 11 customers who have APAR PM88455, PTF UK97229/UK97230 applied. The...001778urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-dc4fa40b-7508-41f2-9228-2968bc1ed697Customers using REORG with the FORCE option should consider applying APAR PI15304 as a matter of priority.GZJ1100006WMTactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-07-02T08:45:24-04:002014-07-02T08:45:24-04:00<p dir="ltr">
The text for APAR&nbsp; PI15304 can be read at <a href="http://www-01.ibm.com/support/docview.wss?uid=swg1PI15304">http://www-01.ibm.com/support/docview.wss?uid=swg1PI15304</a>, but it&#39;s worth a few additional words of explanation here for customers who are using REORG with the FORCE option to cancel blocking threads.<br />
<br />
Without this fix applied, when REORG FORCE cancels a thread, the cancel operation picks up a control block address without holding a latch, and when that control block address is used for thread cancellation, it might actually have been reused by a different thread. So there are two possibilities: the wrong thread may get cancelled; and, if that is the case, depending on what that cancelled thread id doing, DB2 may be brought down. The fix causes a latch to be acquired when picking up the control block address, ensuring that the right thread is cancelled, and protecting you from a DB2 outage.</p>
The text for APAR&nbsp; PI15304 can be read at http://www-01.ibm.com/support/docview.wss?uid=swg1PI15304 , but it&#39;s worth a few additional words of explanation here for customers who are using REORG with the FORCE option to cancel blocking threads. Without...001162urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-c32d0ec2-d4d1-4fee-9112-0e9d8adb0b2cProblems allocating large datasetsGZJ1100006WMTactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-07-02T08:42:16-04:002014-07-02T08:42:16-04:00<p dir="ltr">
Many customers experience problems when allocating large datasets, because the datasets&nbsp; often end up being allocated in many extents. This can affect performance and availability as high frequency extent allocation or in extreme cases lead to extent allocation failure. The following is a partial rework of information provided by John Campbell, IBM DB2 for z/OS Distinguished Engineer, in response to a real customer problem. &nbsp;<br />
<br />
At a high level, the recommended best practice for managing large datasets is for customers to use both Space Constraint Relief and Extent Constraint Removal. That is the easy part of the answer. The difficult part is understanding the implication of setting PRIQTY=-1 for large objects.<br />
<br />
In terms of volume maintenance, the vast majority of customers do not DEFRAG their volumes; sometimes this is just impossible because of 24x7 operations, but sometimes customers do not even know they need to. Consider the impact, if you have fragmented volumes, and DB2 is using the sliding scale of secondary allocation. DB2 might, for example, allocate 7 cylinders, and then work out it needs to allocate 8 cylinders on the next allocation using the sliding scale, but the volume is so fragmented that another extent has to be found as the adjacent space does not hold 8 cylinders, therefore resulting in many extents.<br />
<br />
If you find yourself in this situation, there are some questions you need to answer and consideratiobs to take into account:</p>
<ol dir="ltr">
<li>
What 3390 model type are you emulating? You might be struggling to obtain a PRIQTY of 36000, for example, which might seem quite big but is only 500 cylinders and is not, in fact, very large. This opens up the possibility that you are still emulating 3390 Mod-3s, which are, by today&#39;s standards, very small. The larger the logical model size you are emulating, the less of an issue finding 500 cylinders should be.</li>
<li>
What is the HIGH specification in ISMF for the SMS Storage Group? Many customers are using 99% and forcing datasets to go multi-volume, causing additional DB2 performance degradation because of the additional synchronous request to the ICF catalog for each new volume used.</li>
<li>
Are there enough volumes in the SMS Storage Group? Many customers are running their systems lean and mean, and do not have enough logical volumes. Even if they understand that, they are often unwilling to add more volumes because of the cost.</li>
<li>
What DSSIZE you use indicates how many extents it will take to get to that 500 cylinder point, via a gradual slide or stepping stone.</li>
<li>
For many customers there will be a 90/10 split for small vs. large data sets. If you assume 300 cylinders as the dividing line (this is an arbitrary value used for purposes of this discussion), then 90% of objects would be below 300 cylinders and 10% of the objects above. It would therefore make sense to provide two SMS Storage Groups, one for small objects, and one for large objects. The &#39;large&#39; pool should have some additional logical volumes as a &#39;buffer&#39; for doing such things as parallel Online REORGs. This way the small objects don&#39;t introduce fragmentation into the Storage Pool for the large data sets, and therefore would cause many fewer problems. The problem with PRIQTY -1 or a value very low is that it will not trigger the Storage Group ACS routine to allocate the datasets in the &#39;large&#39; pool, because the allocations are based on an initial space allocation which is too small. You could take individual data sets or a set of them and have the ACS routines place them specifically in the &#39;large&#39; pool, but that would be a manual approach. An alternative is if the installation to allow DBAs to specify one of the SMS classes on the CREATE/ALTER STOGROUP, the Storage Administrator can then code the Storage Group ACS routine so as assign the datasets into a specific special class&nbsp; and into the &#39;large&#39; pool based on the class name provided. This takes away the manual effort and gives more control to DBAs. &nbsp;</li>
</ol>
<p dir="ltr">
<br />
When John was helping design sliding secondary allocation, he never envisaged PRIQTY=SECQTY=-1 to be a &#39;one size fit all&#39; approach to be used for all objects. If you know the allocation for an object will be large, a common approach is to allocate 1000 cylinders primary, and 100 cylinders secondary if there is enough room. This is true for Online REORG of large objects as well as those that do not use REUSE or ALTER of the space before the REORG. In this case DB2 Data Space Manager will go through the slide scale all over again, so a 2900+ cylinder 2GB data set slides from the beginning even though we know what the potential high end size will be.<br />
<br />
Be aware that every time a new extent is taken there is a synchronous request to the VTOC, plus the performing of the sliding scale calculation, and if the object goes multi-volume then add the additional synchronous request for the ICF catalog to add a new volume. Very few customers see this performance impact.<br />
<br />
So in summary, I will make the following recommendations:<br />
<br />
Enable both Space Constraint Relief and Extent Constraint Removal. For more information, see z/OS DFSMSdfp Storage Administration, SC23-6860-01.<br />
Have a segregated SMS Storage Group with additional volumes for large allocations.<br />
Use larger emulated logical volumes.<br />
Use a reasonable value for the ISMF Storage Group HIGH value. For more information, see z/OS DFSMS Implementing System-Managed Storage, SC23-6849-00.</p>
Many customers experience problems when allocating large datasets, because the datasets&nbsp; often end up being allocated in many extents. This can affect performance and availability as high frequency extent allocation or in extreme cases lead to extent...012896urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-706d4371-5ac7-41db-9446-82784cd80620New Information APAR - DB2 recommended APARs and tuning for INSERT performanceflodubois270000K6H5activefalseflodubois270000K6H5activefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-04-29T02:11:37-04:002014-04-29T02:11:37-04:00<p dir="ltr">
This new information APAR is opened for recommended APARs and tuning to improve DB2 INSERT performance based on recent observations from analysis and solution to customers using SAP application - but these recommendation should also apply to general customers.</p>
<p dir="ltr">
<a href="http://www-01.ibm.com/support/docview.wss?uid=isg1II14743" target="_blank">http://www-01.ibm.com/support/docview.wss?uid=isg1II14743</a></p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
This new information APAR is opened for recommended APARs and tuning to improve DB2 INSERT performance based on recent observations from analysis and solution to customers using SAP application - but these recommendation should also apply to general customers....001318urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-c72837eb-346a-456f-b413-4b6305366541Article - Online DB2 for z/OS Migrationflodubois270000K6H5activefalseflodubois270000K6H5activefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-04-29T02:07:15-04:002014-04-29T02:07:15-04:00<h3 dir="ltr">
<em><span>Migrating DB2 for z/OS with the business application set active</span></em></h3>
<p dir="ltr">
Increasingly, customers must keep their applications online and available all hours of every day, 24X7. Fortunately, the DB2 migration process has been designed specifically to allow the business application set to continue to run while you migrate. This article by Jay Yothers, IBM Senior Technical Staff Member, provides hints and tips to make your online migration successful.</p>
<p dir="ltr">
<a href="http://www.ibm.com/developerworks/data/library/techarticle/dm-1305online/index.html" target="_blank">http://www.ibm.com/developerworks/data/library/techarticle/dm-1305online/index.html</a></p>
Migrating DB2 for z/OS with the business application set active Increasingly, customers must keep their applications online and available all hours of every day, 24X7. Fortunately, the DB2 migration process has been designed specifically to allow the business...001580urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-f6c9482b-7553-4101-82ee-e0075224124eDraft Redbooks - DB2 11 for z/OS Performance Topicsflodubois270000K6H5activefalseflodubois270000K6H5activefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-04-29T02:05:48-04:002014-04-29T02:05:48-04:00<p dir="ltr">
This new IBM Redbooks publication discusses the performance and possible impacts of the most important functions in DB2 11 for z/OS. It includes performance measurements that were made in the laboratory and provide some estimates improvements when moving from DB2 10.</p>
<p dir="ltr">
<a href="http://www.redbooks.ibm.com/redpieces/abstracts/SG248222.html?Open&amp;myns=swgimgmt&amp;mynp=OCSSEPEK&amp;mync=E" target="_blank">http://www.redbooks.ibm.com/redpieces/abstracts/SG248222.html?Open&amp;myns=swgimgmt&amp;mynp=OCSSEPEK&amp;mync=E</a></p>
This new IBM Redbooks publication discusses the performance and possible impacts of the most important functions in DB2 11 for z/OS. It includes performance measurements that were made in the laboratory and provide some estimates improvements when moving from...001490urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-65a38efe-8cbf-4d04-8883-12a1158fd438Redbooks - DB2 11 for z/OS Technical Overviewflodubois270000K6H5activefalseflodubois270000K6H5activefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-04-29T02:04:08-04:002014-04-29T02:04:08-04:00<p dir="ltr">
This new IBM Redbooks publication introduces the enhancements made available with DB2 11 for z/OS.</p>
<p dir="ltr">
<a href="http://www.redbooks.ibm.com/abstracts/SG248180.html?Open&amp;myns=swgimgmt&amp;mynp=OCSSEPEK&amp;mync=E" target="_blank">http://www.redbooks.ibm.com/abstracts/SG248180.html?Open&amp;myns=swgimgmt&amp;mynp=OCSSEPEK&amp;mync=E</a></p>
This new IBM Redbooks publication introduces the enhancements made available with DB2 11 for z/OS. http://www.redbooks.ibm.com/abstracts/SG248180.html?Open&amp;myns=swgimgmt&amp;mynp=OCSSEPEK&amp;mync=E001379urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-6d654739-24a9-489d-8887-c6c07211e0a2Dealing with DB2 z/OS Hung/Wait situations:Michael_D.1100004WAHactivefalseMichael_D.1100004WAHactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-03-31T12:48:01-04:002014-04-07T01:07:43-04:00<p dir="ltr">
<strong>Dealing with DB2 z/OS Hang/Wait situations:</strong><br />
<br />
<strong>APAR II13538:</strong> DEALING WITH HUNG COUPLING FACILITY CONNECTIONS IXLCONN REASON CODE 02010C27 0C27 02010C09 APAR status<br />
<a href="http://www-01.ibm.com/support/docview.wss?uid=isg1II13538">http://www-01.ibm.com/support/docview.wss?uid=isg1II13538</a><br />
When a DB2 member abnormally terminates, its connections to the coupling facility structures are put into a FAILING state by cross-system extended services for z/OS (XES). The FAILING DB2 member remains in this state until all surviving members of the group have responded to the XES Disconnected/Failed Connection (DiscFailConn) event for each structure. XES sends this event to each surviving member of the group so that the necessary recovery actions can be taken in response to the failed member.<br />
<br />
For this reason it is important to preform the actions described in this informational APAR to recover from hung CF structure connections.<br />
<br />
<br />
Other important informational APARs in this area are:&nbsp; &nbsp;<br />
<strong>APAR II14016</strong>: DB2 RA10 R910 R810 HANG WAIT SUSPEND LOOP PROBLEM SUMMARY and for HANG or WAIT problems in DB2 DISTRIBUTED asid also see <strong>II08215 + II11164.</strong><br />
&nbsp;</p>
Dealing with DB2 z/OS Hang/Wait situations: APAR II13538: DEALING WITH HUNG COUPLING FACILITY CONNECTIONS IXLCONN REASON CODE 02010C27 0C27 02010C09 APAR status http://www-01.ibm.com/support/docview.wss?uid=isg1II13538 When a DB2 member abnormally terminates,...101542urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-88221440-9c9d-4a38-bbde-213934b6e9f8DB2 Best Practice videos are now available!Michael_D.1100004WAHactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-03-31T12:46:41-04:002014-03-31T12:46:41-04:00<p dir="ltr">
<strong>DB2 Best Practice videos are now available!</strong><br />
<br />
These videos are located on the DB2 for z/OS Best Practices developerWorks website.... <a href="http://www.ibm.com/developerworks/data/bestpractices/db2zos/">http://www.ibm.com/developerworks/data/bestpractices/db2zos/</a><br />
<br />
There are 56 Best Practices located at this site covering DB2 for z/OS, DB2 Tools, and QMF.<br />
<br />
From the best practice pages on this site you can view the videos (streamed from YouTube), download a copy (MP4) to your local machine, download a transcript, and download slides when available.<br />
<br />
<br />
DB2 for z/OS Best Practice: FlashCopy and DB2 for z/OS<br />
<a href="https://ibm.biz/BdRK4R">https://ibm.biz/BdRK4R</a><br />
This Best Practice covers FlashCopy and its uses in conjunction with DB2 for z/OS.&nbsp; It gives you an overview of FlashCopy, how the DB2 utilities use it, and how you can affect the behavior in your environment.&nbsp; How to use FlashCopy to takes backups of data outside of DB2&rsquo;s control is discussed. Finally, how FlashCopy fits in with DASD based replication solutions such as Metro Mirror (PPRC), z/OS Global Mirror (XRC), and Global Mirror.<br />
<br />
DB2 for z/OS Best Practice: How DB2 Performance Structures Improve Performance<br />
<a href="https://ibm.biz/BdRK4t">https://ibm.biz/BdRK4t</a><br />
<br />
In this Best Practice, Sheryl Larsen, the DB2 for z/OS world-wide evangelist discusses structures and appliances that can be used in conjunction with DB2 to improve performance.&nbsp; She presents information on base table indexes, index on expression, Materialized Query Tables (MQTs), zIIPs, and Accelerated Query Tables (AQTs).&nbsp; Decisions and cases regarding when to use these structures are presented.<br />
<br />
DB2 for z/OS Best Practice: Advanced SQL Performance Insights<br />
<a href="https://ibm.biz/BdRKr7">https://ibm.biz/BdRKr7</a><br />
In this Best Practice, Sheryl Larsen, the DB2 for z/OS world-wide evangelist shares many of the insights she has gained in writing efficient and well performing SQL.&nbsp; She explains the stages of SQL processing and filtering and gives practical tips on which predicates might obtain faster results.&nbsp; The steps to review your SQL are outlined.&nbsp; Sheryl also reviews some of the analytic capabilities of SQL statements such as PACK, GROUP BY GROUPING SETS, GROUP BY ROLLUP, and GROUP BY CUBE.<br />
&nbsp;</p>
DB2 Best Practice videos are now available! These videos are located on the DB2 for z/OS Best Practices developerWorks website.... http://www.ibm.com/developerworks/data/bestpractices/db2zos/ There are 56 Best Practices located at this site covering DB2 for...001691urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-3153c691-7c23-4ce7-bd75-1f39d5da2aecRTS REORGLASTTIME is set to creation time without REORG ever executedMichael_D.1100004WAHactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-03-31T12:45:07-04:002014-03-31T12:45:07-04:00<p dir="ltr">
<strong>RTS REORGLASTTIME is set to creation time without REORG ever executed:</strong></p>
<p dir="ltr">
RTS tracks the last time when a REORG utility was executed against an table space / partition object in SYSIBM.SYTABLESPACESTATS.REORGLASTTIME.<br />
However,after a newly created table space object without any REORG executed against it, SYSIBM.SYSTABLESPACESTATS.REORGLASTTIME indicates the same timestamp as the creation time.<br />
<br />
Why is that?<br />
<br />
Actually this behaviour is intended and works as designed. The rational behind is that a newly created empty table is considered perfectly reorganised.<br />
That behaviour is also documented in the DB2 documentation about SYSIBM.SYSTABLESPACESTATS.REORGLASTTIME (<strong>http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.sqlref/src/tpc/db2z_sysibmsystablespacestatstable.dita?cp=SSEPEK_11.0.0%2F10-0-117&amp;lang=en</strong>):<br />
<br />
The timestamp the REORG utility was last run on the table space or partition, or when the REORG utility has not been run, the time when the table space or partition was created. A null value indicates that the timestamp is unknown.<br />
<br />
A value of NULL would indicate an UNKNOWN point in time. One could argue that this theoretically true, no REORG utility was executed against the table space object. However, the other rationale is that DB2 supplied stored procedure DSNACCOX has to identify the need for a REORG based on REORG-INSERT/UPDATE/DELETE values of the SYSIBM.SYSTABLESPACESTATS table. This is basically done based on the SYSIBM.SYSTABLESPACESTATS.UPDATESTATSTIME value and number of SYSIBM.SYSTABLESPACESTATS.REORG-INSERTS/DELETES/UPDATES compared against SYSIBM.SYSTABLESPACESTATS.REORGLASTTIME. So if we would set SYSIBM.SYSTABLESPACESTATS.REORGLASTTIME to NULL during the CREATE time, which means also UNKNOWN, DSNACCOX could not pick on that. In the past we had to run REORG explicitly after create time to enable DSNACCOX.<br />
<br />
With that said, there is also an exception to it. <strong>APAR PM37511 (http://www-01.ibm.com/support/docview.wss?uid=swg1PM37511)</strong> introduced a change where COPY or RUNSTATS would trigger setting RSYSIBM.SYSTABLESPACESTATSEORGLASTTIME to NULL if the RTS row for the affected object did not exist before. This situation could occur when during CREATE TABLESPACE or CREATE INDEXSPACE time the RTS table space was offline or not accessible. Or when migrating from DB2 UDB for z/OS Version 8.1, the table space was created when the RTS support was disabled.<br />
&nbsp;</p>
RTS REORGLASTTIME is set to creation time without REORG ever executed: RTS tracks the last time when a REORG utility was executed against an table space / partition object in SYSIBM.SYTABLESPACESTATS.REORGLASTTIME. However,after a newly created table space...002284urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-730173ff-cb90-4abf-99a7-41b1f2488812DB2 Version 9 for z/OS is June 27, 2014. This is also the EOS date.Michael_D.1100004WAHactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-03-31T12:31:50-04:002014-03-31T12:31:50-04:00<p dir="ltr">
<strong>DB2 Version 9 for z/OS is June 27, 2014. This is also the EOS date.</strong><br />
<br />
DB2 for z/OS Version&nbsp;&nbsp;&nbsp; 9.1.0 PID&nbsp;&nbsp;&nbsp;&nbsp; 5635-DB2<br />
Lifecycle dates:<br />
GA&nbsp;&nbsp; 16-Mar-2007, 207-041<br />
EOM&nbsp;&nbsp;&nbsp;&nbsp; 10-Dec-2012, 911-239<br />
<strong>EOS&nbsp;&nbsp;&nbsp;&nbsp; 27-Jun-2014, 912-009</strong><br />
&nbsp;</p>
DB2 Version 9 for z/OS is June 27, 2014. This is also the EOS date. DB2 for z/OS Version&nbsp;&nbsp;&nbsp; 9.1.0 PID&nbsp;&nbsp;&nbsp;&nbsp; 5635-DB2 Lifecycle dates: GA&nbsp;&nbsp; 16-Mar-2007, 207-041 EOM&nbsp;&nbsp;&nbsp;&nbsp; 10-Dec-2012, 911-239...001216urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-72c58d7f-b63b-463b-9a74-c4ca3850c578Recent DB2 Connect APARs for DB2 11 migration plansMichael_D.1100004WAHactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-03-31T12:16:00-04:002014-03-31T12:16:00-04:00<p dir="ltr">
A couple of recent DB2 Connect APARs have been identified as high pervasive and can impact customers planning on migrating to DB2 Connect 10.5 fix pack 2 in preparation for their migrating to DB2 11. &nbsp;<br />
<br />
When discussing on DB2 11 migration plans, please review the following DB2 Connect APARs.<br />
<br />
<strong>APAR IC99419 </strong>CLI-BASED APPLICATIONS RECEIVE SQL0501N AGAINST DB2 Z/OS WHEN STORED PROCEDURE CALL HAS MULTIPLE CURSORS<br />
<strong>APAR IC98222</strong> COMPLETE SPECIAL REGISTER SUPPORT FOR DB2 Z/OS V11<br />
<strong>APAR IC99735</strong> GETJCCSPECIALREGISTERPROPERTIES () RETURNS SQLCODE -4743 AGAINST V11NFM WITH V10R1 APPLCOMPAT PACKAGES<br />
<br />
If you are planning to deploy DB2 Connect 10.5 fix pack 2 and are susceptible to the reported problem, the recommendation is to either request a special build with the APAR fix or wait until the APAR is closed in a future fix pack available.<br />
<br />
Please review DB2 information<br />
<strong>APAR II14732</strong> : V11 migration info APAR periodically. The DB2 z/OS APAR contains a list of known migration issues and is updated as soon as DB2 is made aware of a problem<br />
<a href="http://www-01.ibm.com/support/docview.wss?uid=isg1II14732">http://www-01.ibm.com/support/docview.wss?uid=isg1II14732</a><br />
<br />
<strong>APAR II14730:</strong> IBM DATA SERVER DRIVER APARS RELATED TO DB2 z/OS DISTRIBUTED ENVIRONMENTS.<br />
&nbsp;</p>
A couple of recent DB2 Connect APARs have been identified as high pervasive and can impact customers planning on migrating to DB2 Connect 10.5 fix pack 2 in preparation for their migrating to DB2 11. &nbsp; When discussing on DB2 11 migration plans, please...101614urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-1b3e9067-9f0d-4d4f-8141-1459acebae4aFor DB2 10 and DB2 11 for z/OS customers who use VSAM log stripingGZJ1100006WMTactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-02-28T07:29:13-05:002014-02-28T07:29:13-05:00<p dir="ltr">
Customers who are using VSAM log striping for the DB2 active log datasets with DB2 10 for z/OS or DB2 11 for z/OS should pay attention to recently opened APAR <strong>PI10353</strong>, which is now marked HIPER. There is no exposure for DB2 for z/OS customers running DB2 V9.1 or earlier. Neither is there any cause for alarm, as the exposure for DB2 10 or 11 is very small. There is no data loss involved and no loss of data integrity.<br />
<br />
<strong>So what is the underlying problem?<em> </em></strong>This concerns a concept called dependent writes, which means that, in the event of a DB2 restart after a crash, or when restarting DB2 from a DASD mirror or restored FlashCopy image, I/Os must be applied in the order in which they were initiated, and not in the order in which they completed. Unfortunately, VSAM striping does not guarantee the correct ordering of dependent writes for in-flight I/Os. This could mean, in some rare scenarios, a missing log CI stripe. <em>Just to be clear: VSAM striping has always worked this way.</em><br />
<br />
<strong>Why are DB2 10&nbsp; for z/OS and DB2 11 for z/OS exposed, and not earlier releases?</strong> Forced log writes (for example, those scheduled as a result of an application commit) can mean that a partially full log CI is written to disk. That log CI has to be rewritten in place when the next log write I/O is scheduled. Prior to DB2 10 for z/OS, DB2 would perform the rewrite of the log CI to log copy 1 and then to log copy 2 serially - ensuring that the write to log copy 1 is complete before initiating the write to log copy 2. With DB2 9 for z/OS and earlier releases, DB2 restart automatically detected the hole in the log, truncated the log at that point and continued the restart process. However, a performance enhancement delivered with DB2 10 for z/OS caused DB2 to rewrite log CIs (those which had been partially full when previously written) to both log copy 1 and log copy 2 in parallel.&nbsp; Unfortunately, the existing logic in DB2 10 for z/OS and DB2 11 for z/OS cannot deal with the new situation, that is, a missing log CI stripe.<br />
<br />
A possible consequence of this is that one or both copies of the current DB2 active log pair could be damaged at the end, causing a DB2 crash restart to fail and leading to advanced non-standard recovery, which has to be done under guidance of the IBM DB2 service team.&nbsp; This could theoretically happen in the following circumstances:</p>
<ul dir="ltr">
<li>
A local site crash, such as a CEC or LPAR failure, or an address space failure</li>
<li>
A DB2 restart off an XRC mirror or PPRC mirror</li>
<li>
A DB2 restart off a restored system level FlashCopy</li>
</ul>
<p dir="ltr">
<br />
<em><strong>No customer has ever hit the problem following a local site failure in over 3 years of DB2 10 for z/OS production experience</strong></em>. Only one customer has ever hit the problem, and only when performing disaster recovery restart testing from an XRC mirror. This happened on two occasions. The chance of hitting the problem during DB2 crash restart following a local site failure is tiny. The chance of hitting the problem when restarting from a DASD mirror or from a restored system level FlashCopy is marginally greater, because the timing window for this sort of event (a missing log CI stripe) is larger. APAR PI10353 will provide a fix (circumvention) such that DB2 will automatically detect this type of problem, repair the log and allow DB2 crash restart to proceed.<br />
<br />
For further guidance, please see the problem relief as described in the APAR, but be cautious if you are considering the option of disabling VSAM striping, which is difficult to implement, and may well result in serious performance problems.<br />
&nbsp;</p>
Customers who are using VSAM log striping for the DB2 active log datasets with DB2 10 for z/OS or DB2 11 for z/OS should pay attention to recently opened APAR PI10353 , which is now marked HIPER. There is no exposure for DB2 for z/OS customers running DB2 V9.1...002102urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00urn:lsid:ibm.com:blogs:entry-a216dee3-8b4f-4340-b446-14dee48460dfIBM Knowledge Center: Tips and TricksKateWheat060000T8JCactivefalseKateWheat060000T8JCactivefalse22586cb0-8817-4d2c-ae74-0ddcc2a409bcComment Entriesapplication/atom+xml;type=entryLikestrue2014-02-24T13:11:52-05:002014-02-24T14:20:28-05:00<p dir="ltr">
<strong>Access to IBM information centers will soon be redirected to IBM Knowledge Center, so take time now to explore your favorite IBM information in its new home at <a href="http://ibm.biz/IBMKCgo" target="_blank">ibm.biz/IBMKCgo</a></strong>.&nbsp; If you&#39;ve explored IBM Knowledge Center during its open beta, you have probably noticed some differences from the IBM information centers that you used in the past. With time and practice, using IBM Knowledge Center will become second nature. In the mean time, here are a few tips and techniques that you might be delighted to discover!&nbsp;&nbsp; &nbsp;</p>
<p dir="ltr">
<br />
<strong>How do collections work?</strong><br />
As you can tell, IBM Knowledge Center includes many topics about many IBM products. You probably use a few IBM products regularly and maybe some more products on occasion.&nbsp; By using My Collections, you can define just the topics that you want to use on a regular basis. You can put all of the information for one or more products and versions in a single collection, or you can include individual topics from still other product collections. And once you set up your collection with the information you want, you can add to it, move topics up or down, change the name of the collection, and create a PDF of the topics. &nbsp;</p>
<p dir="ltr">
<br />
<strong>Where did my search results go?</strong><br />
The left part of the IBM Knowledge Center interface shows three sections, shown below. They don&#39;t always stay in the same order though. Whichever section is on top is the one that matches the displayed content on the right. When you visit IBM Knowledge Center, the Table of Contents is usually on top.&nbsp; If you do a search, Search Results will be on top and you will see the results on the right. If you look at My Collections, that section will be on top.&nbsp; To move from one section to another, simply toggle among them.</p>
<p dir="ltr" style="margin-bottom:12.0pt;">
<a href="https://www.ibm.com/developerworks/community/blogs/22586cb0-8817-4d2c-ae74-0ddcc2a409bc/resource/BLOGS_UPLOADED_IMAGES/KC_TOC.gif" target="_blank"><img alt="image" src="https://www.ibm.com/developerworks/community/blogs/22586cb0-8817-4d2c-ae74-0ddcc2a409bc/resource/BLOGS_UPLOADED_IMAGES/KC_TOC.gif" style=" display:block; margin: 1em 1em 0pt 0pt; float: left;" /></a></p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
<strong>How do I narrow down my search to just the one or two products that I care about?</strong><br />
Fortunately, IBM Knowledge Center has powerful filtering capabilities. You define the products that you want to search in by typing the product name into the search field or by clicking <strong>Add Products</strong> in the top left of the IBM Knowledge Center interface, where you select the products that you want in your filter.</p>
<p dir="ltr" style="margin-bottom:12.0pt;">
<a href="https://www.ibm.com/developerworks/community/blogs/22586cb0-8817-4d2c-ae74-0ddcc2a409bc/resource/BLOGS_UPLOADED_IMAGES/KC_search.gif" target="_blank"><img alt="image" src="https://www.ibm.com/developerworks/community/blogs/22586cb0-8817-4d2c-ae74-0ddcc2a409bc/resource/BLOGS_UPLOADED_IMAGES/KC_search.gif" style=" display:block; margin: 1em 1em 0pt 0pt; float: left;" /></a></p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
After you set up the products for your filter, your search will be restricted to that set of content.</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
<strong>Why does my filter keep changing?</strong><br />
IBM Knowledge Center offers automatic filtering. When you open a topic (from the Table of Contents or Search Results), IBM Knowledge Center automatically creates a filter for the product collection of that topic, as shown below. In this case, we navigated to the topic about editing capabilities in DB2 QMF, and the filter was set up automatically so that any search will be restricted to QMF 11.</p>
<p dir="ltr">
<a href="https://www.ibm.com/developerworks/community/blogs/22586cb0-8817-4d2c-ae74-0ddcc2a409bc/resource/BLOGS_UPLOADED_IMAGES/KC_filterxmp.gif" target="_blank"><img alt="image" src="https://www.ibm.com/developerworks/community/blogs/22586cb0-8817-4d2c-ae74-0ddcc2a409bc/resource/BLOGS_UPLOADED_IMAGES/KC_filterxmp.gif" style=" width:400px; display:block; margin: 1em 1em 0pt 0pt; float: left;" /></a></p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
If you want, you can then expand the filter by clicking <strong>Add Products</strong> or by selecting additional filters for the date range, task, or operating system.</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
<strong>Can I turn off the automatic filtering?</strong><br />
Yes. If you don&#39;t want the automated search filter to be added to your product filter as you navigate, you can turn it off completely. On the Search Results page, click <strong>Search Options</strong> and uncheck <strong>Automatically select a product based on the current content</strong>.</p>
<p dir="ltr" style="margin-bottom:12.0pt;">
<a href="https://www.ibm.com/developerworks/community/blogs/22586cb0-8817-4d2c-ae74-0ddcc2a409bc/resource/BLOGS_UPLOADED_IMAGES/KC.SearchOptions.gif" target="_blank"><img alt="image" src="https://www.ibm.com/developerworks/community/blogs/22586cb0-8817-4d2c-ae74-0ddcc2a409bc/resource/BLOGS_UPLOADED_IMAGES/KC.SearchOptions.gif" style=" display:block; margin: 1em 1em 0pt 0pt; float: left;" /></a></p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
Once you do that, only the products that you select directly will appear as search filters, and navigating won&#39;t have any effect on your search results.</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
<strong>If I define a filter that I like, can I use it again, for future searches?</strong><br />
There are a few ways to do this. The easiest way is probably just to bookmark the IBM Knowledge Center address at the time you have your filter set up the way you want to use it in the future. You can also sign in to IBM Knowledge Center and use its <strong>Save Search</strong> option in the top right of the interface, as shown here:</p>
<p dir="ltr" style="margin-bottom:12.0pt;">
<a href="https://www.ibm.com/developerworks/community/blogs/22586cb0-8817-4d2c-ae74-0ddcc2a409bc/resource/BLOGS_UPLOADED_IMAGES/KC_saveSearch.gif" target="_blank"><img alt="image" src="https://www.ibm.com/developerworks/community/blogs/22586cb0-8817-4d2c-ae74-0ddcc2a409bc/resource/BLOGS_UPLOADED_IMAGES/KC_saveSearch.gif" style=" display:block; margin: 1em 1em 0pt 0pt; float: left;" /></a></p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
You can then use that same search filter when you sign in next time, even from a different computer or browser.</p>
<p dir="ltr">
&nbsp;</p>
<p dir="ltr">
<strong>What if I still get too many results, even after I define a good filter?</strong><br />
Sometimes the keywords that you are using as your search string are found in a large number of topics, so you end up with more results than you want to review. Three techniques are useful here.</p>
<ul dir="ltr">
<li style="margin-bottom:12.0pt;">
If your search term includes more than one word that you want to use together, place the entire search string in double quotation marks. IBM Knowledge Center will return only topics that have that exact string, rather than topics that contain one or more of the individual words in your search string.</li>
<li style="margin-bottom:12.0pt;">
Sometimes you get too many results simply because your search string is commonly used. In this situation, you can revise your search string to use the <strong>intitle</strong> operator, immediately before whatever word or phrase (in double quotation marks) you are most interested in.&nbsp; The intitle operator limits your search results to topics that have that word or phrase of your search string in the topic title itself. That way, you know that your search terms are of primary importance because they are mentioned in the topic title and not merely in the body of the topic.&nbsp; For example, if you really want to find troubleshooting topics about performance degradation, your search string might be: <span style="font-family:courier new;">performance degradation intitle:troubleshooting</span></li>
<li style="margin-bottom:12.0pt;">
Another situation that sometimes causes too many results is when many of the resulting topics contain information that you just don&#39;t care about. If you see in your initial results that most of the topics contain a term that makes the topic be not of interest, use the minus sign (-) before that term in your revised search term. The minus sign acts as an exclude operator. &nbsp;<br />
&nbsp;</li>
</ul>
<p dir="ltr">
<strong>If a minus sign means to exclude a search term, how do I search for something that starts with a minus sign?</strong><br />
One example of just this situation is information about SQL codes, which generally begin with a minus sign (such as -803). If you are debugging a problem for which an SQL code is issued, you need to<em> find</em> the information, not to <em>exclude</em> it.<br />
<br />
The easy ways around the behavior of the minus sign are to:</p>
<ul dir="ltr">
<li>
Put the minus sign and SQL code inside of double quotation marks so that IBM Knowledge Center looks for the exact phrase within the marks:&nbsp; &quot;-803&quot;</li>
<li>
Prepend the SQL code with a text string, with no space before the minus sign, which basically negates the exclusion behavior of the minus sign:&nbsp; SQLcode-803</li>
</ul>
<p dir="ltr">
If you don&#39;t realize or forget that the minus sign excludes a term, IBM Knowledge Center will generally help you by offering a &quot;Did you mean?&quot; question, as shown here, to remind you that you might need to use double quotation marks around the term.</p>
<p dir="ltr" style="margin-bottom:12.0pt;">
<a href="https://www.ibm.com/developerworks/community/blogs/22586cb0-8817-4d2c-ae74-0ddcc2a409bc/resource/BLOGS_UPLOADED_IMAGES/KC_DidYouMean.gif" target="_blank"><img alt="image" src="https://www.ibm.com/developerworks/community/blogs/22586cb0-8817-4d2c-ae74-0ddcc2a409bc/resource/BLOGS_UPLOADED_IMAGES/KC_DidYouMean.gif" style=" width:400px; display:block; margin: 1em 1em 0pt 0pt; float: left;" /></a></p>
<p dir="ltr" style="margin-bottom:12.0pt;">
&nbsp;</p>
<p dir="ltr" style="margin-bottom:12.0pt;">
&nbsp;</p>
<p dir="ltr" style="margin-bottom:12.0pt;">
&nbsp;</p>
<p dir="ltr" style="margin-bottom:12.0pt;">
&nbsp;</p>
<p dir="ltr" style="margin-bottom:12.0pt;">
&nbsp;</p>
<p dir="ltr" style="margin-bottom:12.0pt;">
We hope that these tips are useful to you as you become more familiar with IBM Knowledge Center. More tips are available in the Help topics on the welcome page and on the IBM Knowledge Center Technical Content blog at <a href="https://ibm.biz/IBMKCTCBlog">https://ibm.biz/IBMKCTCBlog</a>, which has additional information about how to get the most out of IBM Knowledge Center.</p>
<p dir="ltr">
<strong>Remember that access to IBM information centers will soon be redirected to IBM Knowledge Center, so take time now to explore your favorite IBM information in its new home at <a href="http://ibm.biz/IBMKCgo" target="_blank">ibm.biz/IBMKCgo</a>.</strong></p>
<p dir="ltr">
&nbsp;</p>
Access to IBM information centers will soon be redirected to IBM Knowledge Center, so take time now to explore your favorite IBM information in its new home at ibm.biz/IBMKCgo .&nbsp; If you&#39;ve explored IBM Knowledge Center during its open beta, you have...001820urn:lsid:ibm.com:blogs:entries-ffc304b9-37a6-43bb-aae5-7cf913f7e912DB2 for z/OS Exchange Forum2017-03-03T15:13:11-05:00