Hi DBAs,
Because of my 4k tablespace was going to full, I created one new
tablespace in new filesystem and shifted few tables from the old
tablespace to new one. Now over all system is performing slow. No
error in diaglog, no lock-wait state, reorg check also shows no reorg
requires. All indexes are as it was and also tables contain the same
records as previous.
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