What is the next step to be taken to improve virtual storage constraint relief?
DB2 monitors DBM1 storage below the bar for critical storage increases resulting in messages
that report current DBM1 storage consumption. What is the next step to be taken to improve virtual
storage constraint relief?
Which type of trace may require up to 100% CPU overhead?
DB2 traces have their own associated performance overhead. Which type of trace may require up
to 100% CPU overhead?
Which statement is correct about the PGFIX buffer pool option?
Which statement is correct about the PGFIX buffer pool option?
Which action would relieve this situation?
Your non-data sharing DB2 has a current system parameter DSMAX value of 10,000 and has only
page sets with the CLOSE YES attribute. In DB2 statistics reports, you encounter many openings
and closings of the VSAM data sets. Which action would relieve this situation?
Which command sequence would you issue to activate this code?
In a DB2 non-data sharing system you want to activate changes to DB2 early code in DB2 9.
Which command sequence would you issue to activate this code?
Which command removes the intersystem read/write interest against this table space?
Non-partitioned table space TS1 lives in database DB1. Which command removes the intersystem
read/write interest against this table space?
Which statement describes how to correct this situation?
Your administrative scheduler shows message DSNA679I indicating that one or both copies of
your task lists is not accessible or is corrupted. Your analysis shows that only the VSAM file is
corrupt, but the ADMIN_TASKS table is still operational. Which statement describes how to correct
this situation?
what can you do to reverse the -STOP DATABASE command and make the page set available without stopping?
Someone has issued a -STOP DATABASE(DB1) SPACE(TS1) command without previously
checking if the page set is currently in use by any URs. The page set is ultimately placed in
STOPP restrictive state. Using the DISPLAY THREAD(*) TYPE(SYSTEM) command, what can
you do to reverse the -STOP DATABASE command and make the page set available without
stopping?
Which action should be performed by the systems programmer to activate the new early code with the least impac
A systems programmer has just installed critical maintenance on a DB2 system that affects early
code and they need this code to be activated immediately to fix a problem they are experiencing.
Which action should be performed by the systems programmer to activate the new early code with
the least impact to the z/OS system?
which condition would a -RESET INDOUBT command be necessary?
Under which condition would a -RESET INDOUBT command be necessary?