TSM TDP for ERP DB 2 Can not find configuration files ?q

hungng89

ADSM.ORG Member
Joined
May 25, 2010
Messages
115
Reaction score
2
Points
0
Location
VietNam
PREDATAR Control23

Hi everyone

I am already done TSM BA Client and TSM Storage Agent . I can backup via SAN ok without failure.

After that i install TSM TDP for ERPDB2.

When i try to update the password for backom
The error appeared as below

===============================================================================
Data Protection for SAP(R) - Backup Object Manager

- Version 6, Release 1, Modification 0 Level 0 for AIX LF 64-bit -
Build: 358 compiled on Nov 4 2008
(c) Copyright IBM Corporation, 1996, 2008, All Rights Reserved.
===============================================================================

BKI8540I: Using ProLE at vthmtxerp1:tdpr3db264
BKI8558I: Setting TSM password for partition 'NODE0000' on host 'VTHMTXERP1'.
BKI0049I: Please enter password for node on server 10.50.10.78:
BKI0052E: Password verification for node on server 10.50.10.78 failed.
BKI5001E: Tivoli Storage Manager Error:
Server not found in configuration file.
BKI8512I: Return code is: 2

The env of db2 are correctly set to the opt file
So i think the problem is with my opt file

/usr/tivoli/tsm/client/api/bin64/dsm.opt
dsm.opt

servername tsmserver
/usr/tivoli/tsm/client/api/bin64/dsm.sys

servername tsmserver
commmethod tcpip
tcpport 1500
tcpserveraddress 10.50.10.78

nodename vthmtxerp1
passwordaccess generate
managedservices webclient schedule
httpport 1581

enablelanfree yes
lanfreecommmethod tcpip
lanfreetcpserveraddress 127.0.0.1
lanfreetcpport 1502

Would you mind give me some of your advices :D
Thanks and best regards
 
PREDATAR Control23

Hi ilovetsm
Below is my initQAS.utl
#--------------------------------------------------------------------------
#
# Data Protection for SAP (R) interface for DB2 UDB
#
# Sample profile for Data Protection for SAP (R) Version 5.4
#
#--------------------------------------------------------------------------
#
# See the 'Data Protection for SAP (R) Installation &
# User's Guide' for a full description.
#
# For a comment symbol the character '#' can be used.
# Everything following this character will be interpreted as comment.
#
# Data Protection for SAP (R) accesses its profile
# in "read only" mode. All variable parameters like passwords, date of
# last password change, current version number will be written into the file
# specified with the CONFIG_FILE parameter. The passwords will be encrypted.


#--------------------------------------------------------------------------
# Prefix of the 'Backup ID' which is used for communication with
# the SAP-DB2 Administration Tools and stored in the description field of
# the Tivoli Storage Manager archive function.
# Maximum 6 characters.
# Default: none.
#--------------------------------------------------------------------------
BACKUPIDPREFIX QAS___


#--------------------------------------------------------------------------
# Number of parallel sessions to be established.
# Note: This number must not exceed the number of tape drives simultaneously
# available to the node on the Tivoli Storage Manager servers to be accessed.
# The valid range of MAX_SESSIONS is from 1 and 32.
# Default: none.
#--------------------------------------------------------------------------
MAX_SESSIONS 1 # Tivoli Storage Manager client sessions


#--------------------------------------------------------------------------
# Number of backup copies of the DB2 log files.
# The valid range of REDOLOG_COPIES is from 1 to 9.
# Default: 1.
#--------------------------------------------------------------------------
#REDOLOG_COPIES 2


#--------------------------------------------------------------------------
# Specifies the block size for disk I/O (in bytes).
# The default values have been chosen from our performance experiments in
# standard hardware environments.
# The valid range of BUFFSIZE is from 4KB to 32MB.
# Default: 131072 (128 KB) on UNIX, 32768 (32 KB) on Windows.
#--------------------------------------------------------------------------
BUFFSIZE 131072 # block size in bytes


#--------------------------------------------------------------------------
# This optional parameter controls how Data Protection for SAP(R) uses
# the internal buffers for transferring data during a backup.
# Valid values: SIMPLE | PREVENT | AUTO
# Default: SIMPLE
#--------------------------------------------------------------------------
#BUFFCOPY AUTO


#--------------------------------------------------------------------------
# Name of a program to be called before the backup task is started.
# Default: none.
#--------------------------------------------------------------------------
#FRONTEND pgmname parameterlist


#--------------------------------------------------------------------------
# Name of a program to be called after the backup task is completed.
# Default: none.
#--------------------------------------------------------------------------
#BACKEND pgmname parameterlist


#--------------------------------------------------------------------------
# Maximum number of data base backup versions to be kept.
# Note: Version control by Data Protection for SAP (R) is only activated
# only activated if the parameter MAX_VERSION is not 0.
# The valid range of MAX_VERSIONS is from 0 to 9999.
# A value of 0 means no versioning.
# Default: 0, no versioning.
#--------------------------------------------------------------------------
#MAX_VERSIONS 4


#--------------------------------------------------------------------------
# Specifies whether a null block compression of the data is to be performed
# before transmission to Tivoli Storage Manager.
# Although RL compression introduces additional CPU load, throughput can be
# improved when the network is the bottleneck. RL compression in Data
# Protection for SAP(R) should not be used together with
# Tivoli Storage Manager API compression.
# Default: NO
#--------------------------------------------------------------------------
#RL_COMPRESSION YES # NO is default


#--------------------------------------------------------------------------
# Controls generation of a trace file.
# Note: We recommend using the trace function only in cooperation with
# Data Protection for SAP (R) support.
# Default: OFF.
#--------------------------------------------------------------------------
#TRACE OFF
#TRACEFILE /db2/C21/sqllib/log/tdpr3.trace


#--------------------------------------------------------------------------
# Denotes the maximum size of the trace file in KB.
# If not specified, the trace file size is unlimited.
#--------------------------------------------------------------------------
#TRACEMAX <max. size> # trace file size in KB

#--------------------------------------------------------------------------
# Specify the full path of the configuration file.
# Default: none.
#--------------------------------------------------------------------------
CONFIG_FILE /db2/QAS/tdp_r3/%DB2NODE/initQAS.bki


#--------------------------------------------------------------------------
# Denotes if Data Protection for SAP (R) shall send error/status
# information to a Tivoli Storage Manager server.
# The servername must match one of the servers listed in a SERVER statement.
# Valid values for verbosity are ERROR | WARNING | DETAIL.
# Default: none.
#--------------------------------------------------------------------------
#LOG_SERVER servername [verbosity]
#LOG_SERVER server_a ERROR


#**************************************************************************
# Statement for servers and paths.
# Multiple servers may be defined.
#**************************************************************************


SERVER tsmserver
SESSIONS 2 # Maximum number of sessions
# to server_a
PASSWORDREQUIRED YES # Use a password
BRBACKUPMGTCLASS vthmtxerp1bamc
BRARCHIVEMGTCLASS vthmtxerp1acmc
TCP_ADDRESS 10.50.10.78
# TCP_ADDRESS 192.168.1.1 # IP address of network interface
# on server_a
# Overrides IP address of dsm.sys
# USE_AT 0 1 2 3 4 5 6 # Days when server_a is used for
# backup
#**************************************************************************
# USE_AT : 0=Su 1=Mo 2=Tu 3=We 4=Th 5=Fr 6=Sa
# The valid range of USE_AT is from 0 to 6.
# Default: all days
#**************************************************************************

#SERVER server_b # Servername, as defined in dsm.sys
# SESSIONS 2 # Maximum number of sessions
# to server_b
# PASSWORDREQUIRED YES # Use a password
# ADSMNODE NODE # Tivoli Storage Manager Nodename
# BRBACKUPMGTCLASS MDB # Mgmt-Classes for database backup
# BRARCHIVEMGTCLASS MLOG1 MLOG2 # Mgmt-Classes for redo log backup
# TCP_ADDRESS 192.168.1.1 # IP address of network interface
# on server_b
# Overrides IP address of dsm.sys
# USE_AT 0 1 2 3 4 5 6 # Days when server_b is used for
# backup
#**************************************************************************
# USE_AT : 0=Su 1=Mo 2=Tu 3=We 4=Th 5=Fr 6=Sa
# Default: all days
#**************************************************************************



#--------------------------------------------------------------------------
# End of profile


END
 
PREDATAR Control23

Hi everyone

I correct my early issue ( due to incorrect init<sid>.UTL )
, and face this new one :(
===============================================================================
Data Protection for SAP(R) - Backup Object Manager

- Version 6, Release 1, Modification 0 Level 0 for AIX LF 64-bit -
Build: 358 compiled on Nov 4 2008
(c) Copyright IBM Corporation, 1996, 2008, All Rights Reserved.
===============================================================================

BKI8637I: Full offline backup of 'QAS' started ...
SQL2062N An error occurred while accessing media "VENDOR". Reason code:
"11".
BKI8634E: Backup command failed due to an error.
BKI8512I: Return code is: 605
my db2qas
user profile
setenv XINT_PROFILE /db2/QAS/tdp_r3/initQAS.utl
setenv TDP_DIR /db2/QAS/tdp_r3
setenv DB2_VENDOR_LIB /usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a
setenv DSMI_CONFIG /usr/tivoli/tsm/client/api/bin64/dsm.opt
setenv DSMI_DIR /usr/tivoli/tsm/client/api/bin64
setenv DB2_VENDOR_INI /db2/QAS/tdp_r3/vendor.env
export XINT_PROFILE=/db2/QAS/tdp_r3/initQAS.utl
export TDP_DIR=/db2/QAS/tdp_r3
export DB2_VENDOR_LIB=/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a
export DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin64/dsm.opt
export DSMI_DIR=/usr/tivoli/tsm/client/api/bin64
export DB2_VENDOR_INI=/db2/QAS/tdp_r3/vendor.env

Do you have any suggest on this issue ?
 
PREDATAR Control23

Hi

In the Install guide it states

Error message: BKI5001E: Tivoli Storage Manager Error: Server not found in configuration file.
The TSM Server from the init<SID>.utl does not match with the one specified in the used dsm.sys (on UNIX or Linux ).

From looking at your files the tsmserver looks the same so I'm not sure what to suggest now.

What does you vendor.env file look like ?

Cheers
 
PREDATAR Control23

HI ilovetsm
I correct the first issue and it was what you have just suggest .
After that when i try to start my back up i face the problem:

SQL2062N An error occurred while accessing media "VENDOR". Reason code:
"11".

I google a lot and find many user face the same reason code but many different issue .
About my

When seeing tdpdb2log file

BKI8806I: Data Protection for SAP(R) 6.1.0.0 (358) Nov 4 2008
BKI2027I: Using TSM-API version 6.1.0.0 (compiled with 5.3.0.0).
BKI8816I: DB2 version 'SQL09018' detected.

BKI8800I: The command is: BACKUP
BKI8801I: Time: 2010-08-13-15.51.29.0312 --- PID: 8978450
BKI8822I: Configuration parameter(s):
TDP_DIR=/db2/QAS/tdp_r3
XINT_PROFILE=/db2/QAS/tdp_r3/initQAS.utl
CALLER=BACKOM
BKI8803I: The DB2 image size for this session is about '124.371 GB'.
BKI7049I: The default for environment variable PROLE_PORT will be used.
BKI1216E: There are no backup management classes available.
BKI1223W: A Problem occurred during send of performance data to the Administration Assistant.
BKI7053E: Service setup failed due to previous error.
BKI8810I: Cleaning up resources of process 8978450.

BKI8800I: The command is: DELETE
BKI8822I: Configuration parameter(s):
TDP_DIR=/db2/QAS/tdp_r3
XINT_PROFILE=/db2/QAS/tdp_r3/initQAS.utl
CALLER=BACKOM
BKI8801I: Time: 2010-08-13-15.51.37.0851 --- PID: 7143428
BKI8819I: The TSM objects matching with mask 'db2qas.QAS.0.NODE0000.20100813155127.*' will be deleted.
BKI8812I: Committed TSM sessions of this backup run will be deleted.
BKI1216E: There are no backup management classes available.
BKI1223W: A Problem occurred during send of performance data to the Administration Assistant.
BKI7053E: Service setup failed due to previous error.
BKI8817I: No corresponding committed TSM session(s) found. Nothing will be deleted.
BKI8813E: Error deleting committed TSM sessions.
BKI8810I: Cleaning up resources of process 7143428.
It said that i don't thave backup management class available . I'm stuck in this step
 
PREDATAR Control23

Is this management class definitely defined in the domain that the node is registered to

>>nodename vthmtxerp1
>>BRBACKUPMGTCLASS vthmtxerp1bamc
 
PREDATAR Control23

HI ilovetsm
Below is my query mgmt result
I defined it already
tsm: TSM>q mgmt

Policy Policy Mgmt Default Description
Domain Set Name Class Mgmt
Name Name Class ?
--------- --------- --------- --------- ------------------------
VTHMTXER- ACTIVE VTHMTXER- Yes
P1_DM P1_CM
VTHMTXER- STANDARD VTHMTXER- No
P1_DM P1ACMC
VTHMTXER- STANDARD VTHMTXER- No
P1_DM P1BAMC
VTHMTXER- STANDARD VTHMTXER- Yes
P1_DM P1_CM
 
PREDATAR Control23

Hi

You "active" policyset for that domain has a mgmtclass of vthmtxerp1_cm

It looks like you have defined vthmtxerp1bacm but not activated the standard policyset. SO you need to do

activate policyset vthmtxerp1_dm standard

Cheers
 
PREDATAR Control23

Hi ilovetsm

I run the command below

tsm: TSM>activate policyset vthmtxerp1_dm standard

Do you wish to proceed? (Yes (Y)/No (N)) y
ANR1514I Policy set STANDARD activated in policy domain VTHMTXERP1_DM.

tsm: TSM>

But the issue just still exist it saying it don't have any management classes avaiable

BKI1216E: There are no backup management classes available.
 
PREDATAR Control23

Hi

In the mgmtclass have you got a archive copygroup defined?

q copygroup VTHMTXERP1_DM active * t=a f=d

If not you will need to define one.

See http://www-01.ibm.com/support/docvi...VN&uid=swg21266971&loc=en_US&cs=UTF-8&lang=en

Cheers


Hi ilovetsm
I just ran the below commands
tsm: TSM>q copygroup vthmtxerp1_dm active * f=d
Session established with server TSM: Windows
Server Version 6, Release 1, Level 2.0
Server date/time: 08/13/2010 17:26:43 Last access: 08/13/2010 16:38:34


Policy Domain Name: VTHMTXERP1_DM
Policy Set Name: ACTIVE
Mgmt Class Name: VTHMTXERP1ACMC
Copy Group Name: STANDARD
Copy Group Type: Backup
Versions Data Exists: 2
Versions Data Deleted: 1
Retain Extra Versions: 30
Retain Only Version: 60
Copy Mode: Modified
Copy Serialization: Shared Static
Copy Frequency: 2
Copy Destination: VTHMTXERP1_STG
Table of Contents (TOC) Destination: VTHMTXERP1_STG
Last Update by (administrator): ADMIN
Last Update Date/Time: 08/13/2010 15:49:10
Managing profile:
Changes Pending: No

Policy Domain Name: VTHMTXERP1_DM
Policy Set Name: ACTIVE
Mgmt Class Name: VTHMTXERP1BAMC
Copy Group Name: STANDARD
Copy Group Type: Backup
Versions Data Exists: 2
Versions Data Deleted: 1
Retain Extra Versions: 30
Retain Only Version: 60
Copy Mode: Modified
Copy Serialization: Shared Static
Copy Frequency: 0
Copy Destination: VTHMTXERP1_STG
Table of Contents (TOC) Destination: VTHMTXERP1_STG
Last Update by (administrator): ADMIN
Last Update Date/Time: 08/13/2010 15:47:01
Managing profile:
Changes Pending: No

Policy Domain Name: VTHMTXERP1_DM
Policy Set Name: ACTIVE
Mgmt Class Name: VTHMTXERP1_CM
Copy Group Name: STANDARD
Copy Group Type: Backup
Versions Data Exists: 2
Versions Data Deleted: 1
Retain Extra Versions: 30
Retain Only Version: 60
Copy Mode: Modified
Copy Serialization: Shared Static
Copy Frequency: 0
more... (<ENTER> to continue, 'C' to cancel)

Copy Destination: VTHMTXERP1_STG
Table of Contents (TOC) Destination: VTHMTXERP1_STG
Last Update by (administrator): ADMIN
Last Update Date/Time: 08/03/2010 16:03:43
Managing profile:
Changes Pending: No

And the list of archive management copygroup

tsm: TSM>q copygroup vthmtxerp1_dm active * f=d t=a

Policy Domain Name: VTHMTXERP1_DM
Policy Set Name: ACTIVE
Mgmt Class Name: VTHMTXERP1ACMC
Copy Group Name: STANDARD
Copy Group Type: Archive
Retain Version: 365
Retention Initiation: Creation
Retain Minimum Days:
Copy Serialization: Shared Static
Copy Frequency: CMD
Copy Mode: Absolute
Copy Destination: VTHMTXERP1_STG
Last Update by (administrator): ADMIN
Last Update Date/Time: 08/13/2010 15:47:29
Managing profile:
Changes Pending: No

Policy Domain Name: VTHMTXERP1_DM
Policy Set Name: ACTIVE
Mgmt Class Name: VTHMTXERP1_CM
Copy Group Name: STANDARD
Copy Group Type: Archive
Retain Version: 365
Retention Initiation: Creation
Retain Minimum Days:
Copy Serialization: Shared Static
Copy Frequency: CMD
Copy Mode: Absolute
Copy Destination: VTHMTXERP1_STG
Last Update by (administrator): ADMIN
Last Update Date/Time: 08/03/2010 16:03:43
Managing profile:
Changes Pending: No

Did anything worng with it ?
 
PREDATAR Control23

HI

The VTHMTXERP1BAMC mgmtclass needs to have an archive copygroup defined as well.

From that IBM document:
BRBACKUPMGTCLASS Example-DATA # Mgmt-Classes
BRARCHIVEMGTCLASS Example-LOGS # Mgmt-Classes
docview.wss

Both Management Classes ( Example-DATA, Example-LOGS ) need to have an Archive Copy Group.
 
PREDATAR Control23

Hi ilovetsm
I just add the archive copy group to vthmtxerp1bamc , and oh my god it is go pass the error code and mount the tape:D
I am waiting for it to complete , hope it don't get any new errors :))

Thanks you ilovetsm , i think i gonna love it too lol :))
 
Top