<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"Formateret HTML Tegn";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.FormateretHTMLTegn
{mso-style-name:"Formateret HTML Tegn";
mso-style-priority:99;
mso-style-link:"Formateret HTML";
font-family:Consolas;
mso-fareast-language:DA;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:3.0cm 2.0cm 3.0cm 2.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DA" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">When upgrading from previous releases where Systemtables is on 2K-pages you can run a Sysmod<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">To move all Systemtables to 8K-pages (needed as well if you don’t want errors in Errlog.log
</span><span lang="EN-US" style="font-family:"Segoe UI Emoji",sans-serif;mso-fareast-language:EN-US">😊</span><span lang="EN-US" style="mso-fareast-language:EN-US">).<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">sysmod my_database -page_size=8192<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Best regards<br>
<br>
<b>Henrik Georg Sørensen<o:p></o:p></b></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Database Administration & Development<br>
<br>
</span><img width="45" height="11" style="width:.4687in;height:.1145in" id="_x0000_i1027" src="cid:image001.jpg@01D753A9.8069BA30" alt="kmd logo"><span lang="EN-US"> FAK Development Team DK<br>
<br>
Lautrupparken 42, DK-2750 Ballerup<br>
E-mail hgo@kmd.dk Web </span><a href="http://www.kmd.dk/"><span lang="EN-US">www.kmd.dk</span></a><span lang="EN-US"><br>
Direct +4544607626 Mobile +4541398500<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b>Fra:</b> info-ingres-bounces@lists.planetingres.org <info-ingres-bounces@lists.planetingres.org>
<b>På vegne af </b>Paul White<br>
<b>Sendt:</b> 28. maj 2021 03:52<br>
<b>Til:</b> Ingres and related product discussion forum <info-ingres@lists.planetingres.org><br>
<b>Emne:</b> Re: [Info-ingres] W_DM5066_ROW_SPANS_PAGE<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">The Ingres 11.2 documentation has been updated. The maximum row size has reduced further. <o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><img border="0" width="337" height="268" style="width:3.5104in;height:2.7916in" id="Billede_x0020_1" src="cid:image003.png@01D753A7.33D945C0"><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Check out Upgrade.pdf for recommendations about modifying tables to adjust page size.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Here is an SQL to search for tables with a row width near the boundary<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">select t.system_use, t.number_pages, t.num_rows, t.row_width,<br>
t.table_pagesize, t.table_name, t.table_owner, t.table_type, f.file_name,<br>
t.storage_structure, t.overflow_pages, t.create_date<br>
from iitables t<br>
join iifile_info f on t.table_name = f.table_name and t.table_owner = f.owner_name<br>
where<br>
(t.table_pagesize = 2048 and t.row_width >= 1928 ) or<br>
(t.table_pagesize = 4096 and t.row_width >= 3976 ) or<br>
(t.table_pagesize = 8192 and t.row_width >= 8072 ) or<br>
(t.table_pagesize = 16384 and t.row_width >= 16264 ) or<br>
(t.table_pagesize = 32768 and t.row_width >= 32648 ) or<br>
(t.table_pagesize = 65536 and t.row_width >= 65416 )<br>
order by system_use, t.table_owner, t.table_name<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Paul<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Mon, Mar 22, 2021 at 3:13 PM <<a href="mailto:shift7solutions@gmail.com">shift7solutions@gmail.com</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<pre>Hi all,<o:p></o:p></pre>
<pre>Can anyone say when the maximum row size per page has changed?<o:p></o:p></pre>
<pre>I have several btree tables with warning messages in verifydb like this:<o:p></o:p></pre>
<pre>verifydb -mreport -sdbname ctrust -otable newtable -n<o:p></o:p></pre>
<pre>W_DM5066_ROW_SPANS_PAGE Table row size 2004 spans page size 2048.<o:p></o:p></pre>
<pre>My normal approach is to increase the page size to 4K or 8K to suit MVCC requirements,<o:p></o:p></pre>
<pre>so I am seeking to understand why this particular table is being reported as a warning when the row<o:p></o:p></pre>
<pre>width is within the specified limits here:<o:p></o:p></pre>
<pre>V10.2<o:p></o:p></pre>
<pre><a href="https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.actian.com%2Fingres%2F10.2%2Findex.html%23page%2FDatabaseAdmin%2FMaximum_Row_Size_Per_Page_Size.htm&data=04%7C01%7CHGO%40kmd.dk%7C7ea6a925d3374f7ae7b608d9217b468a%7C1e2ad6d6274f43e889efd36d65bb83b5%7C1%7C0%7C637577635620657449%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=6tpuYjK773I9pML1Rlj09hYDGhOIjr4fFHZfMPtwYEE%3D&reserved=0" target="_blank">https://docs.actian.com/ingres/10.2/index.html#page/DatabaseAdmin/Maximum_Row_Size_Per_Page_Size.htm</a><o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>V11.x<o:p></o:p></pre>
<pre><a href="https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.actian.com%2Fingres%2F11.0%2Findex.html%23page%2FDatabaseAdmin%252FCalculate_Space_Requirements_When_Rows_Span_Page.htm%2523ww1027421&data=04%7C01%7CHGO%40kmd.dk%7C7ea6a925d3374f7ae7b608d9217b468a%7C1e2ad6d6274f43e889efd36d65bb83b5%7C1%7C0%7C637577635620667402%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=kAqwWoZwI3sDoajTOvD9j0hSCKUnE9i1%2FIG71aw6ErE%3D&reserved=0" target="_blank">https://docs.actian.com/ingres/11.0/index.html#page/DatabaseAdmin%2FCalculate_Space_Requirements_When_Rows_Span_Page.htm%23ww1027421</a><o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre><img border="0" width="755" height="496" style="width:7.8645in;height:5.1666in" id="Billede_x0020_2" src="cid:image006.png@01D753A9.8069BA30"><o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre><o:p> </o:p></pre>
<pre><o:p> </o:p></pre>
<pre>On further investigation, I found these to be the maximum row sizes per page before page spanning occurs.<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr style="height:12.75pt">
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal"><span style="font-family:"Courier New"">Page</span><o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-family:"Courier New"">Old</span><o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-family:"Courier New"">New</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:12.75pt">
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal"><span style="font-family:"Courier New"">2K</span><o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-family:"Courier New"">2008</span><o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-family:"Courier New"">1932</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:12.75pt">
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal"><span style="font-family:"Courier New"">4K</span><o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-family:"Courier New"">3988</span><o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-family:"Courier New"">3980</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:12.75pt">
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal"><span style="font-family:"Courier New"">8K</span><o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-family:"Courier New"">8084</span><o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-family:"Courier New"">8076</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:12.75pt">
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal"><span style="font-family:"Courier New"">16K</span><o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-family:"Courier New"">16276</span><o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-family:"Courier New"">16268</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:12.75pt">
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal"><span style="font-family:"Courier New"">32K</span><o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-family:"Courier New"">32660</span><o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-family:"Courier New"">32652</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:12.75pt">
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal"><span style="font-family:"Courier New"">64K</span><o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-family:"Courier New"">65428</span><o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt;height:12.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-family:"Courier New"">65420</span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<pre>Incidently, I found two Ingres catalog tables with 2K storage and row size > 1932: ii_encoded_forms and ii_encodings. I am pretty sure they are not used in any of the customer databases I'm investigating. It seems that upgradedb (V10/V11) has missed these. In newly created databases, these tables are 8K.<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Paul<o:p></o:p></pre>
<pre>&<o:p></o:p></pre>
</div>
</blockquote>
</div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">-- <o:p></o:p></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">Paul White<br>
</span>& Shift Seven Solutions<br>
Mob 0414 681 799<br>
Ph 07 5448 2137<o:p></o:p></p>
<div>
<p class="MsoNormal">Em <a href="mailto:paul.white@shift7solutions.com.au" target="_blank">paul.white@shift7solutions.com.au</a><o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">Web <a href="https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.shift7solutions.com.au%2F&data=04%7C01%7CHGO%40kmd.dk%7C7ea6a925d3374f7ae7b608d9217b468a%7C1e2ad6d6274f43e889efd36d65bb83b5%7C1%7C0%7C637577635620667402%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=sUnka4%2Bj6sNq%2FkR0GxaM8SxKOwusYCsll0rzW1DfBwk%3D&reserved=0" target="_blank"><span style="color:#1155CC">www.shift7solutions.com.au</span></a><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">Mail PO Box 418 Pomona 4568<o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<p style="font-family:Verdana;font-size:10pt;color:#000000;margin:15pt;" align="Left">
Internal - KMD A/S<br>
</p>
<p><span style="FONT-SIZE: 11pt; COLOR: #808080; FONT-FAMILY: 'Verdana','sans-serif'">Beskyttelse af dine personlige oplysninger er vigtig for os. Her finder du
<a href="http://www.kmd.dk/Privatlivspolitik">KMD’s Privatlivspolitik</a>, der fortæller, hvordan vi behandler oplysninger om dig.<br>
<br>
Protection of your personal data is important to us. Here you can read <a href="http://www.kmd.net/Privacy-Policy">
KMD’s Privacy Policy</a> outlining how we process your personal data. </p>
</span>
<p><span style="FONT-SIZE: 7pt; COLOR: #808080; FONT-FAMILY: 'Verdana','sans-serif'">Vi gør opmærksom på, at denne e-mail kan indeholde fortrolig information. Hvis du ved en fejltagelse modtager e-mailen, beder vi dig venligst informere afsender om fejlen ved
at bruge svarfunktionen. Samtidig beder vi dig slette e-mailen i dit system uden at videresende eller kopiere den. Selvom e-mailen og ethvert vedhæftet bilag efter vores overbevisning er fri for virus og andre fejl, som kan påvirke computeren eller it-systemet,
hvori den modtages og læses, åbnes den på modtagerens eget ansvar. Vi påtager os ikke noget ansvar for tab og skade, som er opstået i forbindelse med at modtage og bruge e-mailen.</span>
</p>
<p><span style="FONT-SIZE: 7pt; COLOR: #808080; FONT-FAMILY: 'Verdana','sans-serif'">Please note that this message may contain confidential information. If you have received this message by mistake, please inform the sender of the mistake by sending a reply,
then delete the message from your system without making, distributing or retaining any copies of it. Although we believe that the message and any attachments are free from viruses and other errors that might affect the computer or it-system where it is received
and read, the recipient opens the message at his or her own risk. We assume no responsibility for any loss or damage arising from the receipt or use of this message.</span></p>
</body>
</html>