Here's my statement
REORG TABLE DB2GSE.GSE_COORD_REF INDEX DB2GSE.CO_REF_PK USE TEMPSPACE1;
RUNSTATS ON TABLE DB2GSE.GSE_COORD_REF WITH DISTRIBUTION AND DETAILED INDEXES ALL SHRLEVEL CHANGE;
here's the error
---------------------------------- Script -----------------------------------...
Here is my script that I run to get the qualifing rows that need reorged but I get this crazy -209 error while trying to use the TEMPSPACE1 tablespace to do my re-org....please help
select distinct
'REORG TABLE '||rtrim(char(t.tabschema,32))
||'.'||rtrim(char(t.tabname,32))
||' INDEX...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.