Hi all,



I'm using DB2 LUW 9.1

For some reason my table space is in restrictive mode so I cannot do any
transaction. Does anyone know how I can terminate that problem? I even
try to drop it, but it won't allow me.



Please help



db2admin:/db2/instancename/data3>db2 "load query table tablename"

SQL0290N Table space access is not allowed. SQLSTATE=55039



Jose Gabriel (Gabriel) Saldana
Associate Database Administrator

IT Enterprise Database Management Services

CenterPoint Energy, Inc.

Wk: (713) 207-5533

Pgr: (713) 687-6525

Cell: (281) 748-4282


DB2 & UDB email list listserv db2-l LazyDBA home page