Free IBM C9050-549 Exam Dumps Questions & Answers

Which two statements are true regarding a traditional image copy disaster recovery in a data sharing
environment? (Choose two )

• A.  Only one conditional restart control record (CRCR) needs to be created for the data sharing group and
  all DB2 members will utilize this CRCR during restart.
• B.  When using change log inventory (DSNJU003), the latest log record sequence number that can be
  used is the oldest last written log record of all members participating in the restart.
• C.  All members defined to the data sharing group must be restarted at the disaster recovery site.
• D.  SETXCF FORCE commands should be used to purge DB2 coupling facility structures prior to staring
  the first DB2 member.
• E.  The catalog and directory must be recovered by first data sharing member brought up at the disaster
  recovery site and all other members must not be started before this recovery is finished.

DB2 has written the following message to the system log:
DSNP007I DSN3 DSNPXTN0 -EXTEND FAILED FOR 229
DSNP.DSNDBD.DSNDB07.DSN4K03.I0001.A001. RC=00D70027 CONNECTION-ID=SERVER,
CORRELATION-ID=java.exe, LUW ID=A49CA1E4.C350.623F6A48E28B=120701
Which action would you take to correct the problem?

• A.  Alter the primary and/or secondary space quantity of the DSNDB07.DSN4K03 table space, and then
  execute the RECOVER utility.
• B.  Use SQL to create a new 32K table space in DSBDB07.
• C.  Use SQL to create an additional 4K table space in DSNDB07.
• D.  Alter the primary and/or secondary space quantity of the DSNDB07.DSN4K03 table space, and then
  execute the REORG utility.

You have a problem where a buffer pool runs out of write engines, which action should be taken?

• A.  Increase the DWQT to have more pages written at once.
• B.  Lower the VDWQT write threshold to keep the writes more constant.
• C.  Dynamically increase the number of write engines on the subsystem.
• D.  Alter the buffer pool to use PGFIX(NO).

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 procedure
execution 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.  2 -- one for REXX / COBOL plus one for native SQL stored procedures.
• B.  1 -- they can all be executed in the same WLM address space.
• C.  3 -- one for each type of stored procedure.
• D.  2 -- one for COBOL plus one for REXX.

A customer is planning on using the BACKUP SYSTEM utility. The DB2 systems programmer works with
the storage administrator to establish the correct SMS definitions. Which configuration is correct for use of
the BACKUP SYSTEM utility?

• A.  SMS copy pool 1 that contains the catalog and directory SMS copy pool 2 that containsthe BSDS and
  active logs SMS copy pool 3 that contains the user data
• B.  SMS copy pool 1 that contains the catalog, directory, BSDS and active logs SMS copypool 2 that
  contains the user data
• C.  SMS copy pool 1 that contains the catalog and directory SMS copy pool 2 that containsthe user data
• D.  SMS copy pool 1 that contains the catalog, directory and user data SMS copy pool 2that contains the
  BSDS and active logs