Online message flags

Online Message log flags Diane Telford writes > > Does anyone know what the "us" and "flags" values are trying to tell me? > Other values for the flags that I have seen are a01, 2a01, 4104, 20001, > and 1. I think that the flags can be interrperted as follows 0001 user structure in use 0002 waiting for a semaphore 0004 waiting for a lock 0008 waiting for a buffer 0010 waiting for a checkpoint 0020 in read rsam call 0040 in write rsam call 0080 waiting for a long transaction 0100 Turbo monitor user 0200 in a transaction 0400 process doing a rollback 0800 process in critcal section 1000 deamon process 2000 begin work log record on log 4000 archiving 8000 cleanup dead process Therefore a01 is a user process waiting for a log transaction attempting a read 2a01 is a user process waiting for a log transaction attempting a read where part of the tranaction is already on the logical log 4104 A user running Tbmonitor performing an archive and waiting for a lock 20001 ???? Regards Ken +-------------------------------------------------------------------+ | Ken Woghiren (DBA - Charles Taylor & Co Ltd) | | | | Email: kenw@cix.compulink.co.uk | | Snail: World Trade Centre, London E1 9UN ,ENGLAND | | Voice: + 44 71 522 7466 | +-------------------------------------------------------------------+