DSXchange

Hi Team, I have a generic ETL job which takes the SQL query given by user and loads a specific target table. Currently I have created a parameter to take the SQL query from user, however its not taking multi line queries. The complete query need to be given in one line. Is there any other ways I can...

Hi Team, I am using a Join stage to do perform a lookup based on 3 columns. Left Outer Join is used. I am not getting look up values. I replaced Join stage with LOOKUP stage, to my surprise I am getting matches. No other changes were done in the job, for datatypes or Columns names. Just a change in ...

Hi Team, I am selecting a 4 columns (ID,Code, Name, Time) from my SQL to load in to my target table. I have to generate a surrogate key only based on 2 specific columns. (Here code and Name). But I need all 4 columns to be part of my output Is there a way I can specify that ? Source Table ID Code Na...

Hi,

I have to execute this in Datastage. I had created a job with surrogate key stage. But with that I am not able to load Reference and Target tables in the way I want.

Any other methods are also welcome..

Hi All,

The issue got resolved. It was because password DB2admin user id had expired. DB2 services were stopped because of that.

I have reset the password and set it as 'Never expire', now the WebSphere server is running fine.

Thanks for the support

This entry was also part of StartServer log. If its helpful [11/26/13 11:43:51:057 IST] 00000000 WindowsServic 3 Service failed to start. startServer return code = -1 [11/26/13 11:43:51:057 IST] 00000000 AdminTool A ADMU7704E: Failed while trying to start the Windows Service associated with server: ...

Then your credential password has expired. ... You mean the OS credentials ? I could login to server with the same credentials. I have 2 DS Ids - wasadmin and isadmin, both mapped to 2 different OS ids. Both are not working.. Another important observation is, without giving the password also if I c...

Hi, Scheduled jobs are running and output files are getting generated. Only when I login to DS I am getting the below error. Error message: Failed to authenticate the current user against the selected Services Tier Could not connect to server [9.182.98.97] on port [9080]. Exception type: javax/secur...

Hi Team, I was not able to login to the DS web console using the link http://server:9080/ibm/iis/console/loginForm.jsp?displayForm=true I had restarted the WebSphere application server, but looks like it was not staring properly. The Start server log showed the error ADMU3011E: Server launched but f...

I am on V 8.5

Hi,

I have read somewhere Auto Purging is only possible for the the jobs which are getting created newly. Is it possible to do Auto-purge for existing jobs ?

Hi,

I don't have the auto purging enabled. One project have the log size close to 20 GB (Thats the maximum size).
Where can I see my LOGGING settings ?

Hi,

Thanks for input. Is there any way to clear multiple log files using the Clear.File command ?

Can I delete the RT_Log files from the project directory ?

What are RT_Status and RT_BP Files ?

Hi Team, From that last 2 days all the Datastage jobs are running slow in our server. Even extraction from sequential files seems to be slow. We have around 60 GB Free space in the Drive where DS is installed. All Hashfiles and output files are kept in separate Drive which has around 200 GB Free spa...