# 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...