IBM C2090-317 Online Practice Questions and Exam Preparation

IBM C2090-317 Online Questions & Answers

• Question 1:

  The -ALTER UTILITY command changes the values of certain parameters of a utility. Which two utilities can this command be issued against?

  A. COPY
  B. REORG
  C. MODIFY
  D. REBUILD
  E. RECOVER
  B. REORG
  D. REBUILD

• Question 2:

  You wish to set the threshold at which data in the class castout queue is cast out to disk for group buffer pool GBP10. You want the threshold to be 1000 pages. Which parameter setting in the command -ALTER GBPOOL(GBP10) will accomplish this?

  A. GBPOOLT(10)
  B. CLASST(0.1000)
  C. CLASST(10.1000)
  D. GBPCHKPT(1000)
  A. GBPOOLT(10)

• Question 3:

  Which method can be used to set the DB2 client information (workstation name, application name..) from a JDBC application using a type 4 connection?

  A. Using the java.sql.Connection.setClientlnfo method
  B. Using the SET_CLIENT_ID option during RRS SIGNON
  C. Using the SQL SET statement (eg. SET CURRENT CLIENT J/VRKSTNNAME = 'MYWS*)
  D. Setting up a profile using the SPECIAL_REGISTER attribute in SYSIBM.DSN PROFILE ATTRIBUTES table
  C. Using the SQL SET statement (eg. SET CURRENT CLIENT J/VRKSTNNAME = 'MYWS*)

• Question 4:

  You wish to enforce a system-wide limit on the maximum number of parallel subtasks for utilities REORG TABLESPACE, REBUILD INDEX. CHECK INDEX. UNLOAD, and LOAD, to 16 parallel subtasks per utility execution. Which action, if any will enforce this limit?

  A. Set subsystem parameter PARAMDEG to 16.
  B. Set subsystem parameter PARAMDEGJJTIL to 16.
  C. Set subsystem parameter INDEX_IO_PARALLELISM to 16.
  D. DB2 does not allow for a system level limit for parallel subtasks in these utilities. The limit can only be specified with the utility keyword PARALLEL n.
  A. Set subsystem parameter PARAMDEG to 16.

• Question 5:

  If a DB2 subsystem fails during start up in the log initialization phase, which two steps are needed in your corrective actions to minimize impact without completing a cold start?

  A. Start DB2 using DEFER ALL.
  B. Use DSNJU003 with the ENDRBA option.
  C. Use DSNJU003 with the STARTRBA option.
  D. Start DB2 using DEFER on catalog and directory.
  E. Recover the subsystem to the last known system checkpoint in BSDS.
  D. Start DB2 using DEFER on catalog and directory.
  E. Recover the subsystem to the last known system checkpoint in BSDS.

• Question 6:

  You execute the following SQL against the CDB (Communications Database) of your DB2 subsystem:

  INSERT INTO SYSIBM.IPNAMES

  (UNKNAME.SECURITY_OUT.USERNAMES,IBMREQD.IPADDR) VALUES ('REMOTEDB'. 'P\ 'O'. 'N', *123.34.45.56');

  INSERT INTO SYSIBM.IPLIST (LINKNAMEJPADDRJBMREQD) VALUES ('REMOTEDB', '123.34.45.56', *N');

  INSERT INTO SYSIBM.IPLIST (LINKNAMEJPADDRJBMREQD) VALUES C REMOTEDB', '123.34.45.57', 'N');

  INSERT INTO SYSIBM.USERNAMES

  (TYPE,AUTHID.LINKNAME,NEWAUTHID.PASSWORD,IBMREQD) VALUES (T, 'USER1'.

  'USER2\ ", ,PWD2,1 *N');

  INSERT INTO SYSIBM.USERNAMES

  (TYPE,AUTHID.LINKNAME,NEWAUTHID.PASSWORDJBMREQD) VALUES ('O', 'USER1'. 'USER3', *', 'PWD3', 'N');

  There is no trusted connection to REMOTEDB. USER1 issues a query addressing remote data source REMOTEDB on your DB2 subsystem.

  Which authorization id will be used on the remote data source REMOTEDB?

  A. USER1
  B. USER2
  C. USER3
  D. USER4
  A. USER1

• Question 7:

  Which subsystem parameter setting allows connection queuing?

  A. IDTHTOIN>0
  B. CONDBAT>0
  C. POOLINAC>0
  D. MAXCONGN > 0
  D. MAXCONGN > 0

• Question 8:

  Given a subsystem parameter of SEPARATE_SECURITY=YES, what level of security has the authority to create and start audit policies?

  A. SYSOPR
  B. SYSADM
  C. SECADM
  D. SQLADM
  C. SECADM

• Question 9:

  You are facing a severe locking problem with a specific application using plan PLANB. To identify what is going on you need to start a detailed locking trace. However, you want to limit the scope of the trace somewhat to reduce the trace overhead and trace volume. (IFCID 21 traces each lock request and is part of performance trace class 7).

  Which is the most appropriate command to use ?

  A. -STA TRA(P) CLASS(7) DEST(GTF) PLAN(PLANB)
  B. -STA TRA(P) CLASS(7) IFCID(21) DEST(GTF) PLAN(PLANB)
  C. -STATRA(P)CLASS(30) IFCID(21) DEST(GTF) PLAN(PLANB)
  D. -STA TRA(P) CLASS(7) IFCID(21) DEST(GTF) XPLAN(PLANB')
  B. -STA TRA(P) CLASS(7) IFCID(21) DEST(GTF) PLAN(PLANB)

• Question 10:

  Which statement about the castout process in data sharing is true?

  A. The castout process is initiated by the coupling facility.
  B. The castout process is performed using BPO of the less active member of the group.
  C. The castout process is performed by the first member to express write interest in the data set.
  D. The castout process is performed using a private buffer pool in the first member to join the group.
  C. The castout process is performed by the first member to express write interest in the data set.