DSXchange

Thanks a lot, it worked like a charm.

Hi,

I have fixed length files where data is something like

I want to capture records where values are blank as errors. I have tried trim function but its not working.

Any help in this matter is highly appreciated.

I cleared the &PH& folder and ran some jobs but I dont see any improvement.There is no delay in triggering the jobs from sequencer.Atleast as far as I can see in director. Yeah it started suddenly couple of days ago, the jobs which were taking 3 mins previously are now taking 15 mins.The pro...

Database speed is fine,all the tables are analyzed and stats are gathered on weekly basis.Network load is also same as usual.There are no error or log which suggests anything fishy.
The problem is with all the jobs.

All of sudden all the datajobs in our production environment has started running slow.
We have made no changes to any of the jobs in last 2 months.No virus scan is running on the server.Disks,memory,CPU usage all seems ok to us.
Any idea what could be the reaso behind is highly appreciated.

Cheers

Back ups are two week old and you are correct about running out of space.

So we need to restore the project back not the DataStage installation.

yeah we have the back up, any idea which folders we need to restore?

COUNT DS_JOBOBJECTS shows following message :
" Warning : Internal file corruption detected during file open!.
File must be repaired ,possible turncation.
hsize:2048
bsize:2048
fsize:73493504
Unable to open "DS_JOBOBJECTS" file.

Any help

Hi,

All the jobs in our development environment have started giving the error

"Cannot open file DS_JOBOBJECTS".

These jobs were working till yesterday and all of sudden all jobs started erroring out in same manner.

Any help in this matter is highly appreciated.

Thanks,

Hi,

Our datastage server runs on Unix.The guys who was taking care of admin part left the company few weeks back.
Can anyone please tell me how can we add new users to datasatge.

Thanks in advance.

We have DataDirect tool with us.We are not sure what commands we need to use for MS Access.

Hi,

I want to load data in to a ms access database from Orcale tables,I am not sure what all i need to make it happen.

The datastage and oracle are on unix box however the access is on windows.

Please help me on this with solutions,tutorials or any means.

Cheers

Hi, I am creating a hash file with 3 million records and its following error: "HASH_DW_GRID..HASH_DW_GRID_APIGG.loDW_GRID: DSD.UVOpen mkdbfile: cannot create file /vol02/home/dsadm/hash/DW_GRID_APIGG" This hash file job was running successfully till yesterday and no changes has been made i...

Hi All, The Scenario is like the one given below...... OCI----->Transformer----->SQFS ....................^ .....................| .....................| .................Hash File ((( Hash File pointing to the transformer)))) Definition Of Metadata -------------------------- OCI | Hash File | SQFS ...

Yes