DSXchange

Hey All, We have multiple sequencers that run a server job and then a reusable job. In other words, each sequencer has a unique server job and then a reusable job. Now, our customer wants to run streams of these sequencers parallel. Problem, of course, is contention issues have popped up with the re...

Thanks for the info, I wasn't aware of the Key constraint in hashed files before. I've never seen issues with this in our runs, so I think it's a non-issue. I was just pointing out one example with 5mil/480mb, but we do have many files that will come near or exceed the 2gb mark. I wanted to make sur...

My take is the varchar 999 is not impacting the size (although it may have other issues, but I'm pretty sure no keys come near the 768 mark), correct? I don't think our limitation is an Oracle concern considering all DataStage Hashed files are 32bit when created.

Yes, these are peoplesoft delivered Hashed Files.

Hi All, We are working with a large data set and have concerns over Hashed File Sizes. I have done my research and understand it is not recommended to change the uvconfig file. So, I'm trying to gather some analysis on which files we will need to explicitely resize to 64bit. When doing some analysis...

Just wanted to follow up that we resolved this. It was a permissions problem. Thanks.

I didn't configure the environment, so I'm not sure if the faq was followed, but I'll reference this document to our helpdesk to troubleshoot the issue. Thanks

Hi again, I did do a search before posting and didn't find any results that discuss this error in relation to specific users not being able to access plugins. It appears to me that most solutions for this error revolve around incorrect library path or dsenv needing to be rerun. However, why would on...

Hi, We're getting the following error: "ds_loadlibrary: error in dlopen" when running jobs with certain plugins (rowmerger and pivot are 2 we know of). This error only occurs when we login to Ascential using our personal user names. When using dsadm, the jobs run fine. Is this simply a cas...

I did mention in my original post that they re-created the database instance...although maybe my terminology wasn't correct, sorry about that. We're on DB2 UDB 8.1. I used bind19 because I was following the Install and Upgrade guide while troubleshooting. In fact, I don't see a bind20 anywhere in th...

I was able to resolve this issue by running bind19 on unix server. I guess when they recreated the database instance that the odbc package needed to be rebound.

Hi All, We're having problems importing table definitions using odbc. I can see the Database in the DSN dropdown but when I attempt to filter, I get the message 'No Match Found'. I am sure we are filtering correctly but what I'm not sure about is the SELECT privileges. With the same username/passwor...

Hi All, This topic isn't really regarding an error, but best practice. Is there any magical number of lookups you can do in one transformer before you should use a second tranformer? Is there a performance difference between doing 20 lookups in one transformer and 10 lookups each in 2 transformers f...

On my current engagement, we had this same error and tried many of the suggested solutions. However, we finally discovered the reason for this was because we were running out of room in our tablespace. So, you may want to check with the dbas to make sure enough memory is being allocated if you haven...

Thanks for the input. The Date is part of the key so I'm guessing my best solution would be to use a drs stage directly for the lookup and compare the dates with user defined sql.