Resize VOC
Moderators: chulett, rschirm, roy
Resize VOC
Hi,
I am curious about the size of VOC in one of our Project.
-rwxrwxr-x 1 projuser projtest 1024000 Apr 5 10:49 VOC
What are the steps needed to resize the voc, I think we cannot do it while logged into the particular project. How do I create a pointer from outside the project and resize VOC?
Any inputs are appreciated.
Thanks
I am curious about the size of VOC in one of our Project.
-rwxrwxr-x 1 projuser projtest 1024000 Apr 5 10:49 VOC
What are the steps needed to resize the voc, I think we cannot do it while logged into the particular project. How do I create a pointer from outside the project and resize VOC?
Any inputs are appreciated.
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Prove that VOC is too large. VOC is typically presized as type 3, modulo 23, separation 4, which is considered to be a reasonable default.
Are you storing any particularly large records in VOC and, if so, why?
Yes, you can set a remote pointer to VOC from a different account and resize while the target VOC is not in use but beware, if you get it wrong, you've probably lost your project. So always back it up first!
And what will be your new sizing parameters? How will you calculate them? VOC is notoriously hard to get right, which is why most people simply accept the default.
Are you storing any particularly large records in VOC and, if so, why?
Yes, you can set a remote pointer to VOC from a different account and resize while the target VOC is not in use but beware, if you get it wrong, you've probably lost your project. So always back it up first!
And what will be your new sizing parameters? How will you calculate them? VOC is notoriously hard to get right, which is why most people simply accept the default.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
VOC is absolutely vital to DataStage - lose VOC and you lose your project. There's no need to check - trust me on this.dr.murthy wrote:HI ,
could you please tell me what is VOC? how it is useful to datastage? and how to check?
i never heard about VOC earlier, could you please help me out.
VOC (from "vocabulary") contains every word and token that might be used at TCL level in a DataStage project, together with instructions to a command parser as to how to use those tokens and, in certain special cases (such as command words and routines) how to dispatch them.
As for the fact that you need help in never having heard of VOC, you may now consider yourself cured.
Or, as they say in the classics: "I'd love to help you out - which way did you come in?" (Groucho Marx)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Thanks for the reply Ray. Pls see responses below.
We can keep the default. What do you suggest? Also what is the limit VOC can go in terms of size, Is it 2GB? ( as it is a hashed file).
[/b]
ray.wurlod wrote: Are you storing any particularly large records in VOC and, if so, why?
Not sure, by the way how do I check if there is any large record stored in it?
Yes, you can set a remote pointer to VOC from a different account and resize while the target VOC is not in use but beware, if you get it wrong, you've probably lost your project. So always back it up first!
Sure, I will back it up - What are the commands to set a remote pointer?
And what will be your new sizing parameters? How will you calculate them? VOC is notoriously hard to get right, which is why most people simply accept the default.
We can keep the default. What do you suggest? Also what is the limit VOC can go in terms of size, Is it 2GB? ( as it is a hashed file).
[/b]
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Maximum size of VOC is 2GB unless resized to use 64-bit internal addressing. I've never seen a VOC get anywhere near this size. Yours, for example, is only 1MB.
I'm worried about your lack of knowledge. If you don't know the command to set a remote pointer (SETFILE or SET-FILE) then you're unlikely to know how correctly to resize the file. Leave it well alone.
To get the largest records do something like this query:
I'm worried about your lack of knowledge. If you don't know the command to set a remote pointer (SETFILE or SET-FILE) then you're unlikely to know how correctly to resize the file. Leave it well alone.
To get the largest records do something like this query:
Code: Select all
SELECT EVAL "LEN(@RECORD)" COL.HDG 'Size' FMT '6R' FROM VOC ORDER BY 1 DESC;
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
That would be the Terminal Command Language or the ">" prompt and environment from DataStage/UniVerse. This is what you see when you enter the dssh or execute commands from the Admin tool.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
This is much more likely to be caused by large log files and many jobs in the view than the VOC hashing.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm