IBM C2090-317 - DB2 11 System Administrator for z/OS Exam

Page:    1 / 12   
Total 60 questions

Program Authorization does NOT work in which environment?

  • A. IMS
  • B. CICS
  • C. DSN command processor
  • D. Programs that run in stored procedure address spaces


Answer : C

Having to deal with data inconsistency during a disaster recovery can significantly impact the length of time needed to recover. One of the actions that could be taken to prevent this from occurring is to not take an image copy of a data set that contains inconsistent data.
Which two options can be used to help prevent taking an image copy of inconsistent data?

  • A. Run the DIAGNOSE utility before making an image copy.
  • B. Run the CHECK DATA utility before making an image copy.
  • C. Use the CHECKPAGE option when running the COPY utility.
  • D. Prior to making an image copy, run DSN1 COPY with the CHECK option.
  • E. At install time, use the DSNTIJIC install job to take a full image copy of the DB2 catalog and directory.


Answer : C,D

Reference:http://www-
01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.ugref/src/tpc/d b2z_checkinconsistentdata.dita

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.DSNPROFILE ATTRIBUTES table


Answer : C

Local buffer pool updated pages are queued by data set until they are written out to DASD when which event occurs?

  • A. A page is added.
  • B. A COMMIT is executed.
  • C. When VPSEQT is reached.
  • D. A system checkpoint is taken.g


Answer : B

Which copy operation CANNOT be performed by DSN1COPY?

  • A. DB2 concurrent copies to DB2 VSAM data sets.
  • B. DB2 image copy data sets to DB2 VSAM data sets.
  • C. DB2 VSAM data sets to other DB2 VSAM data sets.
  • D. DSN1COPY sequential data sets to other sequential data sets.


Answer : A

Reference:http://www-
01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.ugref/src/tpc/d b2z_utl_dsn1copy.dita

Page:    1 / 12   
Total 60 questions