DSXchange

In the job design what are the stages you have in between the read and db write? Doing any partition on the column?

DS_MJ wrote:Hello ahmedwaseem2000:

I am doing a Hash partitioning in this join and not using a sort stage.
When I remove this join I dont get this error ("mmap failed: Not enough space")

Thanks again.

Set the environment variable "APT_TSORT_STRESS_BLOCKSIZE" higher value and give a try..

....for this i need to capture the column name in my transformer...any idea how to achieve this?.....pls keep in mind that there are 270 columns..and in dont want to do manual typing work (i already have a labourous approach :-( ) If the source is any DB then first load them into a file with "...

Thank you all very much for the inputs. Details on the ETL Report that I need. We have some Sequencer Jobs and each sequencer is calling subjobs and also sub sequencer jobs. ETL report should generate the run times of the sequencers, subjobs and the stages/links in the subjobs at the project level....

Ok - Just ran a test on my system and I had to put the full path into it for it to work (from the log): DummyJob..BeforeJob (ExecSH): Executed command: /opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -domain machine:9080 -user dsadm -password removed -server machine.company.com -lprojects *** ...

chulett wrote:Fully path the dsjob command. ...

Thank you Craig.It worked.
we should have tried that before posting! we'll be more careful next time :D
thanks for stopping by...

Use the BASIC transformer and the RowProcCompareWithPreviousValue Transform funtion will accomplish the requirement.

Andy, What ever we have tried/posted above is from Datastage Desginer, Not from command prompt. the dsjob -ljobs DEV_PROJ >/home/dpuser/Job_Report.txt command works like a charm on the UNIX command prompt from any where including the user home directory which means the .profile setting for "..D...

dssearch command can be used to Search for Job Using Specified Table Definition--(Please check the options @ P714 of Server job developer's Guide)--but that may only work on server jobs that uses the DRS stage Not sure about the command to get the File name of Sequntial file stage! kDuke Etlstats ma...

I tried using a different table with only one input column.
Still the job just keeps running with zero rows processed.

In director logs, it shows, logging metadata and thats about it...

Please suggest

Thanks

Ray Thanks for the clarification. Appreciate that.

Hi All We are trying to use ABAP extract stage for the first time using RFC as the data transfer method. In the ABAP program tab We used Build extraction object and added a table. Just trying to run a simple Select query. We are uploading the generated program and trying to run the job. Load Method ...

a batch file with the below can help to get just the Job name in the category... but i am sure the experts gave you the way to get the annotation given in that job @echo off SETLOCAL SET Host= SET /p Host=Type host and press Enter: SET User= SET /p User=Type User and press Enter: SET PW= SET /p PW=T...

Are you doing your If num(incolumn) = 0 then setnull() else incolumn in the Column derivation or in the stage variable? What is your input stage for the transformer..i.e the design looks like(file-->transformer-->file)?? Try the following and see if that works... Make the nullable as "NO" ...

dstager wrote:yes, i am using the setnull() in a conditional statement...

ie.

If num(incolumn) = 0 then setnull() else incolumn

or

if isnull(incolumn) then setnull() else incolumn

which one is giving the warning/abort..both or first one?