DSXchange

Hi, We would like to know, when DataStage Server is being installed, would we need to specify the "amount of memory value" that DataStage Server can use for processing a Job. Lets say if the server box has 8 GB of memory, would DataStage make use of all avaialble memory while processing a ...

byk, I have a couple of questions based on your reply. What do you mean by saying as "swap space". Would we need to specify any amount of memory that can be consumed by DataStage, during the installation process of the Server. What do you mean by saying "ensure independence of the ins...

Hi, We are planning to build a new application using DataStage for transforming the data based on the business need. A part of the application is already available in Mainframes on COBOL programs. As investment in DS is a big decision, our boss puts questions like what are the advantages of designin...

Hmm.. This seems to be a good idea. To start each of the instance in a time gap of 10 to 30 seconds.

How can I make it to sleep for every 30 seconds before the next instance's start. Is there a routine to make the Job Sequenc to sleep?

Is the DS.TOOLS menu available on the Windows Server as well?

Hi,

Does DataStage have the capability to read a compressed file?

If I received a file that is compressed from another application or a Mainframe system, can DataStage read that file?

Thanks.

Ok, the first time when I run, I can pass the value for the Job Parameter 'RecordsToSkip' to be '0'. But when there is a failure, how will the required value be passed to this parameter. Thats what do u mean by saying "automate"? But this needs manual effort to pass the required value. By ...

Hi, We have a Job that reads a huge number of records from a flat file and loads it into a table. I know that restartability option is only available in Job Sequence using the Checkpoint option. Is there a method to make the individual Job re-startable? That is, if the Job gets failed at a certain p...

Hi, I had posted here before on processing a huge source file containing 40 million records. This takes a very long time for processing. Now we would likely be getting the source file broken down into 20 different files of approximate equal size. I would like to know if we can use the "Multiple...

Hi, We have our DS Server on Windows and have a requirement to process a huge number of records, around 40 million. The source is from a flat file. We have a requirement in the middle to aggregate the data. Obviously DataStage cannot have that number of records in memory. It going to abort. When I s...

Thanks for all your inputs.

Craig, yes, we do have UNIX servers for certain other applications.

Hi, We are currently working on 7.1 version and the DS Server is on Windows. We are planning to move the DS Server to an UNIX box and we are exploring on advantages that it could provide. We need some explanation and good reasons to put forward our request to the infrastructure team. Please share yo...

Thanks a lot Ken and us1aslam1us.

I would re-write my logic, the way Stage Variables work.

Thank you.

Hi, We are working on verion 7.1. I have a question like - Is it not possible to set a value for a Stage Variable in another Stage Variable ? Ok, here is my scenario. I have 2 Stage Variables. One has an 'If' condition in it and another has a 'counter' expression in it. So, I would need to increment...

Hi, We are currently working on the 7.1 version and planning to use Oracle OCI 9i stage for the database connectivity. We would like to know would DS Oracle stage be able to connect to a Oracle 10g database server which is a 64 bit (OR) should we only have the 32 bit version of Oracle 10g database.....