DSXchange

We're still on Version 6.0 here as well, and ran into that problem. Was that bug fixxed in version 7.0? Eric ---------- "Imagination is more important than knowledge. Knowledge is limited. Imagination circles the world." - Albert Einstein "Fuller, Christopher" To: "DataStage...

Hi Peter, long time no see. In your example, I would have thought that Oracle database performance, network performance to the database and disk performance for the hash file would have played a much bigger role. Unless you are doing anything to parallelise the processing, the 4 CPUs on the Sparc ar...

Hi All, this may be a 'how long is a piece of string question' but here goes. We have been doing our development on a win2000 machine with 1x2GHz processor and 1GB memory on DS 6.0. We have taken delivery of our shiny new Sun12K. The development domain has 4x1.2GHz sparc processors and 8GB memory wi...

Hi Eric, We were getting similar errors. It was happening during our dynamic pack backups/reorgs on our DB2 Disk packs where the DB2 tables live. To get around this we had to re-schedule our jobs around these Pack backups to avoid the problem. Basically DB2 cannot access the linear dataset that is r...

Hi Wim I would not suggest using the inter-process row buffering, as there is a known bug in the process (at least in V6 on windows) were the last buffer is not always correctly flushed. In your job design you need to 'land' your files prior to the link collector stage, ie use a 'passive' stage, lik...

I am trying to do some DB2 loads, and keep getting the following error: [IBM][CLI Driver][DB2] SQL0904N Unsuccessful execution caused by an unavailable resource. Reason code: "00D70014", type of resource: "00000200", and resource name: "VJDBPPLE.VJTSCLHS ". SQLSTATE=570...

Hi Wim, To use the link collector this way I suggest you try turning on inter-process row buffering for your job. This is on the Job Properties Performance tab. Regards - Chris Thornton -----Original Message----- From: Dommelen van W. (Wim) [mailto:Wim.van.Dommelen@NL.Fortis.com] Sent: 20 February 2...

Hi All, I've got a job like this: seq.file input -> goes to 2 different transformstages (using a constraint) -> one link goes through an aggregate and the other one goes directly to the link collector, the aggregate output goes here also. I also tried it using two sequential file inputs but this res...

Please do not post to the list in base 64 encoding. It is cause many bounces, including Ascential Software. If you don't know how to turn this off, please talk to your postmaster to do it before posting to the list again. Thank you. -- Regards, Clif Alex Martins wrote: > Misters, > does one know how...

TWlzdGVycywNCmRvZXMgb25lIGtub3cgaG93IHRvIGxpbWl0IHRoZSBudW1iZXIgb2Ygcm93cyBp biBQcm9ncmVzcy1TUUw/DQpTb21ldGhpbmcgbGlrZSAidG9wIDEwIiBpbiBNUy1TUUwgb3IgInJv d251bTwxMCIgaW4gT3JhY2xlLi4uDQpUaGsgdSwNCkFsZXgNCg== _______________________________________________ datastage-users mailing list datastage-users@...

Hi Daniel, What are you logging on to the DataStage Designer or Director as? What we found was if we chose Omit, then we don't get the needed authentication to work on files via a UNC path. So we do the following: 1. When we logon to a DataStage (Director, Designer, etc.) we always use a username of...

Depending on what is getting passed back to you by DataStage: DOS Error Code 13 (hex): Attempt to write on a write-protected disk DOS Error Code 13 (dec): Invalid Data Windows Error 13: Permission Denied UNIX Error 13: Permission Denied Don't know if this all helps. I'm assuming DataStage running un...

Sorry, don't know what status=13 means. But, you are accessing the file via a UNC path, so that leads me to several suggestions to try. If you "see" the file in Explorer, is that from your client machine or from the Server? Because, it's what the server can see, not your client, that count...

select * from table_a union all select * from table_b will give you all rows in table_a and table_b select * from table_a union select * from table_b will merge table_a and table_b and then do a distinct Daniel, can you please state what it is you are trying to accomplish, and give some indication a...

U29ycnkgRGFuaWVsLA0KSSBhbG1vc3QgZGlzYWdyZWUuIFVuaW9uIGNhbiByZW1vdmUgZHVwbGlj YXRlZCByb3dzIGluIHRoZSAyIHNldHM7IGp1c3QgVW5pb24gQWxsIGluY2x1ZGVzIHRoZW0uDQo6 KQ0KVGtzIGZvciB0aGUgdW5pb24gZXhhbXBsZSBpbmRpY2F0aW9uLg0KIA0KDQoJLS0tLS1NZW5z YWdlbSBvcmlnaW5hbC0tLS0tIA0KCURlOiBTdXR0b24sIERhbmllbCBBIFttYWlsdG86Z...