MSIR.0303 SORT/HASH key out of order: Difference between revisions
Jump to navigation
Jump to search
(Automatically generated page update) |
m (link repair) |
||
| Line 1: | Line 1: | ||
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. | This message is preceded by <code>MSIR.0304</code>, and it 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 | If you are using <var>[[Fast/Reload statements#The LAI statement|LAI]]</var>, the ordering can be done by the <var>HASH</var> or <var>SORT</var> option of the <var>[[Fast/Unload Extraction Language (FUEL)#UNLOAD ALL INFORMATION or UAI|UAI]]</var> statement in [[Fast/Unload]]. | ||
Otherwise, you should ensure that your input records are in the correct order, to obtain the full track I/O benefits of [ | 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 <code>TAPEI</code> data set 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 | If you can tolerate the slower speed of loading without full track I/O, use the <var>[[Fast/Reload_statements#ANYorder|OPTIONS ANYORDER]]</var> statement. | ||
[[Category:Sirius Mods messages]] [[Category:MSIR.0200 - MSIR.0399]] | [[Category:Sirius Mods messages]] [[Category:MSIR.0200 - MSIR.0399]] | ||
Revision as of 16:08, 19 February 2016
This message is preceded by MSIR.0304, and it 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.
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 data set 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 OPTIONS ANYORDER statement.