QUESTION: 17

Which of the following subsystem parameters is only applicable in a data sharing environment?

DSMAX
TWOACTV
RETLWAIT
REFSHAGE

Answer(s): C

Explanation:

This value is only significant in a data sharing environment. It indicates how long a transaction should wait for a lock on a resource if another DB2 in the data sharing group has failed and is holding an incompatible lock on that resource. Locks held by failed DB2 members are called retained locks. This value is a multiplier that is applied to the connection's normal timeout value. For example, if the retained lock multiplier is 2, then the timeout period for a call attachment connection that is waiting for a retained lock is twice the normal CAF timeout period. The default is 0, meaning applications do not wait for incompatible retained locks, the lock request is immediately rejected and the application receives a "resource unavailable" SQLCODE.
Install parameter RETAINED LOCK TIMEOUT on panel DSNTIPI, or ZPARM RETLWAIT in DSN6SPRM. This value is only significant in a data sharing environment. It indicates how long a transaction should wait for a lock on a resource if another DB2 in the data sharing group has failed and is holding an incompatible lock on that resource. Locks held by failed DB2 members are called retained locks. This value is a multiplier that is applied to the connection's normal timeout value. For example, if the retained lock multiplier is 2, then the timeout period for a call attachment connection that is waiting for a retained lock is twice the normal CAF timeout period. The default is 0, meaning applications do not wait for incompatible retained locks, the lock request is immediately rejected and the application receives a "resource unavailable" SQLCODE.
Install parameter RETAINED LOCK TIMEOUT on panel DSNTIPI, or ZPARM RETLWAIT in DSN6SPRM.

Reveal Solution Next Question

QUESTION: 18

While processing a DB2 must-complete function, DB2 encountered an error during an attempt to access the required log data sets.
Which of the following is TRUE?

DB2 abends
The affected page sets will be put into REFP restrictive state
The affected page sets will be put into RESTP restrictive state
DB2 will wait for a reply to message DSNJ154I before retrying the failed log-read request, or before abending

Answer(s): D

Explanation:

While processing a Db2 must-complete function, Db2 encountered an error during an attempt to access the required log data sets.
CONNECTION-ID, CORRELATION-ID, and LUWID together identify the thread associated with the request. token is a unique token number associated with the LUWID. reason-code identifies the most recent log-read failure.
System action
The DSNJ154I message requests to retry the log-read request, and immediately follows this error message. Db2 will wait for a reply to message DSNJ154I before retrying the failed log-read request, or before abending.
This message is non-scrollable. It remains highlighted on the console until you take the appropriate action.
https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/msgs/src/tpc/dsnj153e.html

Reveal Solution Next Question