notification and sql allocation updates