DSXchange

Hi All,

I am having an issue when running my job on a 2 node system.
When I first ran the job it complained that it could not find the state file. I changed my config file to run on one node and it worked OK.

I figured it was complaining because it could not see the state file on the other node. So I nfs mounted the surrogate key directory on the second node so that the state file is visible to the second node. Now when I run my job I get an error: "Unable to lock state file <path to file here>: No locks availble."

Does any one have an idea how to implement surrogate keys on an MPP system?

Thanks!

I have opened a ticket with support I will update this post when I get a resolution.

Thanks!