MSIR.0303 SORT/HASH key out of order: Difference between revisions

From m204wiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
Line 3: Line 3:
If you are using LAI, the ordering can be done by the HASH or SORT option of the UAI statement in <var>[[Fast/Unload]]</var>; see the <var class="book">Fast/Unload Reference Manual</var>.  
If you are using LAI, the ordering can be done by the HASH or SORT option of the UAI statement in <var>[[Fast/Unload]]</var>; see the <var class="book">Fast/Unload Reference Manual</var>.  


Otherwise, you should ensure that your input records are in the correct order, to obtain the full track I/O benefits of <var>[[Fast/Reload]]</var>. You must sort the TAPEI dataset in order by the [[Sorted_Files#Sort_key_characteristics|SORT key]], or by the '''hash code''' of the hash key. You can do this hash key sorting using the [[Hash_Key_Files#M204HASH_utility|M204HASH utility]].
Otherwise, you should ensure that your input records are in the correct order, to obtain the full track I/O benefits of <var>[[Fast/Reload]]</var>. You must sort the TAPEI dataset in order by the [[Sorted files#Sort_key_characteristics|SORT key]], or by the '''hash code''' of the hash key. You can do this hash key sorting using the [[Hash_Key_Files#M204HASH_utility|M204HASH utility]].


If you can tolerate the slower speed of loading without full track I/O, use the OPTION ANYORDER statement, as described in the <var class="book">Fast/Reload Reference Manual</var>.
If you can tolerate the slower speed of loading without full track I/O, use the OPTION ANYORDER statement, as described in the <var class="book">Fast/Reload Reference Manual</var>.


[[Category:Sirius Mods messages]]
[[Category:Sirius Mods messages]]

Revision as of 00:23, 12 December 2013

This message is preceded by MSIR.0304, and indicates that the switch was required because you were loading data to a hash or sort key file and a record was encountered out of hash or sort key order.

If you are using LAI, the ordering can be done by the HASH or SORT option of the UAI statement in Fast/Unload; see the Fast/Unload Reference Manual.

Otherwise, you should ensure that your input records are in the correct order, to obtain the full track I/O benefits of Fast/Reload. You must sort the TAPEI dataset in order by the SORT key, or by the hash code of the hash key. You can do this hash key sorting using the M204HASH utility.

If you can tolerate the slower speed of loading without full track I/O, use the OPTION ANYORDER statement, as described in the Fast/Reload Reference Manual.