IBM Certified System Programmer - IBM IMS - C2090-549 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Your non-data sharing DB2 has a current system parameter DSMAX value of 10,000 and has only page sets with the CLOSE YES attribute. In DB2 statistics reports, you encounter many openings and closings of the VSAM data sets. Which action would relieve this situation?

A. Double the JCL parameter DYNAMNBR in DBM1 procedure. B. Double the system parameter DSMAX value. C. Alter the page set attributes to CLOSE NO. D. Increase the system parameters values for PCLOSEN and PCLOSET.

Discussion 0

Correct Answer: B Vote an answer

Question 2

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. LRDRTHLD B. MAXDBAT C. CHKFREQ D. URLGWTH

Discussion 0

Correct Answer: D Vote an answer

Question 3

Which two actions must be performed for a data sharing traditional image copy disaster recovery? (Choose two.)

A. Use the SETXCF FORCE command to delete DB2 CF structures. B. Use STARTRBA=ENDRBA for the conditional restart control record. C. Modify the IRLM start up proc to specify SCOPE=LOCAL. D. Start DB2 using the LIGHT(YES) keyword. E. Use DEFER=ALL in the system parameters during the first restart.

Discussion 0

Correct Answer: A,E Vote an answer

Question 4

An external stored procedure, assigned to application environment AE1, should run in parallel to a maximum of 10 concurrent procedures. Which action will achieve this?

A. Specify no limits for NUMTCB and AE1, but limit the degree by DSNZPARM PARAMDEG. B. Specify no limits for NUMTCB and AE1, but limit the degree by DSNZPARM CONDBAT. C. Specify NUMTCB=1 and allow 10 WLM managed stored procedure address spaces per sysplex for AE1. D. Specify NUMTCB=10 and allow 1 WLM managed stored procedure address space per sysplex for AE1.

Discussion 0

Correct Answer: D Vote an answer

Question 5

What happens when the maximum number of locks requested by an application is exceeded?

A. IMS issues a pseudo-abend of the application. B. The application pauses until acknowledged by an Operator. C. IMS pseudo-abends. D. A message is displayed, and the application program pauses until the number of locks isreduced.

Discussion 0

Correct Answer: A Vote an answer

Question 6

Pre-migration planning from a DB2 V8 for z/OS system to DB2 9 for z/OS system requires two sub-system tasks to be performed or the migration process for DB2 9 you start will be terminated immediately. Which pre-migration task must be performed?

A. DB2 DSNZPARM changes and a reassemble B. DB2 V8 fall-back SPE and V8 subsystem startup C. migration jobs for the DB2 catalog and directory D. sizing and REORG of the DB2 catalog

Discussion 0

Correct Answer: B Vote an answer

Question 7

An accounting report shows high class 3 times. Which three could contribute to the class 3 times?
(Choose three.)

A. page latch B. elapsed time C. service task switch D. not accounted time E. synchronous I/O

Discussion 0

Correct Answer: A,C,E Vote an answer

Question 8

The statistics report shows a high occurrence of timeouts. Which action will reduce the timeouts?

A. Increase DEADLOCK value by issuing MODIFY irlmproc,SET command. B. Decrease NUMLKTS (number of locks per table space) in DSNZPARM. C. Increase TIMEOUT value by issuing MODIFY irlmproc,SET command. D. Decrease NUMLKUS (number of locks per user) in DSNZPARM.

Discussion 0

Correct Answer: C Vote an answer

Question 9

Which three region types MUST be present for a z/OS application to use ODBA? (Choosethree.)

A. MPR B. CTL C. JMP D. IRLM E. DBRC F. DLISAS

Discussion 0

Correct Answer: B,E,F Vote an answer

Question 10

Your shop has a mixture of REXX, COBOL and native SQL procedures. For performance reasons the COBOL stored procedures must be configured to allow more than one concurrent stored procedureexecution for each address space started by WLM. What is the minimum number of different WLM stored procedure address space JCL set(s) that must be defined to accomplish this?

A. 3 -- one for each type of stored procedure. B. 2 -- one for COBOL plus one for REXX. C. 1 -- they can all be executed in the same WLM address space. D. 2 -- one for REXX / COBOL plus one for native SQL stored procedures.

Discussion 0

Correct Answer: B Vote an answer