DSXchange

Hi,
we have resized few hashed files from 32 bit to 64 bit.
Is there a command to check which hashed files are 32 bit and which ones are 64 bit?

Thanks

It worked.. with below modification in SQL

select * from table where col1 in (\'a\', \'b\', \'c\')

Thanks,

can you guide me how to 'escape' them?

Hi Ray, I did not search before posting it but i could find only one posting with the same error message. I tried to provide entire sql statement as a parameter by defining User defined SQL in ODBC section, i am still getting same error message. Here is sample of sql select * from table where col1 i...

Hi, I have a requirement to extract data from source tables - for that i am using ODBC EE start. requirement is to pass the where condition as a parameter . I am getting SQL0401N when i pass where condition using IN but when i hard code the same query using IN statement it works fine. Any workaround...

chulett wrote:Why do you think this needs to be resized? I'm curious what brought you here, asking that. Are you having... issues? :?

The Director would take a long time to refresh and show all the jobs after sometime.

Thanks for the reply Ray. Pls see responses below. 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 i...

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 i...

Hi,
I am trying download a patch from IBM Fix Central.

It is throwing the Error Message:

"Download Director failed to load or Java scripting is disabled. Try again?"

Has anyone seen this before?

Thanks [/img]

Hi,

Where are the packages stored after they are created from InfoServer Manager?......In the Xmeta repository?

Thanks

Yes the PA was coming as duplicate , I removed it. Thanks Andy. I was able to resize the hashed file. I do not see the OVER.30, DATA and Type30 files inside it, now RT_STATUS is no more a directory and is static now. What is the impact if we have all these dynamic Hashed files changed to Static Hash...

I am getting this message

>RESIZESTATUSFILES
Verb "PA" is not in your VOC

How can we add PA in VOC?

I tried this

>SET.FILE UV VOC UV.VOC
Q-pointer written to VOC file.
>COPY FROM UV.VOC TO VOC PA
Record "PA" not found in file "UV.VOC".

It does depend upon which file system the AIX administrators have created. Is it JFS2, JFS or another? In the past we've worked around this limitation by RESIZEing all RT_STATUSnnn files to static type 2 hashed files. Since Type 30 (Dynamic) files consist of a subdirectory with 2 visible and a hidd...

We have a single job where we have multiple stages to load datasets into Oracle 10. Individually each one of these pairs of stages will run, but when we get 50 in a single job we get this fatal error : main_program: APT_PMListenerPort: socket() call failed: Too many open files We can run a job with...

after adding iadb odbc entry in .odbc.ini files the issue is resolved.
Also there should be entry as iadb=iadb in .odbc.ini file.

Thanks,