As a follow up, here's an index that was corrupted earlier:
2 Dev (0)-> LIST-INDEX ARTMASTER
Alternate Key Index Details for File ARTMASTER Page 1
File.................. ARTMASTER
Alternate key length.. 45
Node/Block size....... 4K
OV blocks............. 1 (0 in use, 0 overflowed)
Indices............... 3 (0 D-type)
Index updates......... Enabled, No updates pending
Index-Name...... F-type K-type Built Empties Dups In-DICT S/M F-no/VF-expr....
INDEX_1 V Txt Yes Yes Yes Yes M SUBR( '-CATS', S
UBR( "T.LFM", NI
D, @FILE.NAME, @
RECORD ), REUSE(
OCONV( *OCONV(
@ID, 'G1*1' )*,
'MR%7' ) ) )
INDEX_2 V Txt Yes Yes Yes Yes M SUBR( '-CATS', S
UBR( "T.CLLFM",
NID, @FILE.NAME,
@RECORD, @ID ),
REUSE( OCONV( *
OCONV( @ID, 'G1*
1' )*, 'MR%7' )
) )
INDEX_3 V Txt Yes Yes Yes Yes M OCONV( *OCONV( @
ID, 'G*1' )*, 'M
R%4' ) : EXTRACT
( PHADD, 1, 1, 0
)
Thanks,
Bill
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:owner-u2-
>[EMAIL PROTECTED] On Behalf Of Bill Haskett
>Sent: Thursday, June 12, 2008 5:38 PM
>To: [email protected]
>Subject: [U2] UD: Indexes
>
>Has anyone had trouble with UniData indexes? We moved an application from
>D3 to UD and it's been reported that indexes are needing to be rebuilt on
>a recurring basis.
>
>We created a program that will delete the index then rebuild it for needed
>dictionary items. After this program is run everything works fine, until
>the next time.
>
>Any thoughts would be appreciated. Thanks,
>
>Bill Haskett
>Advantos Systems, Inc.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
