SEO

#1 (**permalink**) 04-20-2008, 06:50 AM

When I try to set my informix 7.31UD5 database in 'read commited only'
mode
by commend: 'ontape -s0 -B databasename' the next error occurs:
"Incorrectly built binary which accesses errno, h_errno or _res
directly. Needs to be fixed.
Server is in an incompatible state or user authentication failed.

Program over."
What is this and why and what to do? Can You help?

#2 (**permalink**) 04-20-2008, 06:51 AM

The syntax for changing logging mode of a database with ontape is:
ontape -s -L 0 -B|-U|-A|-N database

-B = buffered logging
-U = unbuffered logging
-A = ansi mode (incl. unbuffered logging)
-N = no logging

Isolation level 'Committed Read' is default for buffered and unbuffered
logging mode.
In ansi mode 'Repeatable Read' is default isolation level.
'Dirty Read' is default for no logging databases.

You can change isolation level using SQL command 'SET ISOLATION TO
level' or for ansi mode databases 'SET TRANSACTION'.

If onbar is used for backup it is recommended to use ondblog to change
logging mode. You cannot change logging mode for an ansi mode database.

rados1234 wrote:
> When I try to set my informix 7.31UD5 database in 'read commited only'
> mode
> by commend: 'ontape -s0 -B databasename' the next error occurs:
> "Incorrectly built binary which accesses errno, h_errno or _res
> directly. Needs to be fixed.
> Server is in an incompatible state or user authentication failed.
>
> Program over."
> What is this and why and what to do? Can You help?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

ontape -s0 -B problem