IBM Certified System Programmer - IBM IMS Sample Questions:
1. Dynamic Resource Definition can be used to replace which type of sysgen?
A) ONLINE
B) CTLBLKS
C) MODBLKS
D) NUCLEUS
2. The DB2-supplied SQL Procedure Processor stored procedure DSNTPSMP requires which two for execution? (Choose two.)
A) Workload Manager SPAS with NUMTCB=1
B) Optimization Service Center
C) Workload Manager SPAS with NUMTCB > 1
D) Java Virtual Machine
E) DB2 for z/OS REXX Language Support
3. Which case would require you to perform a DB2 conditional restart?
A) The system suffered an outage because of a DASD subsystem failure. The logs are available but not the table spaces and index spaces.
B) During restart, the back out phase is taking too long because a long running job that executed many updates and never committed. The only way to bypass the long back out phase is to perform a conditional restart with BACKOUT=NO.
C) The DB2 system fails during normal processing because of an exceptional peak in the workload. Normal restart abends in the log apply phase whenever DB2 is started.
D) The DASD subsystem has experienced a major problem and the primary active log data sets are lost. A peer-to-peer remote copy (PPRC) is not available.
4. 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?
A) -STOP DB2; -REFRESH DB2,EARLY; -START DB2
B) -START DB2; -REFRESH DB2,EARLY
C) -REFRESH DB2,EARLY
D) -REFRESH DB2,EARLY; -STOP DB2; -START DB2
5. A customer is planning on using system level point-in-time backup and recovery. DB2 uses two SMS copy pools with the names shown below: DSN$xxxx$DB DSN$xxxx$LG
What is the correct substitution for "xxxx" in the names shown above?
A) location name
B) group attach name
C) catalog alias
D) subsystem name
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: A,E | Question # 3 Answer: C | Question # 4 Answer: A | Question # 5 Answer: A |
We're so confident of our products that we provide no hassle product exchange.


By Claude

