Re: Creating Index
Hi Isidre.
onstat -k has a lock ?
e.g)
Informix Dynamic Server Version 9.30.UC3 -- On-Line -- Up 27 days
03:56:10 -- 28080 Kbytes
Locks
address wtlist owner lklist type tblsnum rowid key#/bsiz
0 active, 2000 total, 2048 hash buckets, 0 lock table overflows
This situation, noone has any locks.
Your situation,
Anyone has any locks ?
Regards.
--
Tsutomu Ogiwara from Tokyo Japan.
ICQ#:168106592
>From: "Isidre PONS ROCA" <ipons@dtgna.altanet.org>
>To: informix-list@iiug.org
>Subject: Creating Index
>Date: Tue, 05 Aug 2003 10:16:25 +0200
>
>Hi all.
>
>I have a problem when creating index. After build a index I can't build
>other on same table after 3 o 4 minutes. I receive an error "the table is
>locked".
>
>Environment:
> Solaris 2.6
> IDS With J/Foundation 9.21.UC3
> HDR running.
>
>Any idea about that?
>
>PS Sorry for my english.
>--
> Isidre PONS ROCA
> BASE - Gesti$B!&(Bd'Ingressos Locals
> (Diputaci$B!&(Bde Tarragona)
> Sistemes d'Informaci$B!&(B> Av President Lluis Companys 12-C
> 43005 - Tarragona
> SPAIN
> Tel # +34 977 253 404
> Fax # +34 977 227 302
> http://www.base.es
> ipons@dtgna.altanet.org
>--
>
>
>sending to informix-list
_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
sending to informix-list