- All Exams Instant Download
Which stand alone utility will allow you to retrieve that information?
Given the following scenario: A table has been dropped accidentally and you need to restore the object. DSN1COPY will be used to restore the object but the PSID and the original OBID of the object is not known. Which stand alone utility will allow you to retrieve that information?A ....
Which stored procedures need to be set up in order to register an XML schema?
Which stored procedures need to be set up in order to register an XML schema?A . XSR_VALI DATE and XSR_COMPLETEB . XSR_REGISTERandXSR_COMPLETEC . XSR_VALIDATE and XSR_ADDSCHEMADOCD . XSR ADDSCHEMADOCandXSR COMPLETEView AnswerAnswer: B Explanation: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.xml.doc/ doc/c0022711.html When a database is created, the stored procedures used to register XML schemas are also...
Which DB2 command is used to turn on the recording of CPU usage information for a package?
Which DB2 command is used to turn on the recording of CPU usage information for a package?A . -START RLIMITB . -START TRACEC . -START PROFILED . -START DYNQUERYCAPTUREView AnswerAnswer: D
Which of the following migration steps is optional?
Which of the following migration steps is optional?A . Tailor the DB2 catalogB . Define DB2 12 to z/OSC . Define DB2 initialization parameters: DSNTIJUZD . Verify the integrity of the DB2 catalog and directoryView AnswerAnswer: D Explanation: https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/inst/src/tpc/db2z_runlinkch kr.html
Which library contains the early code for DB2 12?
Which library contains the early code for DB2 12?A . SDSNLINKB . SDSNLOD2C . SDSNLOADD . SDSNMACSView AnswerAnswer: A Explanation: The link list look-aside address space (LLA), which contains the Db2 12 early (ERLY) code from the SDSNLINK load module library. https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/inst/src/tpc/db2z_refreshdb2zosmigr.html
Which statement is TRUE if the PARAMDEG_DPSI subsystem parameter is set to the default value of 0?
Which statement is TRUE if the PARAMDEG_DPSI subsystem parameter is set to the default value of 0?A . Parallelism for DPSI is disabledB . The DB2 optimizer will not consider DPSI for access path selectionC . DB2 creates multiple child tasks but works on one task at a time when...
To simulate a new buffer pool size, what buffer pool parameter is used?
To simulate a new buffer pool size, what buffer pool parameter is used?A . PGFIXB . VPSIZEC . SPSIZED . AUTOSI2EView AnswerAnswer: C
In any disaster recovery scenario, a direct relationship exists between the frequency at which image copies are taken and sent to the recovery site and which of the following?
In any disaster recovery scenario, a direct relationship exists between the frequency at which image copies are taken and sent to the recovery site and which of the following?A . The ability to perform a RESTORE SYSTEMB . Time spent rebuilding indexes at disaster siteC . The amount of data...
Which of the following is required to successfully issue the -ACTIVATE command in a data sharing environment?
Which of the following is required to successfully issue the -ACTIVATE command in a data sharing environment?A . All active members must be running DB2 12B . Only one member may be active when the command is issuedC . The command must be issued with installation SYSADM authorityD . The...
Which of the following is an advantage of role-based security?
Which of the following is an advantage of role-based security?A . If you DROP a role that owns objects, those objects will also be droppedB . Within a trusted connection. DB2 allows multiple roles to be associated with any given thread at any point in timeC . Roles are used...
