DSXchange

Good catch. Thank you. I checked the development project and "Enable Operational Repository logging" was checked. I just unchecked it. In production, this was disabled and there has not been any issue. While further space issues could be avoided in Dev, is there any tables in XMETA_DATA th...

I did an immediate purge for as many as 75 jobs and then queried the free space in XMETA_DATA tablespace. It has not claimed any space. That leaves an impression that the job logs are not stored in XMETA. How can I check whether the logs are stored in XMETA? I checked the Information Server Web Cons...

Hi Craig,

The database vendor is Oracle.

Hello all, We are seeing issues with XMETA_DATA tablespace in the Dev Data Stage server. Only 1% is free and even after DBA adding 800M to the tablespace, it is used up quickly. I removed lot of test jobs that team created, but when I query the available space it did not have any change. What are th...

Hi, I have been trying a scenario using Switch stage, though this is not ideal case. The source stage prior to switch brings in a record whose Selector column value is defined in Case with a corresponding output link. I have also set Discard value as the Selector column value set via Case above. In ...

Hello, For a Data Stage upgrade project, we have to convert a large number of Server jobs to be rewritten as Parallel job. Due to the time crunch for the project, we are even considering whether there are any tools in the market (with aproximate cost ) that can do the conversion. We will then be abl...

Interestingly it took 45 minutes when I FTP's the file from command line.
This indicates it is not an issue at Data Stage level and need to be fixed at FTP server level. Any thoughts?

I ran the job in both ways 1. Have the job FTP the file and write to peek stage. In this case the rows processed per second was 10148. 2. Have the job FTP file, pass to transformer stage where the columns are mapped through substrings function and write to a dataset. Here the rows processed per seco...

Hello, I am using FTP Plug-in stage to read a file from Mainframes server into the Data Stage server. The job has a FTP Plug-in stage and then in teh transformer stage, I am mapping each column using substrings function. There are 1.4 million records in the file and it takes 70 minutes to complete t...

The child sequence has a status "Stopped/restartable" and the job in the sequence has "Stopped" status. When I restart the master sequence job, it fails with error Controller problem - Error calling DSRunJob Code = -4 Timed out waiting for an event Please advise what should I che...

Thanks for the reply. All the job activities are set to have action as "Reset if required, then run"

Sorry if the post was vague. The question is why the rerun of the master sequence gets aborted indicating that there are stopped jobs in child sequence that it executed in the the previous run. I would expect that when the Execute Action is mentioned that reset if required, then run then all the sto...

I am seeing an issue with rerun of sequence job (with few new business logic implented) which got aborted forcefully by terminate sequence activity. This is how the job flows. A master sequence sequence job executes 4 jobs. Our of these, 2 jobs unconditionally trigger a sequence job. There are 2 oth...

Yes, I tried sending the mail to individual e-mail adderss as well. That did not work too! Anything different on an AIX server. This is first time I am working with DataStage hosted on an AIX server.

Thanks Craig and Ramesh for the responses. The mail is sent to a distribution list mail id. we are seeing the issue in all jobs that send mails out. Default mail server is specified in the notification activity.