DSXchange

Hi All, I am trying to update some columns in universe table based on one column.for that I selected "Update Existing Rows Only" update action.On Execution, its giving me the following error "[DataStage][SQL Client][UNIVERSE]DataStage/SQL: syntax error. Unexpected symbol. Token was &q...

Use SETFILE in a project to create a VOC pointer. Then issue the CREATE.INDEX command. You can remove the VOC pointer afterwards if you wish. ... Hi ray, thanks for pointing this out. I already had VOC pointers created for the hash files , however I was trying to create indexes on the physical hash...

Hi ray, Yes i did replace the syntax with actual file names and field names. I typed it this way just for everyone else who reads this topic to understand what I am trying to say :) But the point is that i still get the error. It may be noted that this hash file resides in unix file system, not in t...

Hi Chulette, I searched the forums and got the CREATE.INDEX command. I used the command int he following way - CREATE.INDEX <hash file path>/<hash file name> <field1 to be indexed> <field2 to be indexed> However, this command give me an error saying "<hash file path>/<hash file name>" is n...

Hash file is already supposed to be indexed on the key field. Please explain what do you mean by creating index on hash files???

Hi, I am using a combination of Varchar type key field and an integer type key field to be looked up through a hash file in a universe stage for date range lookup. The lookup file contains merely 50000 records, however the lookup operation on this file has become damn slow @ 3 rows/sec. It may be no...

Hi Deepak, I was facing a similar problem but jus found the reason and solution to it.. The reason is that your datastage application directory has reached 100% of its allotted space.. The solution is you need to first enable "auto purge" feature in Ds administartor for your project. Secon...

HI All,

One of the lof files has reached a size of 2GB.. I am unable to clear it by the clear job log option in director.. The operation hangs and gives some error..

Can anyone tell me how to clear this log file? Is it safe to delete its content from Unix???

Regards

loveojha2 wrote:

Ok.. can you tell me if it is usual for a project with approx 2000 jobs and sequences to occupy 11 GB of space????

We have around 10K maps in one project with around 1 GB of space.

So you mean to say that it is normal?

How many jobs are there in the project? If they are not hugh in numbers. My advise could be taking export of the entire project with the executable and creating a different project with that, then you can make a comparison actually, since you have said that you are auto purging the log and you are ...

loveojha2 wrote:

Do you mean to say that I can DELETE these files?

No
Otherwise you will lose your project

Then what are you exaclty suggesting...
I would appreciate if you be clear in your suggestions...

Check which files are relatively big in size and what is their type (log,RTBP,temp file)? Just classify the space utilized by the different types of file, that may lead to some clue. There are a lot of 'TEMP*', 'RT_LOG*' and 'RT_STATUS*' files in the project directory, But I feel these files are ge...

Are there any jobs running with large number of warnings, if yes, then try to modify the jobs in such a way that you don't get warnings at all. Hi Loveojha2, As long as the Auto purge feature is enabled in ds admin, it dsnt matter even if the job gives warnings.. I have already tried all that.. Any...

Hi Deepak, as i told earlier the files are written to a completely different directory meant for storing all kinds of data and hashed files.. So why should the datastage direcoty get filled up?

Hi Friends, I am facing this issue of Datastage server directory on UNIX "Ascential/Datastage" running out of space frequently. My system administrator keeps increasing the size of the directory but in a matter of 10 days the directory has grown from 8 GB to 11 GB in size!!! I am baffled b...