DB2 alternate client restore fails with sql2062n and status 516
| Article:TECH71562 | | | Created: 2009-01-16 | | | Updated: 2011-08-16 | | | Article URL http://www.symantec.com/docs/TECH71562 |
Problem
DB2 alternate client restore fails with sql2062n and status 516.
Solution
DB2 alt client restore fails with sql2062n and status 516, with source client set in the Backup, Archive, and Restore interface on the destination client, and No Restrictions file on the Master Server.
bpdb2 log shows the following:
13:59:08.736 [1524.3164] <2> bsa_bplist: Request = root root <destination_client> <destination_client> <destination_client> NONE 0 3 999 1242349361 1242522161 4 4 1 1 1 0 18 -1 -1 4 0 en en en en en 0 2 0 0 0
13:59:08.736 [1524.3164] <4> bsa_bplist: Filepath = /DB2/XYZ1PROD/node0000/20090515200241/*
13:59:09.205 [1524.3164] <2> dbc_get_string: Output = EXIT STATUS 227
13:59:09.205 [1524.3164] <8> VxBSAQueryObject: WRN - Query unsuccessful for client <destination_client>
The source client name is not being picked up, thus NetBackup is unable to find any images to issue the restore command.
Resolution:
The db2.conf file need to have an entry for the source client added to the OBJECTTYPE ALTERNATE and OBJECTTYPE DATABASE stanzas, just before the ENDOPER line, as shown below.
Example db2.conf file
DATABASE XYZ1PROD
OBJECTTYPE ALTERNATE
POLICY DB2_POLICY_1
SCHEDULE Daily
SRCINST DB2
SCRALIAS XYZ1PROD
DESTINST <Name of Instance on destination client>
DESTALIAS <Name of database on destination client>
CLIENT_NAME <SOURCE_CLIENT> <-------------------------Add
ENDOPER
# THE FOLLOWING SETTING ARE USED FOR DB2 Standard BACKUP/RESTORE
DATABASE XYZ1PROD
OBJECTTYPE DATABASE
POLICY DB2_POLICY_1
SCHEDULE Daily
CLIENT_NAME <SOURCE_CLIENT> <-------------------------Add
ENDOPER
# Archive DB2 LOG FILES
DATABASE XYZ1PROD
OBJECTTYPE ARCHIVE
POLICY Archive_Policy
SCHEDULE User_Backup
ARCFUNC SAVE
ENDOPER
No changes should be made to the /usr/openv/netbackup/bp.conf file on destination client.
|
|
Legacy ID
326718
Article URL http://www.symantec.com/docs/TECH71562
Terms of use for this information are found in Legal Notices
Thank you.