DSXchange

Hi Prasanna,

Thanks for your response.

We would like to avoid any manual process on getting the source to target mapping. That is the reason, we would like to use Universe repository to get the required mapping.

Appreciate it if could someone enlighten on this.

Regards
Elavenil.

Hi DS Gurus, I would like to get expert advice on this. The job design is as below. DS --> Transformer --> Teradata Load What i am trying to do is to list all target fields and assigned column mapping or derivation. I hope the above info can be extracted from Universe tables and could you enlighten ...

Thanks for your response on this. Sorry, it is not clear to me the point that you are trying to highlight here. user and password in dsjob syntax, is it Engine credentials or Service credentials? As far as i know there is only user id and password can be passed to dsjob command. How would 2 differen...

Thanks for your response on this.

Forgot to provide you an additional info on this. All three tiers are running on the same server and do not think an issue in connecting to services tier using the same credentials.

Appreciate it if some light is thrown on this.

Regards
Elavenil

Hi DS Gurus, trying to use dsjob command to execute jobs from UNIX prompt. dsjob -user <uid> -password <pwd> -server <server Name>:<port no> -domain NONE -run <Project> <JobName>. When the above syntax is used, the job is gettting executed. But when any one of the below commands used, error occurred...

Thanks James for your quick response on this.

Point noted.

I will explore the question no.1 to conclude whether it is possible to do that.

I will share the info once it is tested.

Thanks for sharing URL for 9.1 migration.

Regards
Elavenil

Hi DataStage Gurus, We are in the process of upgrading DS 8.5 to DS 9.1. Our current architecture is single services & Metadata tier and multiple engine tiers (one per region). All engine tiers are referrring to single services tier configured in a separate LPAR. I would like to understand the b...

Hi DS Gurus, We are trying to create another instance of Services in the existing services tier for another set of countries deployment. What my concern is that this option adds dependency of those countries. During upgrade, i would like to understand whether 2 different versions of Services tier ca...

Hi Ramesh, Checked in 'C:\winnt\system32' of the client machines and both files exist in the directory. I think that this is not related to client as we are able to login to other projects and only this project is the issue. Checked in the server and do not see any core dumps. As recommended, ISAlit...

Hi Chullet, This issue occurs for everyone who logs into this project. Hi ArndW, There is no other SW installation on this server. Still trying to figure out the cause of this issue. Few developers created jobs on this project but no backup of them so recovery of those jobs are very critical. Regard...

Thanks everyone for your responses. Hi Ray, I am getting the same error when i login to Director client as well. Hi Ramesh, Tried enabling the trace by following IBM recommendation in the URL but it did not help. I could not make out anything based on the entries available in the trace files. Hi Chu...

Hi DS Gurus, While running a job, which produced lot of warnings and it issued 'Run-time error '9': Subscript out of range'. Logged into administrator and cleared log using CLEAR RT_LOGxxx. Encountered the same error 'Run-time error '9': Subscript out of range', while logging into designer but i am ...

I am able to partition the data using Generic stage. Partition type and key columns can be a paramters.

It worked fine and this would help reducing 2 hours in the batch time.

Thanks everyone for the help.

Regards
Elavenil

Thanks ArndW for your help.

It is working fine.

I will modify this code to write the job & transformer name into a file.

Once again, thanks a lot.

Regards
Elavenil

Thanks ArndW for your response. Tried calling DSLogInfo to see where it is failing. Once the both loops are completed for 1st job, ReadNext does not get the next job name in JobName variable. Tried using ReadList as well and ReadList loads all jobs in a list but ReadNext did not go to next job name....