DSXchange

We also upgraded from 7.5.2.. I hit mutex errors in 8.5 in job using a link partitioner/collector. First time I've seen it in an IPC. From the mass of documents I've read, it appears IPC are more trouble than they are worth. Unfortuneately my category has 195 jobs, each with two IPCs.. I'm not about...

I have probably 7 or so jobs running simaltaniously into the same database. The only ones which are causing a problem are the IPC jobs. Sorry,.. I'm starting to understan this a little more. I got our unix administrator to report out the process activity over the period. There was a massive cpu spik...

one quick question - would this error every be thrown if the connection to the source database dropped?

Just a general questions: 1) Are these jobs are running for a while without any issues? 2) Though there is no changes in the DS side any changes made in network / SQL Server / OS? Yes,... these jobs have been running in 8.5 since i upgraded in April. No previous issues until Fridays one job failure...

Hi sorry abut the title - i didn't want this dismissed with the usuall "timeout waiting for mutex" answer! I know about row/buffers etc... Anyway, heres the problem. On Friday, one job, a pull from a SQL server db, failed with ""timeout waiting for mutex". I reset/reran it f...

ArndW wrote:If so, it might be worth thinking about biting the bullet and re-installing DataStage from scratch.

I'm considering it, but wanted to check here first..

I'll create a new project and try that.

Server jobs - the error is specifically coming from a transformer stage.

Hi, I've created a new datastage 8.5 installation in our new development environment. All good, no issues with the installation. I've imported and compiled a project for use in dev. After running a quick smoke test job, I'm getting "Pin 1 not initialized". All other jobs I've tested have t...

Hi,

Is there a way to generate multiple reports from the reporting console?

Too lazy to create tham one by one!

Thanks
Paul

I'm trying to get my head round all this... Is there a nice blog somewhere that explains it?

I get the SVN plugin to Eclipse, but can't see how it all ties in with the Datastage jobs.

Ty, in advance.
Paul

Thanks guys.

As part of a recent project, we installed datastage 8.5 and used an oracle 11g database for the metadata tier. The DS installation and the database are on seperate servers. As part of another project, we putting in new infrasture for the database server. I'd like to do as minimal as possible to DS i...

The "DW" conversion code description is "Requests only the day number within the week (1 through 7, where Sunday is 7). If NLS locales are enabled, uses the DAYS field in the NLS.LC.TIME file, where Sunday is 1." It sounds like you fall into the latter part of the description. T...

Hi, We've got a new install of ds 8.5 - in a trigger I have the above code so some jobs run on a Thursday. However they ran last night,.. Wednesday. I though Monday was day one? So day four should be Thursday. Running "date" on the unix box with the installion shows the correct day. Schedu...

I fixed this with a user defined environment variable.... DS_NO_FF=1

Thanks for all the help I got from here!