Transaction not available
Usha M Rao got error -256 (Transaction not available) using begin work and commit work. Paul Watson pointed to ontape -s, Chetan Anand said it happens when the database is not logged, and Daniel Racine quoted the documentation: start a transaction log, e.g. with START DATABASE name WITH LOG IN. A separate poster, rboucher, asked about intermittent error 25571 on IDS 9.20.UC2; that question went unanswered.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
When I use begin work and commit work,informix gives me error -256:Transaction not available.How can I set it ON? Usha
Check out ontape -s -[U|B] dbname
Posting the version of the database help:-))
Usha M Rao wrote:
>
> When I use begin work and commit work,informix gives me error
> -256:Transaction not available.How can I set it ON?
>
> Usha
--
Paul Watson #
WF Software Ltd # You are only young once
Tel: +44 1436 674729 # but you can be immature
Fax: +44 1436 678693 # for ever
www.wfsoftware.com #
Every once in a while, we get a rash of error 25571s on Informix Dynamic
Server 2000 Version 9.20.UC2.
I didn't find other messages on usenet which referenced this error
number.
'finderr' shows a large number of possible options for this message:
1) Check the value of the USERTHREADS parameter
I don't find this parameter in my config file and I found a reference
on usenet that it was obsolete.
2) value of the userthreads field of the NETTYPE parameter
I config file shows this:
NETTYPE tlitcp, 3, 1024, CPU
Is there a way to confirm that this would be the problem
triggering this symptom?
3) out of system resources to start a thread.
How else would this manifest itself? /var/adm/messages??
4) client application permissions problem.
5) GLS structure request failed
Not doing any explicit GLS calls.
6) unix group membership problems
The group file hasn't changed, and the problem is intermittent.
Basically, I'm trying to figure out which of these 6 things
is happening. It would be nice if they would split out the
error code, or provide some sub-code. Is there such a thing
(that isn't referenced in the finderr doc)?
Thanks in advance.
Sent via Deja.com http://www.deja.com/
Before you buy.
Usha: This typically surface when database is not logged. Rgds Usha M Rao wrote: > When I use begin work and commit work,informix gives me error > -256:Transaction not available.How can I set it ON? > > Usha
Usha M Rao a écrit: > > When I use begin work and commit work,informix gives me error > -256:Transaction not available.How can I set it ON? > > Usha here is the documentation for error 256: "You cannot begin a transaction in this database because it does not have a transaction log. In order to support transactions, you must start a transaction log. With the INFORMIX-OnLine Dynamic Server, the OnLine administrator uses the Databases screen of the Logical Logs menu of DB-Monitor or ON-Monitor to start a transaction log. With other database servers, use the START DATABASE statement." So, your start database statement should be something like : START DATABASE database-name WITH LOG IN 'pathname'; -- Daniel Racine Téléphone : (819) 821-5510 Analyste-programmeur Ville de Sherbrooke Courriel : daniel.racine@ville.sherbrooke.qc.ca