DSXchange

I just got confirmation from IBM/Ascential for the ecase 461128*UK regarding the DSJ.STAGECPU code in DSGetStageInfo() returning a %age CPU value instead of the actual number of CPU seconds used. They are going to "fix" the product documentation. Even though it sounds like they are avoiding fixing a...

To put it differently from Balaji, an urgent issue for yourself does not mean that it is urgent for others.

The error message is pretty clear, it say on line 2, column 1 it found something it couldn't parse - what does that line read in your xml?

Kumar, this sounds like a big problem. If your exports aren't working and you can't import then something is corrupt. You said that you rebooted the server and the lock error message persists. This would lead me to believe that the internal files have become corrupted and that DS thinks locks are he...

Congratulations Craig!

{drumroll}

Although the topic has been covered several times, the answer isn't that complicated. A DataStage "Routine" is actually a function in most programming languages, it takes 0 through 254 arguments and returns a single value value. A DataStage transform is effectively also a function in that the whole ...

The KeyMgt routines use a hashed file called SDKSequences with an record key of the sequence name you pass to store the key values. You can force a reset of this by deleting the record, the TCL command "DELETE SDKSequences {YourSeqName}" will do the trick. I took a quick look in the routines and was...

No, telnet and rsh are not part of the DataStage server functionality, so changing those programs won't impact DataStage at all.

No alternative at present, and I'm not aware of any changes forthcoming in PX to change the fact that you can't view the lookup set data. I did some tests a while back and was surprised to find that lookup sets didn't perform any faster than working with normal datasets. I am sure that there are cas...

You can click on the graphics text "continue trial" to read the full message. Your extract of the "ps -ef" doesn't mean anything in particular, it shows some DataStage processes running, but nothing that has been using CPU for a long time. Can you have your DBA check your connection to the database ...

If you get the dsjob executable for your Linux machine you can execute the program. It will build up a connection to the target server using IP, userid, password so it doesn't matter where the request originates.

The connectivity between the machines, the DB/2 configuration - i.e. partitioning, indices & constraints . I think the ODBC connection to Informix was actually faster than the direct access, but apart from that anomaly using the manufacturer's API is always going to be better.

It's a matter of having as much "bling" as others I figure that having a "charter member" next to my name might help me pick up pretty women or perhaps get an upgrade when I check in for a flight

ODBC is a very heavy interface and it is slower than native access most of the time. There is a very high likelihood of your DB/2 connectivity speeds going way up when going to the direct API that you'll see with teh DB/2 stage. Nobody can give you exact numbers since there are too many variables.

that is a cool logo! I wanna get me one like that too
So instead of heading to the computer store and buying a some silly-bang-em-up video game I'll splurge and go for the charter membership instead

First you need to logout your client connections (Director, Designer, Manager) then see if there are any processes left under "dsadm". If yes, you can issue a kill {pid} but DO NOT issue a kill -9 {pid}. I don't think your processes are still running, though. As has been stated before, the jobs have...