01-03-2018 12:52 AM
I am facing issues in Dataflux job which are developed for cluster id generation and scheduled thru Windows scheduler.
If I execute those jobs manually then it executes fine(around hrs) but in windows scheduler jobs are taking long time(around 8-9 hrs )
Please suggest what can be the issue
DF Studio: 8.1
Data size: More than 40lacs record
01-04-2018 11:23 AM
Hi - are you calling the dmpexec command from your scheduler? There are various options you can set when invoking the command that may impact performance, like choosing to write a log or selecting options that overwrite configuration file settings. There are also options for logging that might help you pinpoint the issue.
Another thought - I have seen in the past where dmpexec was executed by a user (different than the one used with Data Management Studio) that had different environment settings associated with it (like where the "temp" directory was located) and this impacted performance.
01-16-2018 06:55 AM
Thanks for your reply..
I don't execute any dmpexec command.
These schedulers were usually executing smoothly but now it is taking longer time to execute than usual.
previously it get executed in 3hrs now it is taking 7-9 hrs.
No.of rows are increased hardly by 2-3 lacs
01-16-2018 07:56 AM
Review the product documentation. There are topics that specifically deal with how you should be calling your DMP jobs if you are not running them interactively.
Regardless, check a few things: