BCP cannot read table created in the same transaction when executed from Control-M
0
votes
1
answer
259
views
How to export global temp table using BCP when original process locks table for BCP?
We created our own exporting procedure where we provide SELECT or table_name and procedure stores data to global temp table, which then BCP utility exports.
It runs fine, but when we run it from BMC's Control-M system, there is schema modification lock on the table and procedure just waits for itself to unlock.
Static table(s) is not a good solution for us.
We tried using for example self linking linked server or index on all columns of global temp table.
Our current proposal is to add export to a queue which would then be exported asynchronously by another process.
Asked by owl
(310 rep)
Feb 17, 2021, 02:30 PM
Last activity: Jul 16, 2021, 09:22 AM
Last activity: Jul 16, 2021, 09:22 AM