pre-freeze-script.sql (Sybase)

if [ -f /sybase/sybase15.7/scripts/pre-freeze-script.out ]

 then

 rm -rf /sybase/sybase15.7/scripts/pre-freeze-script.out

 fi

 export SYBASE=/sybase/sybase15.7

 export SYBASE_SERVER=DBSERVE99

 $SYBASE/OCS-15_0/bin/isql -SKPNSYBASE -Usa -P -e -n -o /sybase/sybase15.7/scripts/pre-freeze-script.out << EOF

 select getdate()

 go

 quiesce database tag1 hold pubs2,pubs3,sybsystemdb,sybsystemprocs,model

 go

 select is_quiesced(4)

 go

 select is_quiesced(5)

 go

 quiesce database tag2 hold master

 go

 EOF