<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<pre>I reckon it happens when there is a usermod or sysmod on a table with a long byte field right?</pre>
<pre>
Marty writes
</pre>
<pre>> <span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">The alteration to iirelation affects only the </span><span style="font-size:10.0pt;font-family:"Lucida Console"">rellow_logkey</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"> field. Anyone know what that refers to?
</span></pre>
<pre>Here is what I found looking up rellow_logkey and "end mini"</pre>
<p><a moz-do-not-send="true"
href="https://github.com/fosslc/Ingres/blob/master/src/dbutil/duf/duve/duvechk.sc">https://github.com/fosslc/Ingres/blob/master/src/dbutil/duf/duve/duvechk.sc</a></p>
<p><a moz-do-not-send="true"
href="https://communities.actian.com/s/article/Tracing-Use-of-Transaction-Log-File">https://communities.actian.com/s/article/Tracing-Use-of-Transaction-Log-File</a><br>
</p>
<p><a moz-do-not-send="true"
href="https://docs.actian.com/actianx/11.1/index.html#page/CommandRef/verifylob_Command--Analyze_Long_Data_Types.htm">https://docs.actian.com/actianx/11.1/index.html#page/CommandRef/verifylob_Command--Analyze_Long_Data_Types.htm</a></p>
<br>
<pre>verifylob Command--Analyze Long Data Types</pre>
<div id="ww99645" class="body" style="color: rgb(0, 0, 0);
direction: ltr; font-family: Arial, sans-serif; font-size: medium;
font-style: normal; font-variant: normal; font-weight: 400;
margin: 9pt 0pt 0pt; text-align: left; text-indent: 0px;
text-transform: none; vertical-align: baseline; letter-spacing:
normal; orphans: 2; white-space: normal; widows: 2; word-spacing:
0px; -webkit-text-stroke-width: 0px; text-decoration-thickness:
initial; text-decoration-style: initial; text-decoration-color:
initial;">
<pre>The verifylob utility analyzes errors in long data types (blobs and clobs). It scans the specified blob table and examines the blob coupons and etab tables for errors. Rows with errors are dumped with error indicators.</pre>
</div>
<div id="ww99646" class="body" style="color: rgb(0, 0, 0);
direction: ltr; font-family: Arial, sans-serif; font-size: medium;
font-style: normal; font-variant: normal; font-weight: 400;
margin: 9pt 0pt 0pt; text-align: left; text-indent: 0px;
text-transform: none; vertical-align: baseline; letter-spacing:
normal; orphans: 2; white-space: normal; widows: 2; word-spacing:
0px; -webkit-text-stroke-width: 0px; text-decoration-thickness:
initial; text-decoration-style: initial; text-decoration-color:
initial;">
<pre>Verifylob detects four types of errors:</pre>
</div>
<div id="ww99647" class="list_bul" style="color: rgb(0, 0, 0);
direction: ltr; font-family: Arial, sans-serif; font-size: medium;
font-style: normal; font-variant: normal; font-weight: 400;
margin: 6pt 0pt 0pt 18pt; text-align: left; text-indent: -18pt;
text-transform: none; vertical-align: baseline; letter-spacing:
normal; orphans: 2; white-space: normal; widows: 2; word-spacing:
0px; -webkit-text-stroke-width: 0px; text-decoration-thickness:
initial; text-decoration-style: initial; text-decoration-color:
initial;">
<pre><span class="WebWorks_Number" style="display: inline-block; margin: 0px; padding: 0px; text-indent: 0px; width: 18pt;"><span>•</span></span>(D) Duplicate keys</pre>
</div>
<div id="ww99648" class="list_bul" style="color: rgb(0, 0, 0);
direction: ltr; font-family: Arial, sans-serif; font-size: medium;
font-style: normal; font-variant: normal; font-weight: 400;
margin: 6pt 0pt 0pt 18pt; text-align: left; text-indent: -18pt;
text-transform: none; vertical-align: baseline; letter-spacing:
normal; orphans: 2; white-space: normal; widows: 2; word-spacing:
0px; -webkit-text-stroke-width: 0px; text-decoration-thickness:
initial; text-decoration-style: initial; text-decoration-color:
initial;">
<pre><span class="WebWorks_Number" style="display: inline-block; margin: 0px; padding: 0px; text-indent: 0px; width: 18pt;"><span>•</span></span>(L) Non matching lengths</pre>
</div>
<div id="ww99649" class="list_bul" style="color: rgb(0, 0, 0);
direction: ltr; font-family: Arial, sans-serif; font-size: medium;
font-style: normal; font-variant: normal; font-weight: 400;
margin: 6pt 0pt 0pt 18pt; text-align: left; text-indent: -18pt;
text-transform: none; vertical-align: baseline; letter-spacing:
normal; orphans: 2; white-space: normal; widows: 2; word-spacing:
0px; -webkit-text-stroke-width: 0px; text-decoration-thickness:
initial; text-decoration-style: initial; text-decoration-color:
initial;">
<pre><span class="WebWorks_Number" style="display: inline-block; margin: 0px; padding: 0px; text-indent: 0px; width: 18pt;"><span>•</span></span>(O) Orphaned rows</pre>
</div>
<div id="ww99650" class="list_bul" style="color: rgb(0, 0, 0);
direction: ltr; font-family: Arial, sans-serif; font-size: medium;
font-style: normal; font-variant: normal; font-weight: 400;
margin: 6pt 0pt 0pt 18pt; text-align: left; text-indent: -18pt;
text-transform: none; vertical-align: baseline; letter-spacing:
normal; orphans: 2; white-space: normal; widows: 2; word-spacing:
0px; -webkit-text-stroke-width: 0px; text-decoration-thickness:
initial; text-decoration-style: initial; text-decoration-color:
initial;">
<pre><span class="WebWorks_Number" style="display: inline-block; margin: 0px; padding: 0px; text-indent: 0px; width: 18pt;"><span>•</span></span>(R) Invalid iirelation rellow_logkey, rellow_logkey pair</pre>
</div>
<pre>
Next step, I plan to track the entries going to the transaction log to see if both BM (Begin Mini) and EM (End Mini) are being written.
My hunch is the BM is not being written to the journals because I am sure I reached the transaction limit error in the rollforwarddb.</pre>
<pre>Paul</pre>
</body>
</html>