US/Canadian Site 

Rocket Business Connect

Alert: Index using PICK style correlative containing a translate may result in file corruption

At UniVerse Release 11.1.0, creating an Index on a UniVerse file based on a PICK style dictionary item containing a correlative may result in file corruption. If the correlative performs a translate to another UniVerse file, corruption may occur in the primary file when records are written. Another symptom which may occur is that records may be written to the incorrect group and then be unable to be read.

Note, an index based on a PICK style correlative would appear as a Type "C' index when using the LIST.INDEX command. An example of the type of index which could result in this problem is shown below.

Index name      Type  Build      Nulls  In DICT  S/M  Just Unique Field num/I-type

AK                      C     Not Reqd  No     Yes        M      L      N      0 F;1;2;:;(TTESTX;;1)

This issue only exists in the 11.1.0 release available on IBM AIX and HP Itanium. In releases 11.1.1 and above, this issue has been fixed. An 11.1.2 release for the IBM AIX and HP Itanium platforms has been scheduled for availability on February 28th, 2011.

If you are running UniVerse 11.1.0 and have any indexes with these characteristics, the recommendation is to delete these indexes from the file until the 11.1.2 release is available.