Follow these steps.
1.check the table state with db2pd -d database_name -reorg |grep 'Online
Paused'
2.you will get the tablespace ID and table ID find the table name and
tablespace name from the ID's
3.get the tablename and tablespace ID's.
4.give the REORg stop with "REORG INPLACE STOP".
This should solve the issue if not get back.
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.
"It was love at first sight. Then I took a second look!!!!!"
-----Original Message-----
From: manasa
[mailto:db2udbdba-ezmlmshield-x67451928.[Email address protected]
Sent: Monday, February 25, 2008 12:55 PM
To: LazyDBA Discussion
Subject: Re: RE: RE: problem in reorg
When I used reorg index stop command, it is not returning
anything, just hunging.
And db2 list application shows the reorg stop command is in
lock-wait state.
I forced the reorg index command by force application. The diag
log contain following
Reorg Indexes Rolled Back on:
Table S_EVT_ACT (poolID 6 : objectID 455) with reorg flags 0x04011010
And list history reorg is following
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log
Backup ID
-- --- ------------------ ---- --- ------------ ------------
--------------
G I 20080224022038 F S0002624.LOG S0002625.LOG
------------------------------------------------------------------------
----
Table: "SIEBEL "."S_EVT_ACT"
------------------------------------------------------------------------
----
Comment: REORG INDEXES
Start Time: 20080224022038
End Time: 20080224041847
------------------------------------------------------------------------
----
00078
---------------------
The main problem is that I am not able to access that table.
Every query returning lock time out. Even I tried to reorg second time,
it also giving lock time out. I guess table structure is changed or
reorg is holding the lock because not properly roll back.
On Mon 25/02/08 12:25 PM , "vishnuvardan" sent:
Manasa,
Can you give us the exact error you're getting when trying to stop the
Reorg?
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.
"It was love at first sight. Then I took a second look!!!!!"
-----Original Message-----
From: manasa
[mailto:db2udbdba-ezmlmshield-x17923499.[Email address protected]
Sent: Monday, February 25, 2008 12:01 PM
To: LazyDBA Discussion
Subject: Re: RE: problem in reorg
When I am using reorg index stop command, it is also comming in
lock-wait state.
The table have 7000000 records with 80 index. I did not able to check
whether it is properly rollback or not.
How can I check if any indexes hax been dropped due to force command?
On Mon 25/02/08 11:25 AM , "vishnuvardan" sent:
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text Do a db2pd
-d databaename and -reorg command see what is the state of the reorg on
the table ,most probably table should be in online paused state so stop
the reorg and then try to select from the table.
Thanks and Regards,
Vishnu Vardan G.
Project Engineer , Wipro Technologies
Bengaluru,India.
[Email address protected]
>*: 9740149105
>P Please don't print this e-mail unless you really need to. Save a
Tree.
"It was love at first sight. Then I took a second look!!!!!"
-----Original Message-----
From: manasa
[Email address protected]
Sent: Sunday, February 24, 2008 7:33 PM
To: LazyDBA Discussion
Subject: Problem in reorg
Hi
I executed reorg index with no access in a particular table which is
in apend mode. And it was taking too much time , that's why I force
that application. Now I am not able to run select * from ... with ur.
It is giving lock time out. I fount that no other application is
running. I did not able to find out which process is holding the lock.
Thanks
Disclaimer: This communication is for the exclusive use of the
intended recipient(s) and shall not attach any liability on the
originator or ITC Infotech India Ltd./its Holding company/ its
Subsidiaries/ its Group Companies. If you are the addressee, the
contents of this e-mail are intended for your use only and it shall not
be forwarded to any third party, without first obtaining written
authorization from the originator or ITC Infotech India Ltd./ its
Holding company/its Subsidiaries/ its Group Companies. It may contain
information which is confidential and legally privileged and the same
shall not be used or dealt with by any third party in any manner
whatsoever without the specific consent of ITC Infotech India Ltd./
its Holding company/ its Subsidiaries/ its Group Companies.
---------------------------------------------------------------------
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
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
DB2 & UDB email list listserv db2-l LazyDBA home page