DSXchange

Hi DataStage Gurus, We are in the process of migrating DataStage from AIX to RHEL Linux. What are things to be considered in the migration? Is there any performance degradation when DS is migrated from AIX to Linux? Is there any CPU benchmark between IBM AIX and RHEL Linux? Please share your experie...

Hi,

I have encountered similar issue.

Could you help sharing the file & location on which you had added client systems? Hope the same could help resolving the issue that occurred in our environment.

Regards
Elavenil

Hi ArndW, Thanks for your response. When job is getting executed in the target, it refers object code rather than source code in our case and it is due to no compiler installed in the target. That is the reason one of the questions that i asked the below question. When job is compiled in AIX and dep...

Hi DS Gurus, We are in the process of experimenting an automated solution to deploy code from one environment to another. And the below is what we are trying to achieve. Source env ---> RTC ---> Middle Env --> Target Env 1. Code is developed in Source env and compiled in the source env. 2. Only sour...

Hi DS Gurus, DS is installed in AIX and there are 3 projects on the same server. In addition to the existing projects, our req is to create an additional project but it failed while creating project. Error message was: DSR_QUICKADD.ErrorMsg: Unable to confirm the JVM can be loaded into the DataStage...

Thanks for your response on this. Technote provides details about dsjob command and i am using dsadmin command to create a project and the command is used as below. ./bin/dsadmin -domain <hostname>:<port> -user dsadm -password xxxxx -server <hostname>:<port no> -createproject devt -location <project...

Hi DS Gurus, We are in the process of creating projects using dsadmin command but dsadmin command failed with the following error. ERROR: -1010 Status code = -1010 DSJE_DOMAINLOGTOFAILED When dsadmin command is executed to list the projects available in the server and it is working fine. Listing env...

Thanks Ray for your help.

The provided query returns the result it was expected.

Note: I am trying to write the results into a file.

Regards
Elavenil

Thanks Ray for your quick response on this.

I will explore OLETYPE & other columns in DSOBJECTS and let you know.

Kindly let me know more detail when you get sometime to explore this on next week.

Regards
Elavenil

Thanks for all your responses. Hi Ernie, We explored BG option but it did not work out very well due to some internal constraints. Hi Ray, Simple source to target mapping in transformer is as mentioned below. Source columns: Emp Name (Varchar (30)) Emp Salary Decimal (18,3) Target Columns: Emp_Name ...

Hi Ray, Thanks for your details on DS_JOBOBJECTS. The query output is 36 record(s) selected to SELECT list #9 . I am curious to understand why SELECT COUNT(*) FROM DS_JOBOBJECTS returned no rows. How do i filter these rows for a single link for eg. an output link? That would greatly help achieving t...

I am using 8.7 version of DS. Yes, it is very strange that DS_JOBSOBJECTS is empty.

Appreciate your help on this.

Thanks & Regards
Elavenil

Hi Ray, Just executed LIST.DICT DS_JOBOBJECTS and i was able to get the metadata of this table. And executed "Select count(*) from DS_JOBOBJECTS" and it returned 0 rows. I would like to get output columns and its derivations / input columns for the output link of transformer. Is there any ...

Hi Ray, Created a simple job, which looks like mentioned below. Row Generator --> Copy --> Dataset. When DS_JOBS is queried, i can see this job but when i executed a query on DS_JOBOBJECTS, only 0 rows are returned. Can you enlighten why there is no record in DS_JOBOBJECTS though the job exists? In ...

Thanks Ray and Prasanna for your response.

Hi Ray,

I will explore the DS_JOBOBJECTS table to get source to target mapping from transformer stage and let you all know the outcome.

Regards
Elavenil