Page 1 of 1

Table Space access is not allowed.

Posted: Thu Dec 06, 2007 5:44 am
by ds_raman
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 ".

Posted: Thu Dec 06, 2007 6:06 am
by stefanfrost1
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.

Posted: Thu Dec 06, 2007 8:27 am
by ogmios
It's a DB2 thing, not a DataStage thing. Talk to your DBA's :D