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

Loading...