DSXchange

Hi, When Iam running the job in parallel . I mean in entire partitioning . I have a job with two sequential files and a join stage and target as sequential file in join I mentioned Cab column in both files as Entire partition in join stage and I stored the column in join stages for both files and lo...

Hi Arnd, Even if we added additional space , my job is aborting throwing the same error. Now the job is aborting showing target file growing till 8950000 rows and input files as 0 rows . when I typed df command to my directory where my target file is loading, it is showing now Filesystem 512-blocks ...

Hi, My problem was solved . We are missing DB2DIR env variable in our dsenv file. I looked at the job execution from July 2006, which was successful and it had this env. variable: DB2DIR=/usr/opt/db2_08_01 When I looked at the most recent execution this setting seemed to be missing... Action: Added ...

Hi "ArndW", I saw my free disk space available in the directory where my file is loacted. And it gave me df /datastage/project/qclass . It gave me Filesystem 1024-blocks Free %used Iused %Iused Mountedon /dev/hd1 4194304 2000 100% 687 1% /dataStage Iam not able to load even a single row da...

Hi chulett,

I looked at dsenv file it looks ok . When I checked my job log I got a message

ds_loadlibrary: error in dlopen and in event it says other =21 .


Can some body tell me why Iam facing this error



Thanks,
SomaRaju.

Hi,

Please can some body guide me in which direction I need to go.
1. Do I need to increase the scratch disk space only or
2. Do I need to increase both scratch disk space and Dataset disk space



Thanks,
SomaRaju.

Hi, I have a configuration file like this { node "node1" { fastname "S25sas40" pools "" resource disk "/DataStage/751A/Ascential/DataStage/Datasets" {pools ""} resource scratchdisk "/DataStage/751A/Ascential/DataStage/Scratch" {pools "...

Hi Arnd, The job is running now with out any errors . I don't know how it was solved. And the file has having a size 43632456 and when I try to use this file to join with other file to load in to a single file I am getting the same warning in this job . The job has two Sequential file stages , join ...

HI ArndW, I ran this command from the job contro Execute "SH -c 'ulimit -a'" Capturing UOUT Call DSLogInfo ("ulimit settings: ":UOUT, "JobControl") and In log I can see the same values CopyOfCopyOfCopyOfWWPRT..JobControl (JobControl): ulimit settings: time(seconds) unli...

Hi, I searched in the form for the output file full . I have seen in one of the form to type ulimit -a command . When I entered the command I got the output as given below. time<seconds> unlimited file<blocks> unlimited data<kbytes> 131072 stack<kbytes> 32768 memory<kbytes> 32768 coredump<blocks> un...

Hi,

I have a job where iam using 5 files as input and Iam loading the required columms from the 5 files to a single output file . when Iam running the job the job is aborting by raising an error


file1,0: Output file full
file1,0: Failure during execution of operator logic.




Thanks,
SomaRaju

Hi Chulett,


Do you think this error occurred due to not updating the dsenv file.




Thanks,
SomaRaju

Hi, We recently update our Ascential server from 7.5.1A to 7.5.2 . When Iam running the old jobs in new server the job is aborting by giving the warning for Hash files Warning : CheckData.CheckData.SUP_HASH.IDENT2: C Stage PlugIn function "Get" required Abort Warning CheckData.CheckData.SU...

Hi,


My problem was solved . I changed in sequential file stage Format tab Record delimiter string to Dos format so when I open a file . I can see records one after the other and not in one line.








Thanks,
somaRaju.

Hi I_Server_Whale My input file is not in a concatenated form? I tested by specifying the record delimiter/line terminator in my target Sequential file stage as UNIX newline and Null. When I open the files I can see the data as concatenated, when I tried to open the file in ultra edit the data was m...