Tdpo utility errors

[kurki]

Hi All,

While running "tdpoconf showenv -tdpo_optfile=tdpo.opt", getting the below error


IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 5, Level 2.0
(C) Copyright IBM Corporation 1997, 2009. All rights reserved.


ANS1217E (RC409) Server name not found in System Options File


and for "tdposync syncdb" error is


IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 5, Level 2.0
(C) Copyright IBM Corporation 1997, 2009. All rights reserved.


ANU2534E Option file error.


any ideas pls.

OS: IBM AIX


Thanks

[moon-buddy]

Enter the SERVERNAME <server_name> found in the dsm.sys for the TDP portion in tdpo.opt file.

[meurnt]

soft link missing for dsm.sys and *_ora.opt file to under /usr/tivoli/tsm/client/api/bin
Create it and check the status

Thanks
Krish
https://www.tsmguide.co.cc

[kurki]

Hi,

checked the above things but seems everything is ok

here I am pasting dsm.sys, dsm.opt and tdpo.opt conf files.


hostname[/usr/tivoli/tsm/client/api/bin64]$ cat tdpo.opt
TDPO_NODE servrename_oracle
DSMI_LOG /usr/local/log
TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin64


==============
hostname[/usr/tivoli/tsm/client/api/bin64]$ cat tdpo.opt
TDPO_NODE servername_oracle
DSMI_LOG /usr/local/log
TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin64

=============

hostname[/usr/tivoli/tsm/client/api/bin64]$ cat dsm.opt
servername TSM_servername
language AMENG
numberformat 1
tapeprompt no
timeformat 1
===============

can you please have a look and correct me


Thanks

[kurki]

Hi,

There is only one soft link under /usr/tivoli/tsm/client/api/bin64

lrwxrwxrwx 1 root system 33 Jul 19 18:06 en_US -> /usr/tivoli/tsm/client/lang/en_US


FYI.... OS is 64 bit so we should user bin64 instead bin.


Thanks

[moon-buddy]

Hi,

checked the above things but seems everything is ok

here I am pasting dsm.sys, dsm.opt and tdpo.opt conf files.


hostname[/usr/tivoli/tsm/client/api/bin64]$ cat tdpo.opt
TDPO_NODE servrename_oracle
DSMI_LOG /usr/local/log
TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin64


==============
hostname[/usr/tivoli/tsm/client/api/bin64]$ cat tdpo.opt
TDPO_NODE servername_oracle
DSMI_LOG /usr/local/log
TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin64

=============

hostname[/usr/tivoli/tsm/client/api/bin64]$ cat dsm.opt
servername TSM_servername
language AMENG
numberformat 1
tapeprompt no
timeformat 1
===============

can you please have a look and correct me


Thanks

Where is dsm.sys?

[kurki]

Sorry.. Missed it
Please find beow


hostname[/usr/tivoli/tsm/client/api/bin64]$ cat dsm.sys
SErvername TSM_servername_oracle
COMMmethod TCPip
TCPPort 1500
TCPServeraddress 194.194.2.45
TCPNodelay yes
TCPWindowsize 64
TCPBuffsize 32
TXNBytelimit 2048
COMPRESSION NO
SCHEDMODe POlling
QUERYSCHedperiod 1
RETRYPeriod 5
MAXCMDRetries 1
passworddir /home/oracle/TSM
passwordaccess generate
schedlogname /usr/local/log/dsmsched.log
schedlogretention 3 d
errorlogname /usr/local/log/dsmerror.log
errorlogretention 3 d
nodename hostname_ORA



Thanks

[moon-buddy]

Sorry.. Missed it
Please find beow


hostname[/usr/tivoli/tsm/client/api/bin64]$ cat dsm.sys
SErvername TSM_servername_oracle
COMMmethod TCPip
TCPPort 1500
TCPServeraddress 194.194.2.45
TCPNodelay yes
TCPWindowsize 64
TCPBuffsize 32
TXNBytelimit 2048
COMPRESSION NO
SCHEDMODe POlling
QUERYSCHedperiod 1
RETRYPeriod 5
MAXCMDRetries 1
passworddir /home/oracle/TSM
passwordaccess generate
schedlogname /usr/local/log/dsmsched.log
schedlogretention 3 d
errorlogname /usr/local/log/dsmerror.log
errorlogretention 3 d
nodename hostname_ORA

Thanks

Looks like you have only one stanza. If you are running TDP for Oracle, you must have the BA client installed (DSM.sys on stanza 1) and TDP for Oracle on stanza 2.

In your dsm.sys above: SErvername TSM_servername_oracle this entry does not make sense as this should match what the OPT files (tdpo.opt) points to.

[kurki]

Hi,

Tsm_servername which is mentioned in dsm.sys and tdpo.opt both are same and as we have db2 and oracle db's installed in the same server we differentiated using _oracle at the end in dsm.sys.

Thanks,

[moon-buddy]

Hi,

Tsm_servername which is mentioned in dsm.sys and tdpo.opt both are same and as we have db2 and oracle db's installed in the same server we differentiated using _oracle at the end in dsm.sys.

Thanks,

Does not seem correct. Again, you need two stanzas - one for the BA client, and the other for TDP.

Here is how the dsm.sys looks:

Servername TSM_server <-- this is stanza 1
Nodename Server1
...
...

Servername TDP_server <-- this is stanza 2
Nodename Server1_ora
...
...

TDPO.opt

Servername TDP_server

[kurki]

Hi,

I do not see any this type of setting in other server where we have this setup (like 2 databases in the same server)
but It is working fine on another server.


Thanks,