DSXchange

It might be worthwhile also posting this query at www.DataStageXChange.com where more MetaStagers hang out. I havent played with MetaStage 6 yet, so cant help. My current project is still on 5.2. ----- Original Message ----- From: Xiong Li Date: Tue, 04 Mar 2003 15:23:23 +1300 To: "datastage-users@o...

Hi, I just start using MetaStage6.0. While I was trying to request Publication request. It gave me a message: "User has no email ID", then notified me with following message: "Tools -> Options -> Directory Options -> Email Setup: must set SMTP Server." However, I find no Directory Options under "Too...

This is a topic for an orphaned message.

I generate a hash file with following values : Part_nbr Item_seq_id 1 1 1 2 1 3 2 1 2 2 To populate correctly this file I need to put the 2 fields as key. However, the hash file is my reference table and the stream table have only the Part_nbr field. And I need to insert the item_seq_id values in th...

The invalid property value is nothing to do with multiple links. One of the properties in your OCI stage is not correct. Open the OCI stage and make sure that all the properties seem correct. Maybe even change a few to make sure Designer regenerates the properties back to the server. Second thing I ...

hi everyone, We recently upgraded from DataStage 4.2 to DataStage 5.1 and we are experiencing problems with OCI stages having multiple input links. We receive the message "Invalid property value" when we run the job. It seems to be a DataStage message. We tried many fixes and we still cant make the ...

Youre passing a variable to a routine that doesnt have the proper data type. This is coming from DSExecute, so you should check your syntax. I suggest you always form your system command into a variable first, like in the following: Unixcmd="sort -u ":WorkDirectory:"/XYZ.txt > ":WorkDirectory:"/XYZ_...

Hi All, Could anyone please explain why this is happening and a possible solution. The job is aborting with following message. Program "DSExecute": Line 82, Improper data type. Attempting to Cleanup after ABORT raised in stage ProcControlJob.t_1 DataStage Phantom Aborting with @ABORT.CODE = 3 With t...

Ladha As a result of the Torrent acquisition (over a year ago now) Ascential obtained a very powerful and scaleable parallel sort stage - not to mention an incredibly powerful parallel processing framework. This framework was fully integrated into DataStage and released with our 6.0 release as the a...

Rahim Ladha wrote: > Hello; > Can anyone share their experience using DataStage Sort Plug-in. > The reason Im asking, because in testing we are using this sort plug-in for > 100,000 records(Max open file 15, rows in virtual memory 50000 and about > over 100 columns). and it takes about 1/2 hr. Is th...

I would concur with Ken on testing the same sort with the unix sort. We use Syncsort called from DataStage in environments where we have this available. If not, we use the unix sort utility. We found that because of our fixed record length size that it was more efficient from and I/O standpoint to s...

Could you describe the job design and DataStage release version? Since youre on HP, have you used glance or top to monitor the cpus and see the overall load on the system prior to and during your benchmark? Its critical when benchmarking anything to watch cpu utilization. If you cpus are not maxd by...

Hello; Can anyone share their experience using DataStage Sort Plug-in. The reason Im asking, because in testing we are using this sort plug-in for 100,000 records(Max open file 15, rows in virtual memory 50000 and about over 100 columns). and it takes about 1/2 hr. Is this normal? am I doing somethi...

Rui, You should also look at your Target table. The fact is, if you are inserting data into a table with a complex primary key and multiple constraints (Primary Key, Foreign Key, Unique Key, Not Null Constraints, etc.), then Oracle will NEVER allow you to load data with any reasonable speed. Run a q...

If you examine the code produced by sequencers, you will see that each job is attached using the rule "ignore errors in the controlled job" - that is, DSAttachJob takes DSJ.ERRNONE as its second argument. The trigger of a job activity can have several different conditions; do you make use of separat...