DSXchange

Thanks chulett

There are no index build on table and i am running Update job then insert job in sequence.

Hi I am trying to Update and insert a table in Snowflake via separate Jobs. Update is taking long time and not finishing in Monitor it says only 1 row is being processing all the time and it didn't go more than that. I am using ODBC Stage and updating the data using 3 key columns and 5 non key colum...

Thanks Ray for your response.

yes, Engine credentials were setup for every user(devproj) and same user(devproj) was the owner of the files and group is devprojects. dsadm is the member of devprojects group.

I can access the file as devproj user from unix command line.

Thanks

Hello I have excel file to be processed in datastage. I used Unstructured stage to read data from Excel file but I am getting error saying: file <xxx> doesn't exists. Specify a valid filename I know there is file in location I mentioned in Unstructured stage. I am running DataStage job as non-dsadm ...

We are experiencing an issue with IA where I am trying to import flat files metadata to IIS Repository. I have created DSN, I was able to test using DS_CONNECT Successfully. Created Import area in IMAM where it creates schema. But When I try identify flat files in IA, it throws an DSN Error as below...

Thanks asorrell

Can you please advise how to check swap usage? Is virtual memory /tmp?

Hi we are planning to use Data Quality Exception Console to monitor for Exceptions management. we are new to this, so tried creating simple job which will write records to Exceptions Stage, then saw the Exceptions Console but couldn't see any exceptions. I think i need to create events if i remember...

Hi

I searched in google to find usage of virtual memory and Swap in InfoSphere but couldn't find much information.

and also I want to know what is the rational behind allocation for these two(How much need to be allocated and on what basis)

Can someone give some details on it.

Thanks
Naga

It works

Can engine tier connect to services tier using ldap accounts even we stop ldap agent on engine tier. Also i dont see option to enter distinguished names while registering engine to sevices tier.

You might experience problem during the installation of engine tier as you need to register it with services tier and you need isadmin user id and password. I guess these are ldap accounts.

Hi When I create parameter set for Database credentials for each schema, which method is better Parameter Value Set file? or Environment Variables? What are the advantages of one on one? I used value set file in every project as it is flexible and don't need to login to DS Administrator to change th...

Thanks Mike for your response.

But i had check it again and could see all roles were checked against my user id.

As i mentioned earlier, we have LDAP authentication to login into DataStage and we have separate user id to login into DataStage Server. are there any other things to consider

Thanks

Any ideas?

Thanks to both I am still in doubt as far as i remember. I didnt assign rights to projects in DS Admin as we are assigning all roles to user earlier in different clientand worked fine. Also, DS user is not created on Server or not given any rightsto server. We have different users on server. As i me...