Hello DBAs,

I am trying to create a index in user table when database online
backup is goin on.

The index creation process showing lock-wait status though only
following two application is runing at this time.

LOYADM db2bp 4357
*LOCAL.loyadm.040959134741 0001 1 0 86042
Lock-wait Not Collected LOYUAT
/home/loyadm/loyadm/NODE0000/SQL00001/
LOYADM db2bp 3813
*LOCAL.loyadm.010BB8233501 0001 1 0
1048648 Performing a Backup Not Collected LOYUAT
/home/loyadm/loyadm/NODE0000/SQL00001/
We can create table and index at the time of online backup. But I am
not getting why this is showing lock-wait from last 6 hours, though no
other users are accessing the database.

Thanks.

Manasa

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.


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