IBM C2090-549 問題集

質問 1：
Batch jobs regularly fail when they are in the process of inserting a large number of rows into a DECLARE GLOBAL TEMPORARY TABLE. (DGTT) Which two statements accurately describe what could be causing this problem? (Choose two.)
A. The WORKFILE database is too small.
B. There is too much concurrent activity against the TEMP database to be able to handle all the DGTT activity that is going on.
C. The user is exceeding the maximum amount of temporary space that can be used by an agent (MAXTEMPS) DSNZPARM setting.
D. The table space that was selected to store the DGTT in the TEMP database is too small to store all the rows of the DGTT.
E. There are too many DB2 utilities running at the same time as the job inserting rows into the DGTT.
正解：A,C

質問 2：
Which system parameter will lower the DBM1 storage requirements (below the 2 GB bar), if the value was reduced?
A. EDM_SKELETON_POOL
B. MINSTOR
C. MXDTCACH
D. MAXDBAT
正解：D

質問 3：
Which SYS1.PARMLIB member must contain an entry for the IMS off line dump formatter to work?
A. DIAGxx
B. SCHEDxx
C. BLSCECTX
D. COMMNDx
正解：C

質問 4：
Before adding an active log data set to a subsystem, which utility should be executed in order to determine the current log configuration?
A. DSN1LOGP
B. DSNJU004
C. DSNJU003
D. DSN1CHKR
正解：B

質問 5：
Which two actions occur when the maximum number oflocks (LOCKMAX) requested by anapplication is exceeded? (Choose two.)
A. IMS issues a message and continues.
B. IMS pseudo-abends the application.
C. IMS pauses the application until the locks held are reduced.
D. IMS pseudo-abends.
E. IMS pseudo-abends the application holding the most locks.
正解：A,B

質問 6：
Non-partitioned table space TS1 lives in database DB1. Which command removes the intersystem read/write interest against this table space?
A. -START DB(DB1) SPACE(TS1) ACCESS(FORCE)
B. -START DB(DB1) SPACE(TS1) ACCESS(RW)
C. -ACCESS DB(DB1) SPACE(TS1) MODE(NGBPDEP)
D. -ALTER BUFFERPOOL(*) DBNAME(DB1) SPACE(TS1) MODE(NOISRW)
正解：C

質問 7：
Which macro specifies the class of SYSGEN tobe done (e.g., "ALL", "MODBLKS")?
A. IMSGEN
B. IMSCTRL
C. IMSCTF
D. FPCTRL
正解：B

質問 8：
The DISPLAY DATABASE command is issued and you see that there are several objects in GRECP status. What should you do to correct the problem?
A. Run the REPAIR utility against the objects with GRECP status to change the status.
B. Issue a START DATABASE command specifying the objects with GRECP status.
C. Run the MODIFY utility against the objects with GRECP to correct the status.
D. Set the DSNZPARM AUTOREC to YES and DB2 will automatically correct the status.
正解：B

質問 9：
You are migrating your DB2 for z/OS subsystem to version 9 NFM. As part of the migration process, you intend to step through the different IBM provided IVP phases to verify that everything is working well. Looking at the generated jobs, you recognize that there is only one job that has been created for phase 6 (accessing data at a remote site) rather than the whole set of jobs. What is the reason for this happening?
A. On migration panel DSNTIPX, you have entered a default WLM environment, which is not yet defined.
B. On migration panel DSNTIPR, you have specified YES or AUTO as DDF startup option.
C. On migration panel DSNTIPX, you have not entered a default WLM environment name.
D. On migration panel DSNTIPX, you have not entered a WLM procedure name.
正解：C