we have 2 data mover job failures and we need to find the root cause , can you please share the SQL , where we have to find this (means in PDCRINFO)
You can check dbc.dbqlogtbl or PDCRINFO.dbqlogtbl_hst for errorcode > 0 and for the user ids used by Data Mover jobs.
I would first check from Data Mover command-line or Data mover portlet for error details.
datamove status -job_name job1 -output_level 3
datamove status -job_name job1 -output_level 4
(For detailed log information use level 4)