DataBase Log Status...
Stefano Frignani got Invalid logging change to dbname when changing logging on a database made by dbimport with ontape -s -B. Brett Randall suggested ontape -s -L 0 -B dbname and querying sysdatabases for log status. It still failed, and Brett advised checking the current logging mode and the database name spelling. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi All,
We try to change log to database imported by dbimport 'd dbspace dbname
ontape 's 'B dbname, but we receive the follow message:
'Invalid logging change to dbname'.
How can we solve the problem?
Another question:
How can we know the log state of several databases?
Thank in advance, Stefano Frignani.
Stefano Frignani wrote:
>
> Hi All,
>
> We try to change log to database imported by dbimport d dbspace dbname
> ontape s B dbname, but we receive the follow message:
> Invalid logging change to dbname.
> How can we solve the problem?
Use :-
ontape -s -L 0 -B dbname
>
> Another question:
> How can we know the log state of several databases?
database sysmaster;
select * from sysdatabases;
>
> Thank in advance, Stefano Frignani.
Brett Randall
I test your solution, but I receive error again.
Bye, Stefano Frignani.
>
>Use :-
>
>ontape -s -L 0 -B dbname>
>Brett Randall
Stefano Frignani wrote:
>
> I test your solution, but I receive error again.
Then check :-
1) The current logging mode of the database.
2) That you have spelt the database name correctly.
Brett Randall
>
> Bye, Stefano Frignani.
>
> >
> >Use :-
> >
> >ontape -s -L 0 -B dbname> >
> >Brett Randall