Automic Workload Automation

Expand all | Collapse all

Execute DBUnload (ucybdbun) in parallel for several clients

  • 1.  Execute DBUnload (ucybdbun) in parallel for several clients

    Posted 11 days ago

    Dear Community,

    any feedback on parallel execution of ucybdbun?
    Does it increase the speed or will this cause some locking sessions?

    Thanks and regards



  • 2.  RE: Execute DBUnload (ucybdbun) in parallel for several clients

    Posted 11 days ago
    We always run in series as we believe running in parallel would cause blocking sessions.


  • 3.  RE: Execute DBUnload (ucybdbun) in parallel for several clients

    Posted 11 days ago

    Thanks for feedback!

    Any hints on how to increase the unload speed?

    It seems that each 1000 chunk takes about 2sec to complete. At the end each client takes about 2 days to complete..

    20201120/163247.801 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'EXEC' time: '1:806.613.000'
    20201120/163247.802 - U00003525 UCUDB: ===> 'insert into DIVDB (DIVDB_PK) select Meld_Idnr from Meld where Meld_DeleteFlag = 1 and Meld_client = 3000 and rownum <= 1000'​




  • 4.  RE: Execute DBUnload (ucybdbun) in parallel for several clients

    Posted 11 days ago
    That doesn't sound right we use the following command inside of a job that gets the provided files.

    /opt/automic/utility/bin/ucybdbun -BTRANSPORTALL -D -C&EXPORT_CLIENT# -X&EXPORT_PATH#/&EXPORT_FILE#