Page 2 of 2
Posted: Tue Jun 20, 2006 8:13 am
by ArndW
the RESIZE * * * will show any data errors in the file, as you surmised. It also has the benefit in this case of making sure that he is the only person accessing the file (i.e. required to rebuild indices)
Posted: Tue Jun 20, 2006 7:44 pm
by kduke
chulett wrote:
Kumar - you
cannot post links from
your search results, they won't work for anyone else. See how it has a '&sid=' component? You need to link
directly to the topic you found.
Sure he can. The issue is he is logging into dsxchange.com and not
www.dsxchange.com therefore it forces you to login again. Maybe webmaster can fix this.
Posted: Tue Jun 20, 2006 7:46 pm
by kduke
kumar_s wrote:Arnd - May I know what is the intention of RESIZE DS_JOBS * * * Will it give out the integrity of the indecies. It seems it requires an Exclusive access to DS_JOBS, so I could not test it now.
Kumar
REINDEX requires exclusive access as well otherwise the indexes get deleted and not rebuilt.
Posted: Tue Jun 20, 2006 10:56 pm
by sb_akarmarkar
When i rename jobs by updating DS_JOBS... I got new name jobs in designer but i think when i complie jobs i got those problem..
any suggestion to rename jobs ..
Thanks,
Anupam
Posted: Wed Jun 21, 2006 12:45 am
by kumar_s
As discussed in other post which I tried to post, if you update the DS_JOBS without updating the relevent DS_JOBOBJECTS, you may likely to loose the intergrity between the two hashed files. That that too is done for sure on REINDEXing ALL the hased files.
Since you have reverted back and deleted that category ad messed more, try to delete the same category from DS_JOBOBJECTS as well.
And check the condition of the hashed file of DS_JOBS and DS_JOBOBJECTS with the suggestion given by Arnd, or use COUNT DS_JOBS, and COUNT DS_JOBOBJECTS. Make sure you dont have any issue with bad records.
Before all take a backup of existing one (if you dont have a healthy copy) both though Unix and though DS export.
If you have prompted witha any bad records, you many need to sacrifice some of the jobs, by trying on fixing it. You can use FIX.FILE DS_JOBS for it.
Posted: Wed Jun 21, 2006 12:54 am
by kumar_s
kduke wrote:kumar_s wrote:Arnd - May I know what is the intention of RESIZE DS_JOBS * * * Will it give out the integrity of the indecies. It seems it requires an Exclusive access to DS_JOBS, so I could not test it now.
Kumar
REINDEX requires exclusive access as well otherwise the indexes get deleted and not rebuilt.
Yes, even the lock wont be established (which occurs before indexing by DS) to the hashed file, if its accessed.
Posted: Wed Jun 21, 2006 5:59 am
by kduke
I would delete this project and start over with a backup.
Posted: Wed Jun 21, 2006 6:50 am
by chulett
One of the first things I said - hope you have a backup - for exactly that reason.
