Tuesday, September 11, 2012

Sybase Backup Schedule



#!/bin/ksh
###############################Loading Sybase Enviroment variables
#
# Sybase Product Environment variables
#
SYBASE_ASE="ASE-15_0"
export SYBASE_ASE
PATH="/usr/sybase/ASE-15_0/bin:/usr/sybase/ASE-15_0/install":$PATH
export PATH
LD_LIBRARY_PATH="/usr/sybase/ASE-15_0/lib":$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
LD_LIBRARY_PATH_64="/usr/sybase/ASE-15_0/lib":$LD_LIBRARY_PATH_64
export LD_LIBRARY_PATH_64
SYBASE="/usr/sybase"
export SYBASE
SYBASE_OCS="OCS-15_0"
export SYBASE_OCS
PATH="/usr/sybase/OCS-15_0/bin":$PATH
export PATH
LD_LIBRARY_PATH="/usr/sybase/OCS-15_0/lib:/usr/sybase/OCS-15_0/lib3p64:/usr/sybase/OCS-15_0/lib3p":$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
INCLUDE="/usr/sybase/OCS-15_0/include":$INCLUDE
export INCLUDE
LIB="/usr/sybase/OCS-15_0/lib":$LIB
export LIB
LD_LIBRARY_PATH_64="/usr/sybase/OCS-15_0/lib:/usr/sybase/OCS-15_0/lib3p64:/usr/sybase/OCS-15_0/lib3p":$LD_LIBRARY_PATH_64
export LD_LIBRARY_PATH_64
SYBASE_JRE6_32="/usr/sybase/shared/JRE-6_0_6"
export SYBASE_JRE6_32
SYBASE_JRE6_64="/usr/sybase/shared/JRE-6_0_6"
export SYBASE_JRE6_64
SYBASE_JRE6="/usr/sybase/shared/JRE-6_0_6"
export SYBASE_JRE6
PATH="/usr/sybase/UAF-2_0/bin":$PATH
export PATH
SYBASE_UA="/usr/sybase/UAF-2_0"
export SYBASE_UA
SYBASE_PLATFORM="sunx"
export SYBASE_PLATFORM
PATH="/usr/sybase/DBISQL/bin":$PATH
export PATH
SCROOT="/usr/sybase/shared/sybcentral600"
export SCROOT
PATH="/usr/sybase/ASEP/bin":$PATH
export PATH
echo $sybaseTH="/usr/sybase/RPL-15_0/bin":$PATH
export PATH
SYBASE_WS="WS-15_0"
export SYBASE_WS
PATH="/usr/sybase/ASE-15_0/jobscheduler/bin":$PATH
export PATH
SYBROOT="/usr/sybase"
export SYBROOT
##################################


isql -Usa -Ppassword -Sservername  << EOF
print "Dumping db1 database"
print "--------------------------------------"
go

dump database databasename to '/usr/sybase/backup/databasedumpfile'  at backupservername_BS
go

No comments :

Post a Comment