如何查看某个库的日志方式

fenglx332

同一实例下有两个库a和b，我要实现登录a库时能够访问b库中数据，查资料显示可以用select * from b:tablename ，报下列错误 569: Cannot reference an external database with logging，
错误意思：569 Cannot reference an external database with logging.
This statement refers to a database other than the current database. However, the current database does not use transaction logging, and the external one does. This action is not supported; the databases that are used in a single transaction must all use logging or all not use it.
又找资料可以修改a和b库为相同的日志方式，可以用ontape -s -B dbname 改为带缓冲方式
但是我想看看现在a、b库的日志方式？怎么看

tryhard

...........

xmwinforever

onmonitor-->status-->database   看显示结果的最后一个字段，包括U(unbuffered log)   B(buffered log)   N(nolog)

fenglx332

xmwinforever   thanks

liaosnet

在sysmaster中执行
select * from sysdatabases

name         dbae   
partnum      6291520
owner        informix
created      03/21/2007
is_logging   1
is_buff_log  1
is_ansi      0
is_nls       0
flags        3

is_logging,is_buff_log,is_ansi,表示日志类型。

ccb_bee

用onmonitor可以看