Mark This is one I have seen often - usually because the file or it's index was open by a process at the time of creation or build.
Resolution: 1. get everyone off - including PHANTOMs 2. LOGIN cleanly without running any LOGIN that might open files to COMMON etc. 3. DELETE.INDEX xxxxxx ALL 4. CREATE.INDEX / BUILD.INDEX / etc All should then be OK. Useful utilities: Unix: fuser -u <<Unix filename>> Windows: handle (available from those wonderful people at http://www.sysinternals.com If MFILES is low compared to your working file set you may find that a file is LOGICALLY open but PHYSICALLY closed as it is in the rotating file pool. If so then these utilities may mis-report that you are "safe". That's why "EVERYBODY OUT" (to quote Miriam Carlin) is the best idea. Regards JayJay -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Waldron Sent: 28 December 2005 21:12 To: [email protected] Subject: [U2] Alternate Indexes We just converted from DG/UX to Win/2003 UV 10.1.11 over the Christmas extended weekend. Everything went pretty well considering. My problem is my Alternate indexes will not stay Enabled. We Enable and Rebuild the indexes but for some reason they won't stay. We do a LIST.INDEX and it shows :LIST.INDEX DELIN ALL Alternate Key Index Summary for file DELIN File........... DELIN Indices........ 2 (0 A-type, 0 C-type, 2 D-type, 0 I-type, 0 SQL, 0 S-type) Index Updates.. Disabled, Indices require updating Index name Type Build Nulls In DICT S/M Just Unique Field num/I-type TAXNO D Not Reqd Yes Yes S L N 6 LOAN.CO.NO D Not Reqd Yes Yes S R N 27 Any suggestions. Mark Waldron City of Salem, Va Email [EMAIL PROTECTED] --- [This E-mail scanned for viruses by Declude Virus] ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
