Re: Row and Byte locks
Satish,
According to Online Adminstrator's Guide (ver 7.2, vol 1) the byte lock
exists solely for
rollforward and rollback execution and is generated only if VARCHAR data
types is being used.
A byte lock is created only in a logging database.
A byte lock appears in onstat -k ouput only if row level locking is being
used.
--
Rajiv Jhaveri
S.Sathish wrote:
} Hi,
} if
} row lock - a lock placed on a single data row
} Byte lock - a lock placed on a row containing varchars
} Then, What does " The byte lock will only lock the portion of the
} row that is being modified " mean?
}
} - Training Course on Sys Admn -1 (cindy dowling , Elizabeth Suto)
}
}
} ******************************************************************************
}
} S.Sathish
} CMC Ltd.,Bangalore - INDIA
} email :ssathish@cmcbang.ernet.in
} ******************************************************************************