Hi All,
We are trying to restore ServerA (PDBDB2) database backup in ServerB(LEGDB2) through TSM
For this we did the below changes...
We have copied dsm.sys and dsm.opt file from ServerA to ServerB
Edited dsm.sys file by changing the servername to ServerA and Passwordaccess to prompt.
Ran the dsmpipw file and reset the password.
Also done updated the password with the below command
leg:db2leg 413> db2 update db cfg using tsm_password pdbdb2
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
When I was try to connect by dsmc am able to see the ServerA(PDBDB2). Please see the below output
leg:db2leg 419> dsmc
IBM Tivoli Storage Manager
Command Line Backup/Archive Client Interface
Client Version 5, Release 5, Level 0.0
Client date/time: 06/24/11 16:57:51
(c) Copyright by IBM Corporation and other(s) 1990, 2007. All Rights Reserved.
Node Name: PDBDB2
Please enter your user id <PDBDB2>: pdbdb2
Please enter password for user id "PDBDB2":
Session established with server SERVER1: AIX-RS/6000
Server Version 5, Release 5, Level 5.0
Server date/time: 06/24/11 16:53:43 Last access: 06/24/11 16:35:57
tsm> q node
Please enter your user id <PDBDB2>: pdbdb2
Please enter password for user id "PDBDB2":
Session established with server SERVER1: AIX-RS/6000
Server Version 5, Release 5, Level 5.0
Server date/time: 06/24/11 16:53:56 Last access: 06/24/11 16:53:47
Node Name Platform Policy Domain Days Since Days Since Locked?
Name Last Access Password Set
_________ _________ _____________ __________ ____________ _______
PDBDB2 AIX R3DDOM 0 0 0
tsm>
And now when I try to check for ServerA backup's from serverB(LEG) am getting the below error.
leg:db2leg 412> db2adutl query full database r3p
--- ERROR! Database not found in system directory! ---
Error: Initialize session failed with ADSM return code 137
The Output is when the PASSWORDACCESS is set to PROMPT when the PASSWORDACCESS set to GENERATE am getting the below output...
Query for database R3P
Retrieving FULL DATABASE BACKUP information.
No FULL DATABASE BACKUP images found for R3P
Retrieving INCREMENTAL DATABASE BACKUP information.
No INCREMENTAL DATABASE BACKUP images found for R3P
Retrieving DELTA DATABASE BACKUP information.
No DELTA DATABASE BACKUP images found for R3P
Few months before also we have done it and at that time we haven't faced any issue.Previously it worked with PASSWORDACCES PROMPT....But Now only facing the issue.
Can anyone please help us to find the solution...?
Thanks & Regards
Ravi Kasturi
We are trying to restore ServerA (PDBDB2) database backup in ServerB(LEGDB2) through TSM
For this we did the below changes...
We have copied dsm.sys and dsm.opt file from ServerA to ServerB
Edited dsm.sys file by changing the servername to ServerA and Passwordaccess to prompt.
Ran the dsmpipw file and reset the password.
Also done updated the password with the below command
leg:db2leg 413> db2 update db cfg using tsm_password pdbdb2
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
When I was try to connect by dsmc am able to see the ServerA(PDBDB2). Please see the below output
leg:db2leg 419> dsmc
IBM Tivoli Storage Manager
Command Line Backup/Archive Client Interface
Client Version 5, Release 5, Level 0.0
Client date/time: 06/24/11 16:57:51
(c) Copyright by IBM Corporation and other(s) 1990, 2007. All Rights Reserved.
Node Name: PDBDB2
Please enter your user id <PDBDB2>: pdbdb2
Please enter password for user id "PDBDB2":
Session established with server SERVER1: AIX-RS/6000
Server Version 5, Release 5, Level 5.0
Server date/time: 06/24/11 16:53:43 Last access: 06/24/11 16:35:57
tsm> q node
Please enter your user id <PDBDB2>: pdbdb2
Please enter password for user id "PDBDB2":
Session established with server SERVER1: AIX-RS/6000
Server Version 5, Release 5, Level 5.0
Server date/time: 06/24/11 16:53:56 Last access: 06/24/11 16:53:47
Node Name Platform Policy Domain Days Since Days Since Locked?
Name Last Access Password Set
_________ _________ _____________ __________ ____________ _______
PDBDB2 AIX R3DDOM 0 0 0
tsm>
And now when I try to check for ServerA backup's from serverB(LEG) am getting the below error.
leg:db2leg 412> db2adutl query full database r3p
--- ERROR! Database not found in system directory! ---
Error: Initialize session failed with ADSM return code 137
The Output is when the PASSWORDACCESS is set to PROMPT when the PASSWORDACCESS set to GENERATE am getting the below output...
Query for database R3P
Retrieving FULL DATABASE BACKUP information.
No FULL DATABASE BACKUP images found for R3P
Retrieving INCREMENTAL DATABASE BACKUP information.
No INCREMENTAL DATABASE BACKUP images found for R3P
Retrieving DELTA DATABASE BACKUP information.
No DELTA DATABASE BACKUP images found for R3P
Few months before also we have done it and at that time we haven't faced any issue.Previously it worked with PASSWORDACCES PROMPT....But Now only facing the issue.
Can anyone please help us to find the solution...?
Thanks & Regards
Ravi Kasturi