DSXchange

apologies for reviving this thread.... sorry no CASE number from IBM only because I am no in the support gropu that would deal with them. I asked my support area how they fixed it and this is what I was told: the group that maintains our Data stage added this line to the dsenv file APT_DATASET_FLUSH...

Update... We have just upgraded to 11.5. We were on 8.5 without support as we were past our license expire date by a year. We contacted IBM as soon as we were in 11.5... here is what were told... Datasets make use of a linux system call named fsync. As a test, IBM told our support area how to disabl...

Red Hat Enterprise Linux on mounted/remote disk.

Just confirmed with our support area.. we are not on a GRID

Ray It happens every week since we moved to Linux Red Hat.. There are other jobs experiencing the same issue in performance. The one I wrote about is an extreme example Not sure how to tell how big each segment is... is this info from Dataset Management useful? ##I IIS-DSEE-TFCN-00001 08:47:18(000) ...

We have a very similar issue in our shop... writing to or reading from datasets seems to take forever. as an extreme example, I had a job that read 145 rows from a sequential file and wrote them to a dataset. We use an 8 node config file running DS 8.5 seqFile------------------>Transformer----------...

Moved my post to separate topic

One final question... I am using this isn a stage variable: CHAR(0):CHAR(1):CHAR(2):CHAR(3):CHAR(4):CHAR(5):CHAR(6):CHAR(7):CHAR(8):CHAR(9):CHAR(10):CHAR(11):CHAR(12):CHAR(13):CHAR(14) :CHAR(15):CHAR(16):CHAR(17):CHAR(18):CHAR(19):CHAR(20):CHAR(21):CHAR(22):CHAR(23):CHAR(24):CHAR(25):CHAR(26):CHAR(2...

Thanks for that reminder about stage variables. applying it now :D

I have programed in C/C++ for many years. It is coming back slowly though. I currently use this code in a transformer stage, in a PX job, to replace certain Ascii control characters to space in free format text fields: Convert(Char(0):Char(10):Char(13),' ', link.column) Then i stumbled on this threa...

Thanks for the excellent feedback and link.

Hi Saw nothing on this particular question so here goes. I am to give a lecture/demonstration on the use of a Join Stage to some of our less experienced DS Users. Start with the basics and show a Left Outer Join. Can the results of a DataStage Join be shown in a Venn Diagram? some people learn compl...