update mypil; transaction commit