Goran,

Thank you this will help quite a bit.

Thanks,

Dan S.


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
goc
Sent: Tuesday, September 25, 2007 3:57 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] SECOND TIME SENDING: multiple dsm.opt - dsm.sys
and tdpo.opt

hi,
you can use one dsm.sys file simply linking to $DSM_HOME/dsm.sys file
from your API directory
each client has to have own opt file

dsm.sys part example:

SERVERNAME ARIS62_tdpo
        COMMmethod         TCPip
        TCPPort            1500
        TCPServeraddress   axptsm01
        NodeName           ARIS62_tdpo
        Mailprog           /usr/bin/mail root
        PASSWORDACCESS     Prompt
        Schedlogname       /var/adm/dsmsched.ARIS62_tdpo
        Schedlogretention  14 D
        ERRORLOGNAM        /var/adm/dsmerror_ARIS62_tdpo.log
        errorlogretention  14 D
        QUERYSCHED      12
        MANAGEDSERVICES    schedule webclient
        memoryefficientbackup no
        ENABLELANFREE   no



SERVERNAME ARISAM_tdpo
        COMMmethod         TCPip
        TCPPort            1500
        TCPServeraddress   axptsm01
        NodeName           ARISAM_tdpo
        Mailprog           /usr/bin/mail root
        PASSWORDACCESS     Prompt
        Schedlogname       /var/adm/dsmsched.ARISAM_tdpo
        Schedlogretention  14 D
        ERRORLOGNAM        /var/adm/dsmerror_ARISAM_tdpo.log
        errorlogretention  14 D
        QUERYSCHED      12
        MANAGEDSERVICES    schedule webclient
        memoryefficientbackup no
        ENABLELANFREE   no

in /opt/tivoli/tsm/client/api/bin64 (or usr if on AIX) you must have 2
opt files
for each dsm.sys stanza one

example:

-rw-rw-rw-   1 root       sys             23 May 24 15:49
dsm_ARISAM_tdpo.opt
-rw-rw-rw-   1 root       sys             58 Jul 16 12:53
dsm_ARISAM_tdpo_sched.opt
-rw-rw-rw-   1 root       sys             29 Jul 16 12:53
dsm_ARIS62_tdpo.opt
-rw-rw-rw-   1 root       sys             29 Jul 16 12:53
dsm_ARIS62_tdpo_sched.opt

the *sched.opt 's are used for dsmcad type of scheduled rman/tdpo
backups

/opt/tivoli/tsm/client/api/bin64 # more dsm_ARISAM_tdpo.opt
SERVERNAME ARISAM_tdpo

/opt/tivoli/tsm/client/api/bin64 # more dsm_ARIS62_tdpo.opt
SERVERNAME ARIS62_tdpo

in /opt/tivoli/tsm/client/oracle/bin64 -->

/opt/tivoli/tsm/client/oracle/bin64 # ls -lrt ARIS*
-rw-rw-rw-   1 root       sys            764 Jul 16 13:04
ARIS62_tdpo.opt
-rw-rw-rw-   1 root       sys            764 Jul 16 13:05
ARISAM_tdpo.opt

content of this two -->

/opt/tivoli/tsm/client/oracle/bin64 # cat ARIS62_tdpo.opt

************************************************************************
***
* IBM Tivoli Storage Manager for Databases
* Data Protection for Oracle
*
* Sample tdpo.opt for the AIX Data Protection for Oracle 64bit
*********************************************************************

DSMI_ORC_CONFIG    /opt/tivoli/tsm/client/api/bin64/dsm_ARIS62_tdpo.opt

*DSMI_LOG           <dirname>

*TDPO_FS            orc9_db

*TDPO_NODE          <hostname>
TDPO_NODE          ARIS62_tdpo

*TDPO_OWNER         <username>

*TDPO_PSWDPATH      /opt/tivoli/tsm/client/oracle/bin64
TDPO_PSWDPATH      /home/oracle

TDPO_DATE_FMT      4
*TDPO_NUM_FMT       1
*TDPO_TIME_FMT      1

*TDPO_MGMT_CLASS_2   orcbackup
*TDPO_MGMT_CLASS_3   mgmtclass3
*TDPO_MGMT_CLASS_4   mgmtclass4

root@hppdb01:/opt/tivoli/tsm/client/oracle/bin64 # cat ARISAM_tdpo.opt

************************************************************************
***
* IBM Tivoli Storage Manager for Databases
* Data Protection for Oracle
*
* Sample tdpo.opt for the AIX Data Protection for Oracle 64bit
*********************************************************************

DSMI_ORC_CONFIG    /opt/tivoli/tsm/client/api/bin64/dsm_ARISAM_tdpo.opt

*DSMI_LOG           <dirname>

*TDPO_FS            orc9_db

*TDPO_NODE          <hostname>
TDPO_NODE          ARISAM_tdpo

*TDPO_OWNER         <username>

*TDPO_PSWDPATH      /opt/tivoli/tsm/client/oracle/bin64
TDPO_PSWDPATH      /home/oracle

TDPO_DATE_FMT      4
*TDPO_NUM_FMT       1
*TDPO_TIME_FMT      1

*TDPO_MGMT_CLASS_2   orcbackup
*TDPO_MGMT_CLASS_3   mgmtclass3
*TDPO_MGMT_CLASS_4   mgmtclass4

:end

the only diff is in DSMI_ORC_CONFIG and NODE_NAME parameter

you connect to each node with dsmc -se=arisam_tdpo or dsmc
-se=aris62_tdpo

for scheduling mulitple backups via dsmcad you have to add new stanza
in dsm.sys for each node with PASSWORDACCESS generate

and don't forget when generating passwords with "tdpoconf" into oracle
home directory to do it for each node used

important: make log files chmod 666 so oracle can write to them (the
easiest way) or rman/tdpo will fail with no precise explanation

dsmcad is started with NODENAME_tdpo_sched.opt -optfile parameter
because it MUST have PASSWORDACCESS generated before starting
scheduled operations

when everything seems to be configured, you MUST connect to node
manually with both optfile parameters - NODENAME_tdpo.opt and
NODENAME_tdpo_sched.opt TWO times just to make it sure ... *sched will
not ask you for password second time you'll log in (it will be used
for automatic schedules) but NODENAME_tdpo.opt will/must ask you for
password everytime since PASSWORDACCESS is PROMPT

have fun :-)

any questions? just ask here.

peace,
goran



On 9/24/07, Larry Clark <lclark01 AT nycap.rr DOT com> wrote:
> They are separate clients requiring separate opt files.
> ----- Original Message -----
> From: "Shaw, Dan" <DShaw AT TRIADFINANCIAL DOT COM>
> To: <ADSM-L AT VM.MARIST DOT EDU>
> Sent: Monday, September 24, 2007 10:23 AM
> Subject: [ADSM-L] SECOND TIME SENDING: multiple dsm.opt - dsm.sys and
> tdpo.opt
>
>
> I was wondering if anybody had answer to this question.
>
>
> Thanks,
>
> Dan
>
>
>
> Hello,
>
> I am fairly new with setting up the TSM product but I am learning very
> fast and I have a question.
>
> I noticed that the tdpo.opt file has an entry to point to the
following
> file for the Oracle piece of backing up Oracle via RMAN
>
> DSMI_ORC_CONFIG    /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
>
> There is also a dsm.sys file in the working directory of oracle which
is
> used but is the same as the standard UNIX backup dsm.sys located in
> another directory
>
> So my question is...
> Is there a need for multiple dsm.opt files and dsm.sys files or can
the
> Oracle / Unix and any other type of backup be consolidated into just
one
> version of these files.
>
> If the answer is yes do you have an example and or a web location to
> look at an example?
>
>
> Thank you ahead of time.
>
> Dan Shaw
>
>
>
>
> Daniel P. Shaw
> Triad Financial
> Pro-Tem Contractor
> dshaw AT triadfinacial DOT com
> Ext: 25106
> Ph: 714-799-5106
> Start Date: 08-13-2007
>