DSXchange

Hi, I can think of 2 ideas: 1. contact your DBA or DB2 support and ask is there a way to avoid this situation. 2. ask for evaluation of ds 7.5 and test the message handlers capabilities (or are they avail from 7.1? - can't recall right now) not sure if this should work around it, but it's worth a tr...

Thanks for the replies , this top level sequence is the one populating the QA tables with info. Nice alternative Kim (crossed my mind after posting as well), since I'm in the same top level sequence I guess I'm fine scope wise, but I'll definitly test both options. as for the user defined variable s...

Regarding:

What's a DRS?

it is the Dynamic RDBMS stage.

Hi, enabling the allow administration from director check box in the DS Administrator while in the project's properties tab will enable the grayed options you see. besides that if you have DS admin user (mostly refered as dsadm) you could use via the administrator the command option to run the DS.TO...

Hi All, ( using Version 7.5 on solaris 2.8 ) I have a situation where I need to handle a dynamicly changing value thru-out the life cycle of a sequence job. My job reports progres to some QA tables, along the way it records business significant points and/or processing sections so I'll be able to ad...

Hi, in the EE manual page from page 895 (section 45-1) you can see the documented info + 2 examples. (It also explains the meta data you'll need) From what I undestood it forms a single row, in the target data set, containing a vector of all the rows with the same key column/s ( that you specify) fr...

Hi, In my experiance this implies 1 of the following: 1. your missing something like aleady said or similar things. 2. you encountered a bug. in eithere case contact your support provider for solutions while you also try to find them here. by the way in any case you cant avoid those warnings can you...

Hi, first thing to look for are columns defined in your DB with no precision, like a column defined as NUMBER instead of NUMBER(x) or NUMBER(x,y). if you find any columns like that except for date columns (date columns are ok to have) alter your table and state the appropriate length of the columns....

Hi, First as the message says check your configuration file (default is apt.default unless you specificly use another file) on of the first log messages in the director should show the file used and the configuration = disk spaces used. verify no file system stated there got to 100% full. if this wa...

Hi And Welcome aboard , How do you use the SP?, user defined sql holding a call to the SP? Or do you use the select using stored procedure method? I think it does have something to do with the reset, tough I don't have the exact info. Perhaps the people with moe inside info can explain it. by the wa...

Hi,
It was alread covered, do a search.

Hi, If I understood oyu correctly (hoping I did) add a new link to the transformer output load the full table definition to the new link then drag and drop the derivations of the columns you have to the proper columns. there is no magic add columns but preserve columns location, then again why shoul...

Hi, though it was covered before (please do a search before posting)... DataStage Job 143 Phantom 9332 Program "JOB.1066965472.DT.1359732475.TRANS4": Line 347, Improper data type. Attempting to Cleanup after ABORT raised in stage B021..Transformer_54 DataStage Phantom Aborting with @ABORT.CODE = 3 m...

Hi, The &PH& direcory contains files with run information of all job/stage runs. It should be cleared on a regular basis (preferebly when no jobs are running or via a script deleting only old files.) Hunged jobs are usually a rsult of a wait for something, like a table lock, resource lock an...

The concept is (in simple words):
A stage that becomes a process when you run the job is called an active stage, the ones that don't are called pasive.