A fix is available
APAR status
Closed as program error.
Error description
Customer executes redirected recovery where they are recovering a target table space using the image copy and logs from a source table space: RECOVER TABLESPACE target-db.target-ts FROM source-db.source-ts. The following messages are output: *CADB2091 - Internal error - invalid DB2SERV - V 0297. DSNU608I DSNUCAIN - USER NOT AUTHORIZED TO ACCESS TABLESPACE
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 12 for z/OS users of the RECOVER * * utility with the FROM option. * **************************************************************** * PROBLEM DESCRIPTION: * * The DSNU608I message was issued when * * redirected recovery was executed. * * The authorization check was * * erroneously done on a view instead * * of a table in the source table space. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** When redirected recovery is executed, an authorization check is done to see if the user has authority to access the data in the source table space. In this case, the check was done erroneously on a view which led to the issuing of MSGDSNU608I USER NOT AUTHORIZED TO ACCESS TABLESPACE db-name.ts-name and the RECOVER job ended with RC8. This issue could occur on redirected recovery on index spaces or indexes and for an ALIAS defined on the source table. Additional keywords: INDEXSPACE RC08
Problem conclusion
Code in the RECOVER utility has been modified to correctly check for authority on the source table. A performance improvement may be seen for redirected recovery in the UTILINIT phase during the authorization check.
Temporary fix
Comments
APAR Information
APAR number
PH40769
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-09-21
Closed date
2021-11-08
Last modified date
2022-04-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI77977
Modules/Macros
DSNUCAIN
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI77977
UP21/11/17 P F111
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0"}]
Document Information
Modified date:
06 April 2022