How to Clean Indexes in Universe
How to Clean Indexes in Universe
This is a topic for an orphaned message.
Below are some notes that I used for this type of process. It may or may not work for you. filepeek is a dangerous (if misused) command!
Platform: NT - Process verified
UNIX - Process not tested, but should be the same
principle.
Problem: You are unable to set a files index to null using the command
SET.INDEX filename TO NULL. One possible reason could be the path info in
the file header is no longer valid and cannot be restored. (ie: old path
is D: and new is F:)
Login as administrator (root)
Logto the account with the Index
If NT use pcANYWHERE and start a command prompt session (not tested via UV
DOS).
From the NT Command window, change directory to the account were the file
resides.
ie: C:> D: Changes to the D: drive (assuming D:)
D:> cd advdataACCOUNT
D:> d:advuvbinfilepeek.exe DEALS (assuming DEALS)
The following filepeek info will display pertaining to the DEALS file. filepeek status:
Active file .......... "DEALS"
Current file address . 0x00000000
Maximum file address . 0x0000CDFF
Window size .......... 512 bytes
0xFF will display as . " "
Default base ......... 16
File type ............ 18
Modulo ............... 101
Separation ........... 1
Group 0 .............. 0x00000400
Free head ............ 0x00000000
Addr: sw 100 [change window size]
Window set to 256 bytes (16 lines).
Addr: 180 [go to address 180]
00000180 : 412F3A44 442F5644 2F415441 53494843 : D:/ADV/DATA/ACCO 00000190 : 494E4150 5F492F43 4C414544 00000053 : UNT/I_DEALS.....
Addr: w 180=0 [write a zero on address 180, which
nulls out the path]
Are you sure (y/N) ? y [answer yes]
Change written to file.
Addr: q [quit]
You should now be able to run the following command to view the current
info on the index. SET.INDEX DEALS INFORM. This should now display File
DEALS has no secondary indices. You should now be able to set the proper
path to the data.
Good Luck
Paul Hruby
-----Original Message-----
From: Anthony Dzikiewicz [mailto:anthony@alperts.com]
Sent: Thursday, October 18, 2001 11:36 AM
To: u2-users@oliver.com
Subject: RE: How to Clean Indexes in Universe
That doesnt do it. I get an error. The problem is that the file has a reference in the header to the index on the other machine. There is no integrity. I remember there was a command or a parameter on a command maybe uvfixfile, resize, something that wiped clean the file of all index references.
> -----Original Message-----
> From: chris [mailto:craspe@mvtools.net]
> Sent: Thursday, October 18, 2001 2:14 PM
> To: u2-users@oliver.com
> Subject: Re: How to Clean Indexes in Universe
>
>
> I would think the cleanest way would be to delete the index
> DELETE.INDEX then CREATE.INDEX then BUILD.INDEX
>
> HTH
> Chris
>
> ----- Original Message -----
> From: "Anthony Dzikiewicz"
> To:
> Sent: Thursday, October 18, 2001 2:02 PM
> Subject: How to Clean Indexes in Universe
>
>
> I have a tape (cpio) with a data file on it. I brought to another
> machine and restored it. The other machine had an index built on that
> file. Well, I kinda made a mess. I know there is a command to fix
> up the indexes and
> have misplaced my notes. Looked thru the UV docs and still nothing.
> Looking for all the commands to administer file indexes in Universe. Can
> someone point me in the right direction ?
>
> Thanks
> Anthony Dzikiewicz
>
Platform: NT - Process verified
UNIX - Process not tested, but should be the same
principle.
Problem: You are unable to set a files index to null using the command
SET.INDEX filename TO NULL. One possible reason could be the path info in
the file header is no longer valid and cannot be restored. (ie: old path
is D: and new is F:)
Login as administrator (root)
Logto the account with the Index
If NT use pcANYWHERE and start a command prompt session (not tested via UV
DOS).
From the NT Command window, change directory to the account were the file
resides.
ie: C:> D: Changes to the D: drive (assuming D:)
D:> cd advdataACCOUNT
D:> d:advuvbinfilepeek.exe DEALS (assuming DEALS)
The following filepeek info will display pertaining to the DEALS file. filepeek status:
Active file .......... "DEALS"
Current file address . 0x00000000
Maximum file address . 0x0000CDFF
Window size .......... 512 bytes
0xFF will display as . " "
Default base ......... 16
File type ............ 18
Modulo ............... 101
Separation ........... 1
Group 0 .............. 0x00000400
Free head ............ 0x00000000
Addr: sw 100 [change window size]
Window set to 256 bytes (16 lines).
Addr: 180 [go to address 180]
00000180 : 412F3A44 442F5644 2F415441 53494843 : D:/ADV/DATA/ACCO 00000190 : 494E4150 5F492F43 4C414544 00000053 : UNT/I_DEALS.....
Addr: w 180=0 [write a zero on address 180, which
nulls out the path]
Are you sure (y/N) ? y [answer yes]
Change written to file.
Addr: q [quit]
You should now be able to run the following command to view the current
info on the index. SET.INDEX DEALS INFORM. This should now display File
DEALS has no secondary indices. You should now be able to set the proper
path to the data.
Good Luck
Paul Hruby
-----Original Message-----
From: Anthony Dzikiewicz [mailto:anthony@alperts.com]
Sent: Thursday, October 18, 2001 11:36 AM
To: u2-users@oliver.com
Subject: RE: How to Clean Indexes in Universe
That doesnt do it. I get an error. The problem is that the file has a reference in the header to the index on the other machine. There is no integrity. I remember there was a command or a parameter on a command maybe uvfixfile, resize, something that wiped clean the file of all index references.
> -----Original Message-----
> From: chris [mailto:craspe@mvtools.net]
> Sent: Thursday, October 18, 2001 2:14 PM
> To: u2-users@oliver.com
> Subject: Re: How to Clean Indexes in Universe
>
>
> I would think the cleanest way would be to delete the index
> DELETE.INDEX then CREATE.INDEX then BUILD.INDEX
>
> HTH
> Chris
>
> ----- Original Message -----
> From: "Anthony Dzikiewicz"
> To:
> Sent: Thursday, October 18, 2001 2:02 PM
> Subject: How to Clean Indexes in Universe
>
>
> I have a tape (cpio) with a data file on it. I brought to another
> machine and restored it. The other machine had an index built on that
> file. Well, I kinda made a mess. I know there is a command to fix
> up the indexes and
> have misplaced my notes. Looked thru the UV docs and still nothing.
> Looking for all the commands to administer file indexes in Universe. Can
> someone point me in the right direction ?
>
> Thanks
> Anthony Dzikiewicz
>
Be VERY WARY using filepeek. Layout of the file header changes from time to time. The offset you need (for release 9.4 and later) can be found in FILINFO.H file in the UNIVERSE.INCLUDE directory.
-----Original Message-----
From: Hruby, Paul [mailto:PHruby@ci.scottsdale.az.us]
Sent: Saturday, 20 October 2001 06:01
To: u2-users@oliver.com
Subject: RE: How to Clean Indexes in Universe
Below are some notes that I used for this type of process. It may or may not work for you. filepeek is a dangerous (if misused) command!
-----Original Message-----
From: Hruby, Paul [mailto:PHruby@ci.scottsdale.az.us]
Sent: Saturday, 20 October 2001 06:01
To: u2-users@oliver.com
Subject: RE: How to Clean Indexes in Universe
Below are some notes that I used for this type of process. It may or may not work for you. filepeek is a dangerous (if misused) command!