DSXchange

Hi Paul, Thanks for the reply. Tomorrow we have a call with the Citrix team and I will definitely confirm on the install path. Can you please advise me on any other things to consider that could potentially cause this problem? So that I can discuss them in the call. I found something on IBM site tha...

Hello Forum, We are setting the DataStage client access on Citrix server. After creating ThinApp using VMware for IBM DataStage Designer Client v8.5, I am getting the below error. Internal Error: Failed to initialize the CDSRepos. InitStage=9 Extender error information: Automation error This error o...

Hi Sorrell, We have completed the uninstall and re-install on server B. Now we have two stand-alone installations and nothing is shared between them. They are active -active. Now the management is trying to get what is required for SAN based failover. That's a positive sign. Now the question is..whe...

Hi Sorrell, Thanks for the reply. We are now going in the same direction.. Strip-off B and re- install. I guess fixing the current mess is the hardest part than redoing. My question here is.. While removing IIS from B.. what precautionary steps should I consider in terms of IIS set up related depend...

Hi, I am not sure if I detailed the problem clearly. Current Set up ( let's not worry about failover for now) We have server A and server B with engine tier and services tier installed on both the servers. Metadata repository is clustered on oracle RAC (active-passive). Server A works fine and switc...

Hi Sorrell,

That's right. The client has the required licenses. Anyways it is a temporary setup for time being.

Thanks
Vinod

Hi Sorrell, Thanks for the response and making valid points. As I already mentioned earlier, the client has concerns on cost and lengthy approval process. My hands are tied now.. and the task in front of me to set up two stand alone (E-S) implementations (Active-Active) to work while the client gets...

Hi, Our current production environment has two stand alone installations of engine tier and services tier on each server (supposed to be Active-Passive) while repository tier is being shared from oracle RAC (active-passive) on different servers. No SAN / NAS is used and nothing is shared here. When ...

Hello All, I am using the ORAOCI9 stage for accessing the oracle database in the DS 7.5. In one of the jobs, I have the extraction query : SELECT TO_CHAR(sysdate, 'YYYY-MM-DD HH24:MI:SS') FROM dual . This is the auto generated query in the oracle stage when defined the column name as sysdate, data t...

Hello All, We have a task to obtain the start time, end time, current job sequence status details after the completion of every job sequence and store this information in a DB2 table. I have done this for job reports by using dsjob command or by executing DSGetJobInfo function. But I don't know how ...

Following list of columns when i do LIST.DICT DS_AUDIT KEY, DTC, CREATOR, PREVDTD, PREVDTD, PREVDELETOR, DTM, MODIFIER, REASON, CLASS, INSTANCE, MODS Among those, KEY, CLASS, INSTANCE fields can be considered to verfity to use them as join keys, rest of them are, Date fileds, Description fields, Cre...

Hello Friends,

May i know whether can we join DS_AUDIT with DS_JOBS or DS_JOBOBJECTS? If so, may i know what is the joining key.

I know that we can join DS_JOBS and DS_JOBOBJECTS with the following join condition. Appreciate any advise.

Hi Ray, The code you provided works perfect as is. But when i replace the 'SELECT' statement with the following one's in your code, it is throwing the errors: Code with double quote for EVAL: "SELECT DISTINCT EVAL "FIELD(CATEGORY,'\',1,1)" FROM DS_JOBS;" Error: test_script.sh: sy...

Ray,

I was talking about version 7.5.

Hello Friends, Here is what i am trying to achieve: Objective: I want to list out all the Categories (Directories) in each DataStage Project on a Server and save the resultant set on to a file on unix machine. For this i am doing the following on the Unix Server where DataStage is Intalled: Login in...