Using Thread Termination\Dynamic DSNZPARM to change the EDMPOOL value and receive PTT1062E and PTT1070E errors. How can this be fixed?

Document ID : KB000054813
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

I am using Thread Termination\Dynamic DSNZPARM to change the EDMPOOL value but receive the following errors:

PTT1062E ERROR PROCESSING DB2 COMMAND CALL. DB2 RETURN CODE 8 REASON CODE 00F30034.
PTT1070E INTERNAL ERROR ENCOUNTERED. ERROR NUMBER=1.

How can this be fixed?

Solution

This problem can be resolved by granting EXECUTE authority to the USERID associated with the DB2 subsystem DBM1 address space and Xmanager started task. The routine that actually drives the EDMPOOL storage size change runs in the DBM1 address space. It is necessary to use Product Authorization to grant EXECUTE authority for the "Manage DB2 Default Group" and "View Subsystem Data" plans to the USERID associated with the DB2 subsystem DBM1 address space and Xmanager started task.

The associated plans for "Manage DB2 Default Group" and "View Subsystem Data" can be found in the PLANSxx member of the highlevel.CDBAPARM:

PTTPLN06=PTTFxxxx Manage DB2 Default Group
PTTPLN02=PTTBxxxx View Subsystem Data

For more information, please refer to the "Chapter 2: Operational Considerations",  "DB2 Security section" in the "Thread Termination\Dynamic DSNZPARM User Guide"