Table Space access is not allowed.

ds_raman · Post by **ds_raman** » Thu Dec 06, 2007 5:44 am

Hi Everyone

kindly suggest me an alternative to resolve this problem, my target database is DB2, when i try to perform a load with the "write" option in DB2 UDB stage, i get the following error " Table Space access is not allowed ".

stefanfrost1 · Post by **stefanfrost1** » Thu Dec 06, 2007 6:06 am

You are propably trying to load the table without proper rights... To handle pending load state, change the property in db2 stage cleanup on failure to true and your state is reversed.

ogmios · Post by **ogmios** » Thu Dec 06, 2007 8:27 am

It's a DB2 thing, not a DataStage thing. Talk to your DBA's :D