pre-freeze-script.sql (Sybase)

Updated

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