DSXchange

There have been high availability sessions at the last two conferences. It centres around the RTI pack which can automatically allocate jobs to available servers. If one server goes down or is fully loaded it allocates the job to another server. It does come at an extra cost, though I have no idea h...

MetaStage is not restricted to one DataStage server or repository, it is installed completely seperate to DataStage. You put a MetaStage listener on each DataStage server and use metabrokers to import from each DataStage project. You can then import all your DataStage projects into the one metadata ...

Tricky question, where do we start? Okay, you cannot open a tin of beans with DataStage. You cannot fly a kite with DataStage. You cannot compete in the Indianopolis 500 with DataStage. If I were to narrow the scope and focus on, say, data. You can convert complex transactions into relational data i...

As luck would have it this is the precise topic of my latest blog, The WebSphere II Hawk Metadata Server . Ascential and the IBM have spent several years of intense development on the successor to MetaStage. The Metadata Server is the most ambitious part of the Hawk release and will expand and grow ...

Have you defined it as a parallel routine? In the DataStage Manager do a right mouse click on the Routine folder and choose "Add Parallel Routine". Add the library path, routine name and descriptions in there.

Not too strong on C programming myself but you can have a look at the Advanced Parallel Job Developers Guide which has a short section on buildops and takes you through an example. There are also some example code in the PXHOME/samples folder on your server. You can also do a web search for CRC32 C ...

If you have the plugin then you should have a PDF that comes with it. You could also have a look at the IBM-Ascential literature library through www.ascential.com to see if there are any white papers on the plugin. You could also ring your local IBM-Ascential support to see if they have any papers o...

The default partitioning method is round robin.

For a normal job the XML report produces a single row count entry. For a parallel job it produces a row count for each PID leading to repeating entries. The XML structure is somewhat confusing but by reading the XML at a lower level and aggregating the same link name it ignores the duplicates and ag...

DB2 timestamp columns do not have a length, they are simply of type Timestamp. The DB2 plugin table importer should bring them into DataStage with a length of 26 and a scale of 6. Try increasing your length and scale in your DB2 stage for that field. Make sure you have a reject link off your DB2 sta...

When there is a stage upgrade IBM-Ascential usually provide an upgrade tool. When the Oracle pluging was upgrade from Oracle 8 support to Oracle 9 support they provided a routine that upgraded jobs. The current plugin you are using covers Oracle 9 and 10 and there have been no new releases of the pl...

Are those 15 jobs running concurrently or are they sequenced? You could try running just one job at a time, since this is a parallel architecture they should still run quickly. As Ray says you shouldn't be getting anywhere close to 100% usage on those disks. Expand them or find another disk somewher...

Which is why filesets are so good for archiving, they are relatively fast to write and if you collect them from each node you have a readable set of data.

Now that's what I call customer service! The friendly version of "talk to the hand". It probably took him longer to type that sentence then it would have to click on your link and read the exam number at the IBM site.

Try defining the output field as varchar, you might be putting it into a CHAR field.

NewEmpname varchar(255)=string_trim(Empname)

Now I remember why I never use the Modify stage.