We're so confident of our products that we provide no hassle product exchange.
IBM Certified System Programmer - IBM IMS Sample Questions:
1. 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) Allocate the EDMPOOL above the bar.
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) Reduce the number of table spaces with COMPRESS YES.
2. 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) Issue a START DATABASE command specifying the objects with GRECP status.
B) Set the DSNZPARM AUTOREC to YES and DB2 will automatically correct the status.
C) Run the MODIFY utility against the objects with GRECP to correct the status.
D) Run the REPAIR utility against the objects with GRECP status to change the status.
3. A customer is performing a traditional image copy disaster recovery test. The systemsprogrammer
creates a conditional restart control record (CRCR) but detects an error before starting DB2. Which action
should be performed to correct the CRCR record?
A) Start DB2, reply "M" to the WTOR that is displayed from the first CRCR record to modify the CRCR
parameters.
B) First use CRESTART,DELETE to delete the error CRCR record then CRESTART,CREATE to add a
new one.
C) Use CRESTART,CREATE to create a new CRCR record.
D) Use CRESTART,MODIFY to modify the parameters of the error CRCR record.
4. A normally well running application using packages is experiencing longer than normal elapsed times
because of a possible wait. Other DB2 applications are running within acceptable limits.
Which trace output could be analyzed to determine the change in behavior?
A) accounting class 2
B) performance class 10
C) statistics class 6
D) accounting class 8
5. 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) Run the DSNJU003 utility and modify the system point in time backup record to have
DUMPSTATE=NONE.
B) Use the BACKUPTYPE(DASD) keyword on the RESTORE SYSTEM utility.
C) Set the RESTORE_RECOVER_FROMDUMPsystem parameter to NO.
D) Use the TAPEDUMP(NORECSYS) keyword on the BACKUP SYSTEM utility when thebackup is taken.
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: A | Question # 3 Answer: C | Question # 4 Answer: D | Question # 5 Answer: C |
By Michaelia
