Hi,

can someone please confirm is this is correct:

Sybase transaction flow:

When any update requeted:

data / index pages gets read from disk to data cache.

pages gets updated in data cache

here I have a question as syslogs changes are done in data cache as well or its on disk ?

Also, syslogs will have only old entry or both old and new.. I guess it will have both, please confirm.

changes to logs also recorded.

modified data pages from memory will be written to the disk irrespective of commit <-- this is when checkpoint occurs or data cache needs to be freed up.

Thanks,
Ram.