DSXchange

Well it really depends upon your level of comfort when saying "it is up". I will assume a Linux back end host for this example. 1) You could look for dsrpcd pid. - if that is not running you are dead in the water. 2) You could look for the java pids associated with websphere. - webphere no...

Shell script with a loop.

start of loop:
$line1=read the line from input;
$line2=read the line from input;
$line3=read the line from input;
echo it to the output "$line1 $line2 $line3";
end of loop

if condition the loop to beak out once you reach the end of file.

Since it is a sequential file to begin with, I would do it from a command line and not DataStage logic.

https://stackoverflow.com/questions/132 ... ell-script

sed command for string replace and make it with the /g option

Have you thought of using a build op?

There is a Stage for that. Try the External Source Stage I believe.

Is the program you are using to view the database table able to display that character set?
Does the database table contain the hex value of those characters?
Is that special character even present in a UTF8 character set?
Is the Database table schema valid for that character set?

Personally I would use DSODB tables to identify the latest project/job/status and then follow up with a dsjob -logdetails extract to get the logs. I would avoid direct queries to xmeta because a bad user written script could impact your production ETL flow. Impacting DSODB will not halt your ETL flow.

Are fewer people logging into this site or is it that fewer people are asking questions? I know that Information Server has been around for awhile but is the lack of activity here indicative of a move away from this tool in the industry? I like it (biased answer of course) but it's not "open so...

look inside uvconfig. Look at the paths defined in there, perhaps one is missing...

What has your research into your missing uvconfig path? Did you validate everything in there?

For the DataStage admins our there... you might want to go out and look at your /root path/mount (which defaults to / mount) and see if you are amassing some garbage collection files. Over time you run the risk of filling up the / mount (unix) if you do not address this. https://www.ibm.com/support/...

Any speed improvement?

How did it go?

yes.

1,000,000 / 200 = 5,000.

Try that as your array size.