DSXchange

Hi, if you hvae the DB2 client you have to catalog the server and the database in oder to be able to establish a connection: db2 catalog tcpip node xxx remote <servername> server <port> db2 catalog database <dbalias> at node xxx Once done that you can test ist via a connect command from the DB2 comm...

Hi Ray

ray.wurlod wrote:If you're running the job from a sequence, use "reset if required, then run".

well I tried to see if a job reset can release the table lock after the job was aborted but it did not work.
I think this would be the same from within a sequence, wouldn't it?

regards
globomike

Hi Ray

ray.wurlod wrote:Transaction size = 1.

well this is a good idea but this has a performance impact on every run.
Any additional ideas to kind of reset it via DataStage which I could do only when a error had happened (hopefully rarely)

Thanks
globomike

Hi,

I have a DS job upserting into a DB2 table. When the job aborts the table is locked by DS. Any idea how I could solve it WITHIN DS and WITHOUT having the dba forcing the connection?


Thanks in advance
globomike

Hi, Hello, I would like to know, how can I using datastage to insert value into XML type fields in DB2 on AIX? I don't see how to do it directly, but are there any workarounds? Thank you in advance. inserting works quite straight forward - even in DS 7.x - define the column as XML and set the data t...

Hi Ernie, Hard to say what the timing is on the opening of the queue, but the job will always abort anyway, if the database is not up and available when the job is initialized....... Ernie well this is true but because I have a shell script I can do a lot to ensure the job runs as expected and the s...

Hi, I have a DataStage 7.5.3. job reading from a MQ queue - transforming data and writing it to DB2. This job is triggered via a MQ Trigger. The problem is that if the database is not available (due to an error or maintenance etc.) the MQ Trigger fires every 2-3 seconds trying to (re-)start the job ...

Michael.... One key thing I don't think we talked about earlier was the frequency of calls.... how often is this service invoked? How many times per day, per hour, per minute, per second......? That will also help determine the necessity of doing this as a lookup technique vs a pure parameter based...

Hi, I am looking for the best architecture or job design for following problem: I have to create an RTI WebService to run a SQL statement against DB2. The service will get about 30 parameters which are potentially part of the WHERE condition - filtering the answer set. The problem is now that I can ...

Hi, I searched the forum but I could not find a satisfying answer to following problem: I run DataStage jobs with UtilityRunJob from a transformer but I run into problems if previous jobs (which where started via UtilityRunJob) aborted. How can I reset a job from my TRANSFORMER stage (not from a scr...

Hi, thanks KDUKE super input but I would like a little more details what is going on when you do i.e. INSERT INTO DICT DS_JOBOBJECTS ( FIELD, CODE, EXP, NAME, FORMAT, SM, ASSOC ) VALUES ( 'ParamNames', 'D', '14', 'ParamNames', '50L', 'M', 'MvParams' ) ; Sorry - this might be trivial to you but I cou...

Hi, we want to double check that all our environment variables are really set to $PROJDEF before we move the projekt from development to production. I am looking for a script / universe sql / job or any trick how I could list all the variable settings in a project (or export) to check the variables ...

Hi,

super, thanks Ray.
I suppose you refer to the APT_PM_SHOW_PIDS variable.

kind regards
MT

Hi, is there an option to set a variable (i.e. environment variable) within a job based on a certain logic to be used as a filename in an (output) FTP stage? I got some logic on which I would like to decide wether Environment variable var1 oder var2 should be used as filename of the output stage. Th...

Hi,

in addition to my posting I am interested in the memory consumpition on the datastage server as well

Thanks in advance

MT