IBM Certified System Programmer - IBM IMS (C9050-549) Free Practice Test

Question 1

DSNDB06.SYSPLANruns out of space. Which steps should be performed to resolve the situation?

A. 1) UNLOAD DSNDB06.SYSPLAN.
2 ) ALTER PRIQTY to a larger value.
3 ) LOAD REPLACE DSNDB06.SYSCOPY.

B. 1) UNLOAD DSNDB06.SYSPLAN.
2 ) Stop DSNDB06.SYSPLAN.
3 ) Delete DSNDB06.SYSPLANVSAM data set.
4 ) Define DSNDB06.SYSPLANVSAM data set with more space.
5 ) Start DSNDB06.SYSPLAN.
6 ) LOAD DSNDB06.SYSPLAN.

C. 1) REORG UNLOAD SHRLEVEL REFERENCE DSNDB06.SYSPLAN.
2 ) Stop DSNDB06.SYSPLAN.
3 ) Delete DSNDB06.SYSPLANVSAM data set.
4 ) Define DSNDB06.SYSPLANVSAM data set with more space.
5 ) Start DSNDB06.SYSPLAN.
6 ) REORG RESUME DSNDB06.SYSPLAN.

D. 1) COPY DSNDB06.SYSPLAN.
2 ) Stop DSNDB06.SYSPLAN.
3 ) Delete DSNDB06.SYSPLANVSAM data set.
4 ) Define DSNDB06.SYSPLANVSAM data set with more space.
5 ) Start DSNDB06.SYSPLAN.
6 ) RECOVER DSNDB06.SYSPLAN.

Correct Answer: D

Question 2

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?

A. Reduce the number of table spaces with COMPRESS YES.

B. REBIND those plans/packages mentioned in message DSNV512I with RELEASE(DEALLOCATE).

C. REBIND those plans/packages mentioned in message DSNV512I with RELEASE(COMMIT).

D. Allocate the EDMPOOL above the bar.

Correct Answer: C

Question 3

The group buffer pool structures, GBP0, GBP1, and GPB2 reside in CF1 for a data sharing group DG0P.
The LOCK and the LIST structures reside in CF2. AUTOREC is set to YES. The group buffer pools are
not duplexed. CF1 fails due to a microcode problem and noneof the GBPs are available. Which statement
is true?

A. DB2 automatically rebuilds the GBPs based on information kept in the local buffer pools.

B. DB2 is able to continue without the GBPs.

C. DB2 automatically recovers since AUTOREC is set to YES.

D. DB2 initiates automatic GRECP recovery, after it has been restarted.

Correct Answer: C

Question 4

A customer has just migrated their DB2 system to V9 new function mode. They currently use the
BACKUP SYSTEM utility and have optionally dumped the backup to tape. Which action should be
performed to only use the system level backup that was taken to disk?

A. Set the RESTORE_RECOVER_FROMDUMPsystem parameter to NO.

B. Run the DSNJU003 utility and modify the system point in time backup record to have
DUMPSTATE=NONE.

C. Use the BACKUPTYPE(DASD) keyword on the RESTORE SYSTEM utility.

D. Use the TAPEDUMP(NORECSYS) keyword on the BACKUP SYSTEM utility when thebackup is taken.

Correct Answer: A

Question 5

A DB2 subsystem is set up to take a checkpoint every two minutes. Applications that use this DB2
subsystem are supposed to adhere to an IT standard where a commit should be issued by the application
at least every 200 SQL changes (INSERTs, UPDATES, or DELETEs). Which system parameter would be
used to help implement the IT standard?

A. CHKFREQ

B. URLGWTH

C. MAXDBAT

D. LRDRTHLD

Correct Answer: B

Question 6

You must activate an accounting trace for collecting standard accounting data in the SMF file using the
criteria shown below: CPU, elapse, suspension time on an application, andpackage level plans starting
with AB and LM user IDs starting with ADM plans starting withABX should be excluded Which command
will activate only the required traces?

A. -START TRACE (ACCTG) CLASS(1,2,3,4,7) DEST(SMF) PLAN (AB*,LM*)
USERID(ADM*, AB*) XPLAN(ABX*)

B. -START TRACE (ACCTG) CLASS(1,2,3,7,8) DEST(SMF) PLAN (AB*,LM*)
USERID(ADM*) XPLAN(ABX*)

C. -START TRACE (ACCTG) CLASS(1,2,3,7,8) DEST(SMF) PLAN (AB*,LM*)
USERID(ADM*) EXCLUDE(PLAN(ABX*) )

D. -START TRACE (ACCTG, STATISTICS) CLASS(*) DEST(SMF) PLAN (AB*,LM*)
USERID(ADM) XPLAN(ABX*)

Correct Answer: B

Question 7

Using the change log inventory utility, which CRESTART parameters are used to indicate a cold start?

A. STARTRBA=ENDRBA

B. SYSPITR=FFFFFFFFFFFF

C. STARTRBA=FFFFFFFFFFFF

D. ENDRBA=FFFFFFFFFFFF

Correct Answer: A

Question 8

A customer is performing a disaster recovery test using the RESTORE SYSTEM utility. Where would the
BSDS be recovered from in this scenario?

A. The second data set created from the last -ARCHIVE LOG command.

B. The SMS log copy pool backup.

C. The most current active log data set.

D. The image copy data set of the catalog and directory.

Correct Answer: B

Question 9

Under which condition would a -RESET INDOUBT command be necessary?

A. When in-doubt threads have been resolved and DB2 cannot synchronize with the commit coordinator.

B. When DB2 is the commit coordinator and is unable to resolve in-doubt threads.

C. When DB2 cannot determine if the threads should be committed or rolled back.

D. When the commit coordinator is unable to determine if threads should be committed or rolled back.

Correct Answer: A

Welcome to TestSimulate

IBM Certified System Programmer - IBM IMS (C9050-549) Free Practice Test