Execute DBUnload (ucybdbun) in parallel for several clients

[Michael TMO8Y2tl]

Dear Community,

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

Thanks and regards

[Will Boyd]

We always run in series as we believe running in parallel would cause blocking sessions.

[Michael TMO8Y2tl]

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'​

[Will Boyd]

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#

[Devidutta Das]

Reorg and unload should be executed one after the other for a client . You can always increase the chunk size to 5000 in the unload ini file so that it will take 5000 records at a time instead of 1000 . You can also check if a Database/Table reorg is needed that will also improve the unload .
Assuming all the parameters are properly set in the ini file of the unload ?

Thanks
Devidutta Das