DSXchange

Prasanna, these RT_LOGnnn files are Hashed files and cannot be read from UNIX; so there is not much purpose in determining which file belongs to which job. You can find the association between the job name and the job number using the DS_JOBS file/table. The command you can use to get this from TCL ...

sure I have in the past. Depending upon your configurations the SSH program might require additional input (particularly the password), so you would need to cater for that. The easiest thing to do is to write your own "wrapper" script to execute SSH and get that to work correctly, then you can eithe...

It sounds like your problem is easily reproduceable, define a table with just one NChar (are you sure you didn't mean NVarChar?) column and read it into Datastage, then write it to a sequential file. Is that correct?

But didn't you also state that running the same SQL from the command line now also takes a long time?

You can execute this query from the TCL environment from UNIX as well. You need to make sure your shell has executed the ".dsenv" script to set up the environment variables, then attach to the project directory and execute "$DSHOME/bin/dssh" to enter TCL; then you can perform the SELECT as Ray has o...

Prashant, you stated that ran same querry on sql pls .there also it ran for long. . If you only changed from DataStage 6 to 7.5 and didn't make any changes to your database, then the pure SQL query should have run for the same time. Since this query that doesn't use DataStage also ran slower, why do...

srini,

...But it's giving error...sleep10.sh: cannot execute...

It looks like you have specified the call incorrectly, which routine and parameters have you used?

nraj, you really need to offer some more information and also to try to narrow down your source problem yourself. Here are some questions that might get you thinking or testing in the right direction, as the error message is not very helpful: - does the error occur right away or after the job proces...

Hello pukars4u, the question really has nothing to do with DataStage - but if you might be kind enough to tell us which database you are using someone might be able to answer the question. Since you are running a job you probably know which table you are working with. You most likely will also be ge...

Phil, I think you need to look at your statement and rephrase it so that it doesn't seem as if a compare in datastage won't work. If you have a numeric comparison of digits longer than the EXACTNUMERIC setting there might be some internal loss of precision. When does a normal comparison of "001" and...

Emma,

there is no difference between a sequential file and what is called a "complex flat file"; at least not directly. Your .txt file might be readable directly from a COBOL program as it is. What format is the file in (ASCII/EBCDIC) and does the COBOL program expect it in that form?

It looks like after 30 minutes the remote connection either timed out or was terminated. A named pipe always needs 2 processes to work, a reader and a writer; and it looks like the remote reader process from BW didn't read this past time. If things are working since then, then it was probably some s...

Sunshine, the DSR_ExecJob() routine is called at runtime, so it must happen when you try to execute the job from the Designer. Have you checked you director log for this job are an aborted run? Do you have a before- or after-job subroutine call in the job? Have you seen this problem in other jobs or...

If you are doing pure inserts you really should look at the performance benefits of doing a bulk load - which can include turning off and subsequently re-enabling constraints for quicker loading. The downside is that if you load data that violates constraints you will have a table with a very upset ...

Deepak - the IPC buffer size really should make no difference, if the machine is quite slow then the IPC timeouts should be raised. The default buffers are just fine in 99.9% of jobs and increasing them is most often a waste of precious process virtual memory. Usually either the read or write is goi...