Hi,
1. Can any one say the diff b/w static and dynamic hash file?
2. How to release the job lock?
Hash file
Moderators: chulett, rschirm, roy
-
rmeenakumari822
- Participant
- Posts: 30
- Joined: Sat Oct 25, 2008 9:09 pm
- Location: chennai
Hash file
priya
for 1..google!
for 2, go to director > tools/Jobs(Not sure, just see ) there should be Link of "Clean Up Resources" ( & for this, u should have enabled Job Administrator in Director in the Project properties in the Administrator.
When u click on the Clean Up Resources, a window would open. In the lower pane, just select " show all" , see the process ID for ur username, go to upper pane,"check show all" , select the same Process ID , click on "Logout".
Close the designer & director . Again logon.
for 2, go to director > tools/Jobs(Not sure, just see ) there should be Link of "Clean Up Resources" ( & for this, u should have enabled Job Administrator in Director in the Project properties in the Administrator.
When u click on the Clean Up Resources, a window would open. In the lower pane, just select " show all" , see the process ID for ur username, go to upper pane,"check show all" , select the same Process ID , click on "Logout".
Close the designer & director . Again logon.
Rgds,
MB
MB
Hashed files work by converting the record key into a numeric value; this is the number of hash "buckets" that the file will have. When reading, once a key has hashed into a bucket the contents are searched sequentially to find the actual key and reference to the data. If a bucket is grossly overfilled then this search takes a long time and the file becomes slow.
Static hashed files pre-allocate this size when the file is created. Dynamic hashed files can optimize this number either upwards or downwards as a file grows or shrinks.
Static hashed files pre-allocate this size when the file is created. Dynamic hashed files can optimize this number either upwards or downwards as a file grows or shrinks.
</a>