AW: BACKINT for SAPDB and BACKINT for Oracle

Hello Tilo,

I verified, that the environment variable BI_BACKUP is set correctly to FULL
or ARCHIVE by SAPDB according to the type of backup (data or logs).

I contacted IBM support and at last spoke with an IBM developer who told me,
that the environment variable BI_CALLER is also part of SAP's BACKINT for
Oracle interface description and is usually set by the calling SAP programs
BRARCHIVE.EXE and BRBACKUP.EXE to the appropriate values "BRARCHIVE" or
"BRBACKUP".

IBM's implementation relies on the value of the variable BI_CALLER. If
BI_CALLER is set to "BRARCHIVE", TSM assumes that it should perform a LOG
backup and stores the files in the LOG management class. If BI_CALLER is set
to "BRBACKUP" or if the variable is empty, it assumes a DATA backup and
stores the files in the DATA management class.

I verified this by setting the BI_CALLER variable in the parameter file of
the SAPDB adapter program to "BRARCHIVE". TSM stores the files as LOGs,
regardless of whether BI_BACKUP is set to "FULL" or "ARCHIVE".

Why does the BI_CALLER variable default to empty in the SAPDB adapter
program, although SAP's BACKINT for Oracle interface specification (as of
May 2003) includes the use of the BI_CALLER variable as mentioned above?

Is there a way to set the BI_CALLER variable dynamically during runtime
through the SAPDB adapter program?


Andreas Vollmer
IBM Certified Deployment Professional
Tivoli Storage Manager 5.2


-----Ursprüngliche Nachricht-----
Von: Heinrich, Tilo [mailto:tilo.heinrich@xxxxxxx] 
Gesendet: Montag, 29. November 2004 11:23
An: maxdb@xxxxxxxxxxxxxxx
Cc: Vollmer Andreas
Betreff: RE: BACKINT for SAPDB and BACKINT for Oracle

Hello Andreas,

SAP DB and MaxDB are setting the environment variable BI_BACKUP to the
values FULL, PARTIAL and ARCHIVE to give Backint for SAPDB/MaxDB and
Backint for Oracle a hint about the type of backup. You should be able
check that, by replacing your Backint for Oracle temporarily with a
program, that lists the environment. If you can verify that BI_BACKUP is
set to different values for data and log backups, please research what
is necessary, such that TSM's Backint for Oracle uses these hints.

Best regards,
Tilo Heinrich
SAP Labs Berlin

>-----Original Message-----
>From: Vollmer Andreas [mailto:Andreas.Vollmer@xxxxxxxxxx] 
>Sent: Friday, November 26, 2004 9:50 AM
>To: 'maxdb@xxxxxxxxxxxxxxx'
>Subject: BACKINT for SAPDB and BACKINT for Oracle
>
>
>Hello,
> 
>I have successfully connected BACKINT for SAPDB to BACKINT for 
>Oracle (TSM)
>through the SAPDB Adapter Program. We are using SAPDB 7.3 
>Build 048 and IBM
>Tivoli Storage Manager for ERP Version 3.3.4.
> 
>I have created two different backup mediums for DATA and LOGS 
>(BACK_Dat and
>BACK_Log). The BACKINT for Oracle (TSM Implementation) is also able to
>separate DATA and LOGS in so called Management Classes to 
>store DATA and
>LOGS on different TSM volumes (in different storage groups). 
> 
>It seems that the BACKINT for SAPDB program (or SAPDB adapter program)
>doesn't pass the information whether it's a complete or a log 
>backup to the
>BACKINT for Oracle Interface. All backups (DATA and LOGS) are 
>stored in the
>DATA management class of Tivoli Storage Manager.
> 
>Does anyone know, if there is a possibility to separate these 
>backup types
>and pass this information to BACKINT for Oracle?
> 
> 
>Andreas Vollmer
>IBM Certified Deployment Professional
>Tivoli Storage Manager 5.2
> 
>

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx