DSXchange

Hi,


Has any one tried using a text file ( created using the Sequential File Stage ) by configuring an ODBC for text files ??
My idea is to be able to treat the file with some SQL queries...

It will be once, before executing the main sql body. Could you please answer in these terms .. "will be issued Before every input row processed or only before the stage starts running i.e once per run of the job ?? "... else please explain what is meant by "the main sqql body"...

Hi, My job is designed to delete from target Db2 UDB tables... I issuing DELETE command thru it... I want to try using Beofre SQL to issue a LOCK statemnt.... So I want to confirm whether this Before SQL statement will be issued Before every input row processed or only before the stage starts runnin...

Also to highlight the complaint of the Win Admin... he says, that the processess are not using all available memory and causing high page faults... Why ??


Please advice.

ray.wurlod wrote:But, then, why should it grab more than it needs?

Yes, even I agree with this statement... but how to justify that there is no place in DataStage where I can configure a top limit if memeory usage...

The Win Admin wants to know where all in DataSatge, can the memeory usage be configured ??

Hi, The Hardware of the DataStage server has 12 GB RAM... but the windows administrator is complaining that the processes are not using more than 2 GB of RAM... He says that the processes are not utilizing the availiable memory ... Why ? What do I explain him now ? or What do I modify ? Please sugge...

Hi,

what are ways of merging 5 - 6 GB of text files, efficiently ?
Any special tools ?

Currently I am using windows TYPE command... but that is unable to scale up... Has also tried using Merge stage too.... but no luck..

Please advice.

... About all you could control from a Transaction Size standpoint would be if each set of records from any given 'key set' were committed per key change. That would take a value of 1. If I give Transaction Size as 1, then Array Size also comes down to 1, right ? i,e once set of keys goes to Databa...

I'm sure your vendor would be happy to take your inquiry. :D , Yes Ray, even I understand that.. but the thing is that now I must convey to the client that this is the best tuned way or best set parameters , for the deletes, from Ascential side and nothing else can be done on Ascential side. What s...

Hi All, The deletes performance is becoming a biq Question for me... I have set the Array Size and Transaction Size based on the packet_Size and Row_size..... I suppose as a result the time taken to delete the set of data is following a linear curve... But still the time taken is pretty high !!.. Fo...

Hi Rakesh, Just re-iterating what Ray and chulett have said, 1. replace the output with the Seq File and then use the LOAD for loading the target database tables. 2. put @FALSE constraint in the output, to determine the perfromance of fetching from the input. Analyse the above factors and then see t...

Let me try to explain again.

What I don't understand is that the Array Sie and Transaction Size must be determined , considering the rows in the Input to the stage OR the number of rows affected as a result of executing the SQL corresponding to each inout set of key ???

Hi Killer,

As far as I know and have tried, in server edition,
we cannot use the functionality of "load SQL from file".

Well, I dont think if u can find by what name u give to the target file, BUT, u can find by what name u give to the stage. For this, u must go to Manager, select the type of stage, eg. Hashed File, and then click on 'Usage Analysis'.. this give the list of all the jbos having that satge.. now u must...

Hi, I have requested the network team for the packet_size value.. Meanwhile, can u guide a lil on this: As my input, I have a set of key which uniquely identify a row in table 1 but, multiple rows in tables 2 & 3. Based on this input key set, deletes have to happen on all the 3 tables, where tab...