DSXchange

If you log into ascentials website and go to product documentation under knowledge base, you should be able to download the orchestrate docs.

http://www.ascential.com/eservice/pages ... trate.html

Can you do a netstat -a | grep -i fin Do you see any connections out there with a finwait2 status? If so, you will have to wait for the no -a | grep tcp_finwait2 value divided by 2 seconds to expire before these connections die and you can restart the service. I set this value to 60 for 30 seconds. ...

I found number 3 to exist already as the column import stage. Still curious about 1 & 2.

I have been using external target, and that works great for outputing the data to a file. But what if I don't want multiple jobs and I want to stream that data to some other routines/stages? I thought I could use the external filter stage, but I must specify the input as being a single column of dat...

Can you use an external target stage to write to a delimited sequential file? Can you use awk? If so, I think this awk tidbit might do the trick. #!/bin/ksh FNAME="${1}" AFS="${2}" awk -vAFS="${AFS}" -vFNAME="${FNAME}" 'BEGIN{FS=AFS;OFS=AFS;} { COUNT=1; while ...

I entered your data and I came up with this query. I hope someone can come up with a better answer for you. This query might not run well on your database and if you do run it, you may want your DBA (if not yourself) to validate indexes exist for this query. SELECT K1.NBR, K1.SEQ, (SELECT MAX(K2.EVN...

awk will keep track of what files it has used/opened. Once awk is stated, any new file used/opened will be overwritten the first time. Any file re-used after that will be appended.

Basically, > is the same thing as
>
followed by
>>

in a normal shell script.

Thanks,
Ryan

I am trying to load balance the network IO across multiple network interfaces that are on the same AIX SMP server. I put my APT_CONFIG_FILE in a previous post. Please look at the file and offer any suggestions. I would be happy with round robin approach. That is, one config file for this network int...

Could you use an external target stage for your job? You could create a shell script similar to the one below. It will create a file for each distinct value of $1 (the first field), named $1.file. #!/bin/ksh AFS="${1}" DIR="${2}" awk -vAFS="${AFS}" -vDIR="${DIR}&qu...

Will do. Thanks for your feedback.

I do. It is the same server. The interfaces rcrpdev1a and rcrpdev1b are two different interfaces into the same server.

I believe I have tried that, but jobs abort with these messages: main_program: Accept timed out retries = 8 main_program: The section leader on rcrpdev1b died main_program: **** Parallel startup failed **** This is usually due to a configuration error, such as not having the Orchestrate install dire...

What is the best way to forcefully disconnect/terminate a user process? kill -15, then kill -9 on user processes? Just shutdown the server and wait for tcp_finwait2 time? I have tcp_finwait set at 60 so after 30 seconds AIX will terminate the network connections and the service can be restarted. You...

Can you have your database engine do the work? SELECT K1.NBR, K1.SEQ, ( SELECT MAX(EVNT_EFCTV_DT) FROM Kav K2 WHERE K1.NBR= K2.NBR AND K1.SEQ = K2.SEQ AND K2.EVNT_CD = 3800 ) AS "DT1", ( SELECT MAX(EVNT_EFCTV_DT) FROM Kav K3 WHERE K1.NBR= K3.NBR AND K1.SEQ = K3.SEQ AND K3.EVNT_CD = 6000 ) ...

You can set ulimit for a shell and inherited shells will have the new ulimit. That is, you could set it in your profile, logout and login, then bounce datastage. cat ~/.profile ## DATASTAGE PROFILE unset ENV ## DATA ulimit -d 1048576 ## MEMORY ulimit -m 1048576 ## NOFILES ulimit -n 10000 ## STACK ul...