hi all,

please i need assistance.

thanks.

Netbackup controls multiple streams when it comes to file system backup. When it comes to database backups multiple stream's are controlled from the vendor built-in in backup utility  ( Oracle = RMAN, SAP = brbackup).

Take a look at Netbackup admin guide for Sybase page 48 to see how to configure multiple streams.

hi Nicolai,

i tried what was recommended. what i got was " the backup failed to backup the requested files(6)"

thank you.

I can't put Sybase admin on my CV. But in general  a status code 6 mean that the client side scrip exited with a non zero value. Try running the Sybase backup tool by hand a look out for errors. You may have a typo error.

hi Nicolai

i think i have gone thru it. can't seem to see anythin.

it used to work single stream or it never worked?

As Nicolai says, error 6 means something wrong with script.  Your DBA can usually sort that out. 

Can you post the output from the sybase backup utility ?

this is the script,

#***************************************************************************
# Replace /usr/sybase12 below with the actual Sybase home directory
#***************************************************************************

SYBASE=/sybase12

#***************************************************************************
# Replace SYBASE12 below with the actual name of the SQL Server
#***************************************************************************

SYBSERVER=ZENITHDB

#***************************************************************************
# Replace SYB_DB below with the actual name of your Sybase database
#***************************************************************************

DATABASE_NAME=phoenix

#***************************************************************************
# Replace syb_files below with your actual name of the NetBackup
# server Policy to be used to backup the directory with Sybase script files
#***************************************************************************
SYB_FILES_POLICY=sybase-zenetlive

#***************************************************************************
# Replace /usr/sybase12/scripts below with your actual path of the Sybase files
#***************************************************************************
SYB_FILES_DIR=/home/sybase

if [ ! -d "${SYBASE}"/ASE-12_0/ ]
then
#************** Sybase 11.9.2 or earlier *******************
ASE_QUAL=
OCS_QUAL=
else
#************** Sybase 12.0 ****************************
SYBASE_ASE=ASE-12_0; export SYBASE_ASE
SYBASE_OCS=OCS-12_0; export SYBASE_OCS
ASE_QUAL=/$SYBASE_ASE
OCS_QUAL=/$SYBASE_OCS
fi
echo "Started `date`"
SYBASE=$SYBASE; export SYBASE
# These environment variables are set by NetBackup
echo "SYBACKUP_SERVER = $SYBACKUP_SERVER"
echo "SYBACKUP_POLICY = $SYBACKUP_POLICY"
echo "SYBACKUP_SCHED = $SYBACKUP_SCHED"
echo "SYBACKUP_SCHEDULED = $SYBACKUP_SCHEDULED"
echo "SYBACKUP_USER_INITIATED = $SYBACKUP_USER_INITIATED"
RETURN_STATUS=0
#***************************************************************************
# Replace "database_dump" below with your actual NetBackup schedule name
# which is used for a full backup of the Sybase database.
#***************************************************************************
if [ "${SYBACKUP_SCHED}" = "full" ]
then
############# NetBackup has started a "database_dump" backup ##############
DUMP_TYPE=DATABASE
else
############# NetBackup has started a "transaction log" backup ##############
DUMP_TYPE=TRANSACTION
fi
#***************************************************************************
# Replace "Default-Application-Backup" below with your actual NetBackup
# Application Backup type schedule name for the Sybase database.
#***************************************************************************
echo dump $DUMP_TYPE $DATABASE_NAME to \"sybackup::-SERV $SYBACKUP_SERVER -POL
$SYBACKUP_POLICY -SCHED sybase_sched\" > ./syb_${DATABASE_NAME}_dump
#**************************************************************************

# Remove the '#' from the beginning of the line below if you are going to
# use multiple stripes for the backup. Repeat this line for each stripe.
# Replace "Default-Application-Backup" below with your actual NetBackup
# Application Backup type schedule name for the Sybase database.
# **************************************************************************
echo stripe on \"sybackup::-SERV $SYBACKUP_SERVER -POL $SYBACKUP_POLICY -SCHED
sybase_sched\" >> ./syb_${DATABASE_NAME}_dump
echo go >> ./syb_${DATABASE_NAME}_dump
echo stripe on \"sybackup::-SERV $SYBACKUP_SERVER -POL $SYBACKUP_POLICY -SCHED
sybase_sched\" >> ./syb_${DATABASE_NAME}_dump
echo go >> ./syb_${DATABASE_NAME}_dump
echo stripe on \"sybackup::-SERV $SYBACKUP_SERVER -POL $SYBACKUP_POLICY -SCHED
sybase_sched\" >> ./syb_${DATABASE_NAME}_dump
echo go >> ./syb_${DATABASE_NAME}_dump
#***************************************************************************
# Replace "manager" with your Sybase server Administrator's Password
#***************************************************************************
echo "$SYBASE$OCS_QUAL/bin/isql -Usa -Ppassword -I$SYBASE/interfaces -S$SYBSERVER <
./syb_${DATABASE_NAME}_dump"
$SYBASE$OCS_QUAL/bin/isql -Usa -Ppassword -I$SYBASE/interfaces -S$SYBSERVER <
./syb_${DATABASE_NAME}_dump
RETURN_STATUS=$?
if [ "${DUMP_TYPE}" = "DATABASE" ]
then
#
Initiate a backup of any file related to the Sybase database, such as script files.
echo "bpbackup -c $SYB_FILES_POLICY $SYB_FILES_DIR" /usr/openv/netbackup/bin/bpbackup -c $SYB_FILES_POLICY $SYB_FILES_DIR BPBACKUP_STATUS=$?
fi
if [ "$BPBACKUP_STATUS" -ne 0 ] then echo "" echo "bpbackup of $SYB_FILES_DIR returned $BPBACKUP_STATUS" fi
echo "Finished `date`"
echo "exit $RETURN_STATUS"
echo ""
exit $RETURN_STATUS

thank you.

What's the output - Is there any from of error messages or alike ?

Again, I am not a sybase admin, just a Netbackup one. So I can help with the Netbackup, but lost on the Sybase part.