Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Christian Knappke — — source: Informix-list mailing list archive (1991-1998)
<robertwane@hotmail.com> wrote in message
news:8t2t94$5mt$1@nnrp1.deja.com...
> 1:Sometimes the TEMPDBS is full and cause some functions such
> as "create index" fail ,but I do not create any table in TEMPDBS ?
What
> is the problem?
Temorary dbspace(s) are used for sort operations. These are essential
for
index creation. The total size should be larger than the biggest index
to
be created. If you use onarchive it *must* be bigger than the whole
logical
log. Ideally you spread several equally sized temporary dbspaces over
independant disks. Keep them apart from root, logical and physical
logspace.
Don't miss telling the server about them via DBSPACETEMP (onconfig
and/or
environment, see Informix documentation). If you have several temp
dbspaces
They will be used in a "fragmentation round robin" manner to improve
perfor-
mance.
> 2:How can I delete a row lock mannually?
Just leave (commit or rollback) the transaction that holds the lock.
> By the way , My INFORMIX version is 7.22UC2.
> Thanks a lot.
>
HTH
--
Christian Knappke
The opinions stated above are my own and not necessarily those of my
employer.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.