DSXchange

Use a user defined update statement...how many CPU you have at your database side? Mainly in Oracle you can use parallel DML to fast up the process... something like- update /*+ parallel(c,4) */ (select /*+ parallel(a,4) parallel(b,4) */ a.column1, b.column1 from schema.table1a , schema.table b on a...

Our ETL load 70 tables in our warehouse. All the sources are text file (.TXT). A mainframe job ftps all the source file to the Data Stage server. What we want to achieve is when the LAST SOURCE FILE is COPIED successfully to the Data Stage server, we want to trigger the MASTER JOB in Data Stage. Ho...

Hi Friends... I have ended my job forcefully by doing the end process from the Task Manager.But now it's not opening and giving an error message like 'it is being accessed by another user'. Any help will be highly regarded... Thanx You can check from Unix if the job is accessed by doing a ps -ef|gr...

If you absolutely have to use the hashed files, then you can use a server job which is not advisable unless the job is small. The other way is to build a lookup file set just the way you built the hashed file. You can also load the contents of the hashed file into a sequential file in a server job ...

I already answered this question in its previous incarnation so Avishek will not want me to answer it again here (seems to want to keep asking until the desired answer is obtained). Sorry about that Ray..but wanted to get better response with a correct heading to address the problem As I understood...

As I already said, these files are maintained from the Permissions tab in the Adminstrator client. You can edit them manually if you prefer. I understand Ray- but that is for a particular project- I did that for each project-still it did not reflect in the .developer.adm ,and .prodmgr.adm files So ...

Hi I have posted this as a part of my previosu post but again posting this for better response I manually added new unix user groups in the .developer.adm ,and .prodmgr.adm files - then restarted the Datastage Server using uv -admin start and stop but the .developer.adm , .dsadmin, .prodmgr.adm file...

Hi Ray I restarted the Datastage Server using uv -admin start and stop but the .developer.adm , .dsadmin, .prodmgr.adm files are not picked up I changed my primary user group to a old user group and I can access the datastage. But still other developers cannot. Do we manully update .developer.adm , ...

Open your Administrator client and check on the Permissions tab for each project which DataStage roles are associated with each of the operating system group names that you mentioned. This information is what's stored in files like .developer.adm and .operator.adm. Without that information we are f...

I would assume yes. I make it a practice to do so, but can not recall reading anywhere that it is necessary. However, the authentication mechanism within dsrpcd has to pick them up from somewhere, and I believe it only reads these files when it is (re-)started. Thanks Ray..I would restart the serve...

Open your Administrator client and check on the Permissions tab for each project which DataStage roles are associated with each of the operating system group names that you mentioned. This information is what's stored in files like .developer.adm and .operator.adm. Without that information we are f...

Hi I am still unable to log on to Datastage......... do I need to restart the Datastage server after changing the User groups in Unix. What else I need to do... There are two files in /applications/Ascential/DataStage/DSEngine- .developer.adm and .dsadmin . In these files do I need to add the user g...

ray.wurlod wrote:Use the Permissions tab in Project Properties in Administrator to assign DataStage roles to your group.

Create the dsadm user identity for administering DataStage.

Which user group should "dsadm" lie- should it be in all user group where the Datastage users are present?

kumar_s wrote:Has "Enable job administration in Director" option been checked?
check the permission for DSParams files.

I have it enabled in Director. But I think it is a user group problem.

Again

even from "dsadmin" id when I tried to change the setting for one project- I got this error

What is the problem??