DSXchange

Kim, the 'buffering' issue *was* a performance related server side bug with row buffering and is unrelated to anything crashing on the client side. And 7.5A is older than 7.5.1x, so that fix would be incorporated in the version you are running. What is the most recent version of DataStage? Is it 7....

harithay wrote:i am new to datastage. we are working on datastage enetrprise edition. as far as i know extract flatfiles we use sequentcial file in server jobs.what about in parallele jobs.

Can you be liitle more clear on this.

What is your Source DataBase/FlatFile?

Thanks

Can anybody throw some ideas on ,
doing any kind of periodic maintenance on the Version Project.


Thanks in Advance.

I was neglect in that I did not do a search before posting my solution. I still believe it is a valid post, but I have found the following post Check This that may help you. Thanks mhester. I checked that post,it was informative. My SQL Server version is 8. We were able to run the same jobs using B...

I have a job that moves data from one oracle table to another oracle tables. The datastage server and oracle server are physically different. I am getting a speed of only 100 rows per second even if it is a simple transfer of data. I have OCI -> TRANSFORMER -> OCI stages. The transaction size has b...

dsmsdbl.dll is NOT a SQL Server client dll shipped by MicroSoft, rather this is shipped as part of DataStage and should be found in the engine\bin directory. The properties state - DataStage DB Library bulk loader for Microsoft SQL Server Copyright (C) 2004, 1997 - 2003 Ascential Software Corporati...

Check your ds_loadlibrary settings. That will be different. I was looking through help for BCP Stage. ____________ Note: The client libraries used by the BCPLoad stage are not supplied as part of DataStage. You must obtain these libraries from your DBMS vendor and ensure they are installed and conf...

talk2shaanc wrote:Sorry, but i dont know how to logon on to Datastage using telnet service.

At your MS-DOS command prompt,
type telnet
and then say open hostname(your DataStage Server Host)
when prompted enter your username and password.


Thanks

We are trying to test few jobs on a New Server.


One of the job failed with the following message:
Jobabc..Sybase_BCP_Load_0: Could not load dsmsdbl.dll
The job is loading to SQL Server database using BCP stage.

This same job ran fine on a different server.

Any thoughts?

Thanks in Advance.

Hi All, I am facing a problem with Link Collector. There are two inputs to this link collector. While compiling it is giving the error "Link Collector Stage Does not Support in-process active-to-active inputs or outputs". Will any one give some input to solve the problem. Thanks in Advanc...

Hi I am using notification activity at the end of my sequencer to send email. I do not want to hard code my mail server and email address as it may change. I thought that I could create a parameter in sequencer properties and put that in the mail server name and email address. For e.g. #Mail_Server...

fridge wrote:I have had this problem in our set up and I believe it can be resolved by reindexing the version control repository, using DS.TOOLS from the command line in Admin.exe often does the trick

Thanks for all ,
for all the valuable replies.

kollurianu wrote:So are version control tables on Universe Tables too.

Thank you very much.

Yes.

kduke wrote:I looked around and it appears APM.VERSION seems to be the file.

LIST DICT APM.VERSION

To show you all the fields available.

Thanks Kim.

Hi Kim,

Is there any limit on no of versions a job can be there in VersionControl tool?

Since VersionControl is moving different job contents,
we are curious like any pointer issues internally or something else.

Thanks in Advance.