DSXchange

Thanks Chulett ,

yes problem is in DS_JOBOBJECTS.OLETYPE , I have modified ,
now it is working .

Thanks again


Arun

Thanks chulett,

As per your suggestion , I have implemented in my application , now it's working fine .

Thanks and Regrards

Arun Verma

I have created one job sequencer where I am using job activity to call another job and that will triggred depend user status condition . i.e . UserStatus- (Conditional) = "Ok" Or "Warning" . This means if Job1 give warning or Ok then triggre next job , but it is also trgring when...

Thanks Chulett

Yes it is true , auto purge is working for new job , I am gonging to implement that suggestion give by you and Mr. Ray.

Regards

Arun

Hi Chulett/Roy Actualy we hacve faced problem in DS server few days back , one person run DS job with NO limit option and around 100000 log entry created and as result serevr hang , so I want to monitor DS job , Log must be 3 days only . We have successfully migrated DS from 5.2 to 7.1 and at projec...

Can any body help me that how to get job name from universe which log not cleared before 3 days from sysdate .

I am right boss , I have given solution with using Unix script only ,
you create Unix script then call form DS Jobs .

Yes , user has to know Unix shell script .


Arun

Hi Babbu , If the source file format is fixed then you can use Unix script to filter out and some computataion , we had also same problem . we are getting file which header contain header level date and time and bottom Status total number of record etc . then through Unix script first we chack file ...

Sorry , one point I have missed out , before sorting file pl ensuere
that derived column should not NULL , to avoid this type of problem
use constraint as Not(IsNull(ToTransf.join_date) .

Hi , I have succesfully developed This type of Job , pl. find step i used . For Ex. sequential file File contain empid , join_date , leaving_date 1. date value as DD-MON-YYYY , column format VarChar2(13) 2. Sort this file using CO-Sort Plug in - empid asc none no N 3. use aggregator to get max min ....

Thanks Mr. Ray ,

Ok I will go through document .

arun

Hi Ray, Thanks for your prompt reply. I understand from your reply that T30Files set to 2000 is also not the upper bound. Can i request to suggest the optimal value setting for this parameter? Do i need to set it to say 10000 or 20000? Will this likely to resolve my problem? Can it add any other pro...

HI Mr. Ray , We have increaed T30FILE limit to 2000 , This has file is not shared hash file , one job create at the time of extraction and other job user at the time of loading , we have to use dynamic hash file , because this is master code and name hash file , if any record added in source system ...

Hi Rasi ,

As per Mr. ray's advice , we have already changed T30FILE limit to 2000 , This is maximum limit .


Arun ,

Hi All , We have multiinstane job and Data extraction some hash file created and the same used at the time of data loading , we got error while creating hash file and job got aborted . pl. help me . J10IcaSrc.41.HProductCancelReason.ToCancHFile: DSD.UVOpen "HProductCancelReason_41" is alre...