Hi DBA's...

I am getting the following error on the reorg which I was running

REORG TABLE DATARECLAMOS.ERECLAMO INDEX DATARECLAMOS.PK_ERECLAMO
INPLACE ALLOW WRITE ACCESS START

SQL2219N The specified INPLACE table reorganization action on table
"DATARECLAMOS.ERECLAMO" is not allowed on one or more nodes. Reason code: "9".

based in other answer for the same problem, check the status of Reorg
on that table

Table Schema = DATARECLAMOS
Table Name = ERECLAMO
Table Type = User
Data Object Pages = 7078
Index Object Pages = 4046
Rows Read = Not Collected
Rows Written = 0
Overflows = 0
Page Reorgs = 0
Table Reorg Information:
Reorg Type =
Reclustering
Inplace Table Reorg
Allow Write Access
Reorg Index = 4
Reorg Tablespace = 7
Start Time =
Reorg Phase =
Max Phase =
Phase Start Time =
Status = Paused
Current Counter = 0
Max Counter = 7077
Completion = 0
End Time = 01/26/2008 23:10:15.106597


So, i tried to run this command

REORG TABLE DATARECLAMOS.ERECLAMO INDEX DATARECLAMOS.PK_ERECLAMO
INPLACE ALLOW WRITE ACCESS RESUME

SQL2219N The specified INPLACE table reorganization action on table
"DATARECLAMOS.ERECLAMO" is not allowed on one or more nodes. Reason code: "1".


And this is not the wrost i have the same problem for other tables,
please suggest me the solution.


Juan Gabriel Quintero Barbosa
DBA DB2 UDB Computec
ITConsultings
Movil: (57-310) 3014660
Email: [Email address protected]
Oficina Bogotá: Cra. 11 No.71-73 Of. 405 Tel: (57-1)3215753
Oficina Medellín: Cra. 43A No.1Sur-31 Of. 205 Tel: (57-4) 3522097
Web Site: www.itconsultings.net
Informix & DB2 Specialists
Business Intelligence Solutions
Information Integration Solutions




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