we have 2 data mover job failures and how to find in sql

Backup Archive and Restore (BAR)
All things BAR
Highlighted
Enthusiast

we have 2 data mover job failures and how to find in sql

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)

2 REPLIES
Junior Supporter

Re: we have 2 data mover job failures and how to find in sql

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
or
datamove status -job_name job1 -output_level 4
(For detailed log information use level 4)


Abhishek Jadhav
Enthusiast

Re: we have 2 data mover job failures and how to find in sql

Thank you Abhishek