Thanks Vishnu,
I tried to Resume the reorg with this command
REORG TABLE DATARECLAMOS.ERECLAMO INDEX DATARECLAMOS.PK_ERECLAMO
INPLACE ALLOW WRITE ACCESS RESUME
but return the following error:
SQL2219N The specified INPLACE table reorganization action on table
"DATARECLAMOS.ERECLAMO" is not allowed on one or more nodes. Reason
code: "1".
the description for this error is:
1 Table reorganization cannot RESUME as the original data or
index object has changed.
Do you know any way to force or restart the reorg, or any other
command to help me?
Thanks for your time
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
vishnuvardan <db2udbdba-ezmlmshield-x40453242.[Email address protected]
ha escrito:
>
> Juan,
>
> The table is in Reorg Paused state you have to either Resume the
> Reorg which was running or you can Stop and Start the Reorg,
>
> If you want to check the table which are in Online paused state you
> can issue this command.
>
>
> DB2pd -d Data_base_name -reorg|grep 'Paused'
> It will give you the tables list which are in Online paused state
> then you can issue or write a script to stop and start the Reorg on
> all the tables I hope it solve you're problem.
>
> We had a similar problem some time back we do a active monitoring to
> avoid this issue.
>
>
>
> Thanks and Regards,
> Vishnu Vardan G.
> Project Engineer , Wipro Technologies
> Bengaluru,India.
>> *:vishnuvardan.[Email address protected]
>> *: 9740149105
>> P Please don't print this e-mail unless you really need to. Save a Tree.
>
> -----Original Message-----
> From: Juan Gabriel Quintero
> [mailto:db2udbdba-ezmlmshield-x98176883.[Email address protected]
> Sent: Wednesday, January 30, 2008 3:55 AM
> To: LazyDBA Discussion
> Subject: Reorg problems
>
> 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
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
> post a dba job: http://jobs.lazydba.com To Subscribe :
> http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>
>
> Please do not print this email unless it is absolutely necessary.
> Spread environmental awareness.
>
> The information contained in this electronic message and any
> attachments to this message are intended for the exclusive use of
> the addressee(s) and may contain proprietary, confidential or
> privileged information. If you are not the intended recipient, you
> should not disseminate, distribute or copy this e-mail. Please
> notify the sender immediately and destroy all copies of this message
> and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The
> recipient should check this email and any attachments for the
> presence of viruses. The company accepts no liability for any damage
> caused by any virus transmitted by this email.
>
> www.wipro.com
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
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