DSXchange

Hi When reading from CFF stage , i had set the Nullable Option as "yes" at the column level for Decimal data types. And the CFF stage was able to read the data. But today when i tried to repeat the same setting of Nullable to "yes" for the rest of the columns , it throws the warn...

unix sort is by default character wise . to sort it on numeric value ..it has to be sort -n hi, While using the sort stage i have to come to know that the unix sort option always sorts Character wise. That is between 10 and 7 10 comes before 7 in ascending order. Please tell me if this patch has bee...

dwblore: Salil : I dont have the administrator rights for this system. But when i view the environment settings for our project , it is given as PATH /IBMdb2/home/db2rtcl/sqllib/bin:/IBMdb2/home/db2rtcl/sqllib/adm DSGuru2B: This is happenning only when we run via the script. I login through a user c...

Our AIX is running out of space , but very recently we added 1GB for this /dstage/dsadm folder. When we increased the space , DataStage was running quite faster. How do i identify the temporary files which i can delete in DataStage to clear off some space. I have already cleared of some unnecessary ...

i want to kill the process which are currently run by one user and start running them fresh. if i do ps-ef | grep <user> i get a process like that which i dont have permission to kill it. Can u tell me wht this process is doin ? /u01/appl/DataStage/DataStage/PXEngine/bin/osh -APT_PMsectionLeaderFlag...

Craig System = SunOS Node = ssi2 Release = 5.8 KernelID = Generic_108528-18 Machine = sun4u NumCPU = 2 Job design is to do an insert/update for the target table. But the sequence has 18 jobs within it to be invoked. So 18 jobs will be started parallely . So, any fixes for this ? Some where in some c...

Hi All

<Seq_Name>.JobControl
(@JAC_SEPCS_MDSNG_NAMPLT);controller problem; Error calling
DSRunJob(<jobname>,code=-14
(Timed out while waiting for an event)


Anyone faced this before ?
suggestion to resolve this ?

Hello We have lookup for the same table and if it is not found then we do an insert in the same table ; and if entry found in the lookup we do an update in the same table as that of lookup table. We have used DB2 API stage . And we get this error . "APT_CombinedOperatorController,0: Failure dur...