IBM Certified System Programmer - IBM IMS 認定 C2090-549 試験問題:

1. DB2 commands in data sharing can have a scope of group or a scope of member. Which
three commands have a scope of member? (Choose three.)

A) -ARCHIVE LOG MODE(QUIESCE)
B) -START DATABASE(DB1) SPACENAM(TS1)
C) -STOP PROCEDURE(PROD.SP1)
D) -ACCESS DATABASE(DB1) SPACENAM(TS1) MODE(OPEN)
E) -SET LOG SUSPEND

2. You are planning for the execution of multiple concurrent RECOVER jobs (e.g., during DB2 disaster recovery). Which DSNZPARM parameter allows for the most Fast Log Apply storage to be allocated to each RECOVER job?

A) MEMLIMIT=100M
B) LOGAPSTG=100M
C) FASTLOG=100M
D) LOGAPSTG=0M

3. DSNDB06.SYSPLAN runs out of space. Which steps should be performed to resolve the situation?

A) 1) COPY DSNDB06.SYSPLAN.
2) Stop DSNDB06.SYSPLAN.
3) Delete DSNDB06.SYSPLAN VSAM data set.
4) Define DSNDB06.SYSPLAN VSAM data set with more space.
5) Start DSNDB06.SYSPLAN. 6) RECOVER DSNDB06.SYSPLAN.
B) 1) UNLOAD DSNDB06.SYSPLAN.
2) Stop DSNDB06.SYSPLAN.
3) Delete DSNDB06.SYSPLAN VSAM data set.
4) Define DSNDB06.SYSPLAN VSAM data set with more space.
5) Start DSNDB06.SYSPLAN.
6) LOAD DSNDB06.SYSPLAN.
C) 1) UNLOAD DSNDB06.SYSPLAN.
2) ALTER PRIQTY to a larger value.
3) LOAD REPLACE DSNDB06.SYSCOPY.
D) 1) REORG UNLOAD SHRLEVEL REFERENCE DSNDB06.SYSPLAN.
2) Stop DSNDB06.SYSPLAN.
3) Delete DSNDB06.SYSPLAN VSAM data set.
4) Define DSNDB06.SYSPLAN VSAM data set with more space.
5) Start DSNDB06.SYSPLAN.
6) REORG RESUME DSNDB06.SYSPLAN.

4. Which statement is true about the use of Trusted Network Context and Roles?

A) Trusted Network Context and Roles does not require RACF.
B) Roles revoked from an authorization ID will trigger cascade revocation.
C) Roles cannot own objects.
D) Trusted Network Context and Roles allows a DBA to create and manage objects without ownership.

5. 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(COMMIT).
C) Allocate the EDMPOOL above the bar.
D) REBIND those plans/packages mentioned in message DSNV512I with RELEASE(DEALLOCATE).

質問と回答：