Welcome to download the newest Pass4itsure N10-005 dumps:
Attention Please:Professional new version IBM 000-737 PDF and VCE dumps can now free download on Flydumps.com,all are updated timely by our experts covering all IBM 000-737 new questions and questions.100 percent pass your IBM 000-737 exam.
A customer is performing a traditional image copy disaster recovery test. The systems programmer creates a conditional restart control record (CRCR) but detects an error before starting DB2. Which action should be performed to correct the CRCR record?
A. First use CRESTART,DELETE to delete the error CRCR record then CRESTART,CREATE to add a new one.
B. Start DB2, reply “M” to the WTOR that is displayed from the first CRCR record to modify the CRCR parameters.
C. Use CRESTART,MODIFY to modify the parameters of the error CRCR record.
D. Use CRESTART,CREATE to create a new CRCR record.
Which two statements are true regarding a traditional image copy disaster recovery in a data sharing environment? (Choose two ) A. All members defined to the data sharing group must be restarted at the disaster recovery site.
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. 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.
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.
Answer: B, D
DSNDB06.SYSPLAN runs out of space. Which steps should be performed to resolve the situation?
A. 1) COPY DSNDB06.SYSPLAN. 2) Stop DSNDB06.SYSPLAN. 3) Delete DSNDB06.SYSPLAN VSAM data set. 4) Define DSNDB06.SYSPLAN VSAM data set with more space. 5) Start DSNDB06.SYSPLAN. 6) RECOVER DSNDB06.SYSPLAN.
B. 1) UNLOAD DSNDB06.SYSPLAN. 2) Stop DSNDB06.SYSPLAN. 3) Delete DSNDB06.SYSPLAN VSAM data set. 4) Define DSNDB06.SYSPLAN VSAM data set with more space. 5) Start DSNDB06.SYSPLAN. 6) LOAD DSNDB06.SYSPLAN.
C. 1) UNLOAD DSNDB06.SYSPLAN. 2) ALTER PRIQTY to a larger value. 3) LOAD REPLACE DSNDB06.SYSCOPY.
D. 1) REORG UNLOAD SHRLEVEL REFERENCE DSNDB06.SYSPLAN. 2) Stop DSNDB06.SYSPLAN. 3) Delete DSNDB06.SYSPLAN VSAM data set. 4) Define DSNDB06.SYSPLAN VSAM data set with more space. 5) Start DSNDB06.SYSPLAN. 6) REORG RESUME DSNDB06.SYSPLAN.
Regarding SVC dumps for the DBM1 address space, what should be reviewed to determine the DB2 failing component?
A. the GRS summary
B. the LOGREC symptom string
C. the RMM Control Block Analysis
D. the RSM summary
A number of jobs are waiting for an allied connection to access a DB2 subsystem. What should be done to increase the number of allied connections that can be allocated concurrently?
A. Increase the value of MAXDBAT.
B. Increase the value of CTHREAD.
C. Increase the value of MAXKEEPD.
D. Increase the value of MAXDS.
A DASD controller error occurs which results in all of the active logs being marked as “STOPPED” by DB2. Which steps should be performed to resolve the log status after the controller error has been repaired?
A. 1) Stop DB2. 2) Start DB2.
B. 1) Stop DB2. 2) REPRO the archive logs to the corresponding active logs. 3) Start DB2.
C. 1) Stop DB2. 2) Use DSN1LOGP to make sure last log record written matches the information in the BSDS. 3) Do a conditional restart specifying ENDRBA to the highest RBA in the log.
D. 1) Use the change log inventory utility (DSNJU003) to delete the active logs from the BSDS. 2) Use the change log inventory utility (DSNJU003) to add the active logs back into the BSDS.
Which statement is true regarding disaster recovery scenarios?
A. When using the RESTORE SYSTEM utility, each DB2 member must use the same SYSPITR value when creating conditional restart control records (CRCR).
B. When using an advanced disk mirroring solution, a conditional restart of DB2 must still be performed at the disaster site.
C. With a synchronous peer to peer replication solution, a group restart is not required for a data sharing group since everything is synchronously mirrored.
D. A backup taken from the BACKUP SYSTEM utility cannot be used for object level recovery for the catalog/directory during a disaster recovery scenario.
Which two actions must be performed for a data sharing traditional image copy disaster recovery? (Choose two.)
A. Use STARTRBA=ENDRBA for the conditional restart control record.
B. Start DB2 using the LIGHT(YES) keyword.
C. Use DEFER=ALL in the system parameters during the first restart.
D. Modify the IRLM start up proc to specify SCOPE=LOCAL.
E. Use the SETXCF FORCE command to delete DB2 CF structures.
Answer: C, E
An accounting trace shows a high get page per SQL ratio for a query which retrieves just one row each time it is executed. Which two situations could account for the high ratio? (Choose two.)
A. Use of a matching unique index scan.
B. Use of a nonmatching index scan.
C. Use of an index with low cardinality.
D. Use of an index with high cardinality.
E. Use of a single column index that is a GENERATED ALWAYS identity column.
Answer: B, C
What is the recommended relative address space (highest to lowest) dispatching priority for these components?
A. DBM1, IRLM, MSTR, DB2 performance monitors
B. IRLM, MSTR, DB2 performance monitors, DBM1
C. IRLM, DB2 performance monitors, DBM1, MSTR
D. MSTR, IRLM, DB2 performance monitors, DBM1
You encounter a wait situation while running a BACKUP SYSTEM utility. Which two processes might contribute to this wait situation? (Choose two.)
A. CREATE TABLESPACE TS1 NUMPARTS 25 SEGSIZE 4 IN DATABASE DB1
B. LOCK TABLE TB1 PARTITION 5 IN EXCLUSIVE MODE
C. SELECT * FROM TABLE TB1 WITH RR
D. SET CURRENT DECFLOAT ROUNDING MODE=ROUND_CEILING
E. TRUNCATE TABLE TB1 DROP STORAGE
Answer: A, E
Click the Exhibit button.
Referring to the exhibit, which statement related to DB2 storage usage is correct?
The last segment is related to the basic inferential statistics that require your knowledge of chi-square, correlations, regression, samples, statistical errors, t-test and statistics. Command of these segments will help you in obtaining this certification. It will help you to understand the IBM 000-737 exam questions and answer them appropriately.
Welcome to download the newest Pass4itsure N10-005 dumps: https://www.pass4itsure.com/n10-005.html