DSXchange

Prevention is always better than cure. Make sure that whatever it was that timed out does not need to do so. Often timeouts are caused by overloaded servers. In this particular case the problem app ... Hi Ray, Sorry to say that I am not premium user, can you put the comments in nomal text :), so th...

just increase ipc stage bufffer and time out values. i think it will work. Hi Chulett, We are not using IPC stage below is the flow of the jobs: ODBC--> Transformer-->Container --> ODBC In Container inport --> CRC generation (transformer) --> outport Are you telling to use IPC stage instead of Tran...

chulett wrote:What operating system? ...

Hi Ray,

It is Linux box, with Datastage 8.0.1.

Regards
Rajeev Prabhu

Hi, We have a parallel job from which we are calling server shared container to generate CRC and the job is failing with the following errors mentioned below: stdhub_Account_Pack_Hub.#0.stdhubCRCAcctidDF.Output_Acct_Table-Input.Input: ds_ipcgetnext() - timeout waiting for mutex Attempting to Cleanup...

Hi, I am trying to load the data into Windows SQL Server using Bulk insert, but I am getting an error "APT_CombinedOperatorController,0: Fatal Error: Fatal: Stage supports bulk load to SQL Server only on Windows". So please let me know what options should I set to carry out the activity in...

Do you mean to invoke the DataStage job from a Web service, or to expose the DataStage job AS a Web service? ... Yes Ray it is to invoke Datastage job from web services i.e. call a job while a page is submitted in web. Currently I am writing a bat file which will call dsjob command and execute the ...

Hi,

We have a requirement from client to execute some Datastage job using web services. So please let me know what all are the ways that we can get this accomplished.

Regards
Rajeev Prabhu

Hi, GJ_Stage, it is flat file and with fixed delimiter. We were able to solve this problem by changing the parameters that were provided in the source odbc stage. Initally we had provided only the table name in the parameter, here I change it to <dbname>.table name in the source parameters and then ...

Hi, We have a simple job taking data from source and loading the data to a sequential flat file. The flow is as follows: ODBC stage (SQL server) ---> flat file In ODBC we have a select query, which is perfectly working while executed induvudiaully and also we are able to see the data through ODBC st...

Hi, I am carrying out a installation for DS 8x in Windows Environment. At the middle of the installation it is asking for the Domain, Username, Password and Server name. We have given it as Domain: Servername:9080 Username:dsadmin(created during installtion steps) Password: Servername: ServerIP I am...

Hi,

Is there any way that we can find the list of the jobs which got modified in a particular time frame.

I did an serch that forum and found that we can find jobs from unix and I think we can do the same grep in unix to do so?

Regards,
Rajeev

I was told IBM/Ascential had a tool to automate this conversion as well as converting from Informatica. It does not convert everything but supposed to convert most. Ask them. Ray may know. Hi Duke/Ray, Do we have such tool for convertion from one tool to another bulit by IBM? Regards Rajeev Prabhu

Hello Rajeev, accessing Excel directly on UNIX is not a builtin feature of DataStage or of UNIX. There are software packages that will let you declare an Excel document to be accessible via ODBC on UNIX, but you need to buy the software. DataDirect is one supplier of this software and there might b...

You only need to declare your Excel sheet as a system ODBC data source and you are in business. Fortunately you are on a Windows platform so this is easy; if the DS server is on UNIX and you need to access Excel it becomes a bit more complicated and expensive. Hi, I have to access MS Excel spreedsh...

Hi Rajeev, Thank you for your comments. Can you elobrate how we can achive this in windows version by adding osh shell. Regards, Rajeev Prabhu Hi Prabhaut, If you want to run only server jobs just go for the installation of DataStage Engine on windows as per ur required thing.And regarding the state...