RE: [U2] Alternate Indexes
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 xx 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: u2-users@listserver.u2ug.org 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 BuildNulls In DICT S/M Just Unique Field num/I-type TAXNODNot Reqd YesYes SL N6 LOAN.CO.NO DNot Reqd YesYes SR N27 Any suggestions. Mark Waldron City of Salem, Va Email [EMAIL PROTECTED] --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Alternate Indexes
You might have to do; SET.INDEX DELIN TO NULL FORCE CREATE.INDEX DELIN TAXNO CREATE.INDEX DELIN LOAN.CO.NO BUILD.INDEX DELIN ALL I keep a VOC record updated (REBUILD.INDEX.ALL.FILES) with all our alternate indexes and I use this to reindex the account whenever we move the account to a test machine. Fortunately, it doesn't take too long (10 minutes) for all of our files so it is practical for us. Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Waldron Sent: Wednesday, December 28, 2005 4:12 PM To: u2-users@listserver.u2ug.org 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 BuildNulls In DICT S/M Just Unique Field num/I-type TAXNODNot Reqd YesYes SL N6 LOAN.CO.NO DNot Reqd YesYes SR N27 Any suggestions. Mark Waldron City of Salem, Va Email [EMAIL PROTECTED] --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[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 BuildNulls In DICT S/M Just Unique Field num/I-type TAXNODNot Reqd YesYes SL N6 LOAN.CO.NO DNot Reqd YesYes SR N27 Any suggestions. Mark Waldron City of Salem, Va Email [EMAIL PROTECTED] --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Alternate Indexes
Did you create the indexes on the new system or did you copy them over from the other system? - Original Message - From: Mark Waldron [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, December 28, 2005 3:12 PM 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 BuildNulls In DICT S/M Just Unique Field num/I-type TAXNODNot Reqd YesYes SL N6 LOAN.CO.NO DNot Reqd YesYes SR N27 Any suggestions. Mark Waldron City of Salem, Va Email [EMAIL PROTECTED] --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Alternate Indexes
Maybe the Index Pointer is confused since the Account's path has changed; try using SET.INDEX DELIN TO NULL and re-create/build the indexes? Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Waldron Sent: Wednesday, December 28, 2005 2:12 PM To: u2-users@listserver.u2ug.org 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 BuildNulls In DICT S/M Just Unique Field num/I-type TAXNODNot Reqd YesYes SL N6 LOAN.CO.NO DNot Reqd YesYes SR N27 Any suggestions. Mark Waldron City of Salem, Va Email [EMAIL PROTECTED] --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Alternate Indexes
Copying from DG/UX to W2k Universe version 10.1.1 using uvbackup and then restoring under UniAdmin restore function. Files and programs doing great. My problem is I_ Files do not restore (for whatever reason) so my Alternate indexes are locked so that I can't do a Create.index on a file that had indexes on the DG. I get a message Unable to open index map e:\filename for read/write . It will work fine on a file that did not have previous indexes. I have a work around by creating an index on another file then renaming it to the file I need then adding the indexes to it. But thought there may be and explanation from the group that could tell me why and how to make it work correctly. Wasn't there a way to edit the position of the indexes or something of that nature? I can't remember. I have searched the Help to no help. Thanks ahead for the assistance. Mark Waldron City of Salem, Va Email [EMAIL PROTECTED] --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Alternate Indexes
Try SET.INDEX to update the file's header to point to where the I_ file is on the new W2K box. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Waldron Sent: Thursday, December 01, 2005 10:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] Alternate Indexes Copying from DG/UX to W2k Universe version 10.1.1 using uvbackup and then restoring under UniAdmin restore function. Files and programs doing great. My problem is I_ Files do not restore (for whatever reason) so my Alternate indexes are locked so that I can't do a Create.index on a file that had indexes on the DG. I get a message Unable to open index map e:\filename for read/write . It will work fine on a file that did not have previous indexes. I have a work around by creating an index on another file then renaming it to the file I need then adding the indexes to it. But thought there may be and explanation from the group that could tell me why and how to make it work correctly. Wasn't there a way to edit the position of the indexes or something of that nature? I can't remember. I have searched the Help to no help. Thanks ahead for the assistance. Mark Waldron City of Salem, Va Email [EMAIL PROTECTED] --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Alternate Indexes
What I do when transferring accounts/files from system to system is to SET.INDEX MY.FILE TO NULL FORCE This clears the file header and will allow you to create and build index from scratch. Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Waldron Sent: Thursday, December 01, 2005 11:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] Alternate Indexes Copying from DG/UX to W2k Universe version 10.1.1 using uvbackup and then restoring under UniAdmin restore function. Files and programs doing great. My problem is I_ Files do not restore (for whatever reason) so my Alternate indexes are locked so that I can't do a Create.index on a file that had indexes on the DG. I get a message Unable to open index map e:\filename for read/write . It will work fine on a file that did not have previous indexes. I have a work around by creating an index on another file then renaming it to the file I need then adding the indexes to it. But thought there may be and explanation from the group that could tell me why and how to make it work correctly. Wasn't there a way to edit the position of the indexes or something of that nature? I can't remember. I have searched the Help to no help. Thanks ahead for the assistance. Mark Waldron City of Salem, Va Email [EMAIL PROTECTED] --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Alternate Indexes
HELP SET.INDEX -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Waldron Sent: Thursday, December 01, 2005 8:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] Alternate Indexes Copying from DG/UX to W2k Universe version 10.1.1 using uvbackup and then restoring under UniAdmin restore function. Files and programs doing great. My problem is I_ Files do not restore (for whatever reason) so my Alternate indexes are locked so that I can't do a Create.index on a file that had indexes on the DG. I get a message Unable to open index map e:\filename for read/write . It will work fine on a file that did not have previous indexes. I have a work around by creating an index on another file then renaming it to the file I need then adding the indexes to it. But thought there may be and explanation from the group that could tell me why and how to make it work correctly. Wasn't there a way to edit the position of the indexes or something of that nature? I can't remember. I have searched the Help to no help. Thanks ahead for the assistance. Mark Waldron City of Salem, Va Email [EMAIL PROTECTED] --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/