DSXchange

Could your SELECT statement DML be triggering this implicit creation? According to the Connectivity Guide to IBM DB2 Databases , you need Listed below are the required IBM DB2 privileges: SELECT privilege on any tables from which to read data. INSERT privilege on any existing tables to be updated. T...

Do you know what the patch addressed - that would be where I'd start looking.

I'll start at the end - in your case you mentioned that production support with RCP is more difficult than not using it. I have found that the production staff never use a designer client to look at DataStage jobs in order to determine what went wrong. I'm not equivocating and using the terms "...

I thought the same.. mayhaps they neglected to add the help option for unprotect but I don't feel like protected some poor project that I later can't unprotect anymore

See the last option... C:\Programme\IBM\InformationServer\Server\DSEngine\bin>dsadmin /? Invalid/unknown primary command switch. Command Syntax: dsadmin [-file <file> <domain> <server> | -domain <domain> -user <user> - password <password> -server <DataStage server>] <primary command> [<arguments>] V...

Your configuration file probably contains

If I look at your earlier post, I assume that if you write to a peek stage your job runs in 5-6 seconds regardless of whether you use 2 million or 5000 lookup reference records.

What are the number of output rows you LOAD to your database when using 2 million or 5000 reference records?

Making DataStage run correctly in a HA environment is not a simple issue. Quite a bit depends upon how the users defines High Availability. Being able to restart jobs that were running when the machine died (and failed-over) makes things easier. If that is not the case, i.e. job level is not granula...

All of the internal tables are undocumented. This is not done primarily out of secrecy, but because the manufacturer wishes to be able to change these without notice or backwards compatibility and that cannot be done with documented features or attributes. In addition, and to be fair, one can work a...

kfb_developer - Now that you know that the output cannot be easily converted to an integer you have your answer. In a roundabout way, you could now do a checksum or similar conversion on that string and get a bigint value. While server jobs have a CRC32() function, PX does not. One would need to wri...

The Solaris zones are, if I recall correctly, virtual machines on a single physical one. Thus, in order for DataStage to run on both you would need either 2 installations or a clustered/gridded installation of DataStage. (questions 1 and 2 are the same for me) Question 3 - DataStage does not restric...

It depends upon the database. In your case, it looks like the job processes were gone but the status wasn't updated accordingly - which is rather a rare occurrence.

Could the file be corrupt? From the command line or admin tool, try a "COUNT BIGFILE" to see if you get errors.

That means you have narrowed down the cause of your performance bottleneck to your write stage(s).

What method are you using to write? Are you loading, inserting or upserting? Does the target have indices/constraints or other factors which might contribute to a slowdown?

Those two function are found under "Type conversion"