IBM certification 000-737 exam training materials

If you are still study hard to prepare the IBM 000-737 exam, you're wrong. Of course, with studying hard, you can pass the exam. But may not be able to achieve the desired effect. Now this is the age of the Internet, there are a lot of shortcut to success. ITCertKing's IBM 000-737 exam training materials is a good training materials. It is targeted, and guarantee that you can pass the exam. This training matrial is not only have reasonable price, and will save you a lot of time. You can use the rest of your time to do more things. So that you can achieve a multiplier effect.

We all well know the status of IBM certification 000-737 exams in the IT area is a pivotal position, but the key question is to be able to get IBM 000-737 certification is not very simple. We know very clearly about the lack of high-quality and high accuracy exam materials online. Exam practice questions and answers ITCertKing provide for all people to participate in the IT industry certification exam supply all the necessary information. Besides, it can all the time provide what you want. Buying all our information can guarantee you to pass your first IBM certification 000-737 exam.

There are different ways to achieve the same purpose, and it's determined by what way you choose. A lot of people want to pass IBM certification 000-737 exam to let their job and life improve, but people participated in the IBM certification 000-737 exam all knew that IBM certification 000-737 exam is not very simple. In order to pass IBM certification 000-737 exam some people spend a lot of valuable time and effort to prepare, but did not succeed.

ITCertKing's IBM 000-737 exam training materials not only can save your energy and money, but also can save a lot of time for you. Because the things what our materials have done, you might need a few months to achieve. So what you have to do is use the ITCertKing IBM 000-737 exam training materials. And obtain this certificate for yourself. ITCertKing will help you to get the knowledge and experience that you need and will provide you with a detailed IBM 000-737 exam objective. So with it, you will pass the exam.

000-737 certification exam is a very import component IBM certification exam. But passing IBM certification 000-737 exam is not so simple. In order to give to relieve pressure and save time and effort for candidates who take a preparation for the 000-737 certification exam, ITCertKing specially produce a variety of training tools. So you can choose an appropriate quick training from ITCertKing to pass the exam.

Exam Code: 000-737
Exam Name: IBM (DB2 9 System Administrator for z/OS Exam)
One year free update, No help, Full refund!
Total Q&A: 102 Questions and Answers
Last Update: 2013-09-21

Only to find ways to success, do not make excuses for failure. To pass the IBM 000-737 exam, in fact, is not so difficult, the key is what method you use. ITCertKing's IBM 000-737 exam training materials is a good choice. It will help us to pass the exam successfully. This is the best shortcut to success. Everyone has the potential to succeed, the key is what kind of choice you have.

000-737 Free Demo Download: http://www.itcertking.com/000-737_exam.html

NO.1 A customer has just migrated their DB2 system to V9 new function mode. They currently use the
BACKUP SYSTEM utility and have optionally dumped the backup to tape. Which action should be
performed to only use the system level backup that was taken to disk?
A.Run the DSNJU003 utility and modify the system point in time backup record to have
DUMPSTATE=NONE.
B.Use the BACKUPTYPE(DASD) keyword on the RESTORE SYSTEM utility.
C.Use the TAPEDUMP(NORECSYS) keyword on the BACKUP SYSTEM utility when the backup is taken.
D.Set the RESTORE_RECOVER_FROMDUMP system parameter to NO.
Answer:D

IBM braindump   000-737   000-737

NO.2 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.
Answer:B

IBM answers real questions   000-737   000-737   000-737 exam dumps

NO.3 A DB2 subsystem is being migrated/converted from DB2 Version 8 to DB2 9. The subsystem currently
has these characteristics: new DB2 9 functions are not available; no DB2 9 objects can exist; the
subsystem cannot fall-back to CM (conversion mode); the subsystem cannot fall-back to Version 8; the
subsystem cannot coexist with any Version 8 systems in a data sharing group. Which mode describes the
DB2 subsystem?
A.CM* (conversion mode*)
B.ENFM (enabling-new-function mode)
C.ENFM* (enabling-new-function mode*)
D.NFM (new-function mode)
Answer:B

IBM   000-737   000-737

NO.4 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.
Answer:A

IBM exam prep   000-737   000-737   000-737 study guide   000-737 exam dumps

NO.5 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

IBM   000-737 original questions   000-737   000-737   000-737

NO.6 You are migrating your DB2 subsystem from version 8 to DB2 9. You have already used the
user-defined RTS tables in version 8 and you are planning to also use RTS in version 9. Which two
statements are true? (Choose two.)
A.DSNRTSDB is integrated into the DB2 9 catalog.
B.The existing the real-time statistics data is copied from your user-defined tables to catalog tables as part
of the migration to CM.
C.You can safely drop your user-defined RTS database once you are in ENFM.
D.You should keep your user-defined RTS database until you have fully migrated to NFM.
E.Execute DDL in member DSNTESS in SDSNSAMP to create the RTS database.
Answer:A C

IBM certification training   000-737   000-737 test questions   000-737 exam simulations   000-737

NO.7 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
Answer:B

IBM   000-737 test   000-737   000-737 exam   000-737 exam

NO.8 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.
Answer:A

IBM test   000-737 exam dumps   000-737 exam prep   000-737

NO.9 You are planning the migration of your DB2 subsystem from version 8 to version 9. Rebinding existing
packages is highly recommended, but you are also worrying about potential problems that might occur
with new access paths after rebind. Which action gives you the option to rebind packages with the ability
to fall back to the original access path if performance problems are encountered?
A.Use REBIND PACKAGE option PLANMGMT(BASIC) or (EXTENDED).
B.Use REBIND PACKAGE option REOPT(ONCE).
C.Use REBIND PACKAGE option OPTHINT.
D.Use REBIND PACKAGE option KEEPDYNAMIC(YES).
Answer:A

IBM   000-737 test answers   000-737 dumps

NO.10 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.
Answer:B

IBM pdf   000-737   000-737   000-737

NO.11 Which two accounting trace classes must be active when tracing package and DBRM related activity?
(Choose two.)
A.class 1
B.class 2
C.class 3
D.class 5
E.class 7
Answer:A E

IBM exam dumps   000-737 braindump   000-737 answers real questions   000-737

NO.12 There is a suspected problem with catalog table space DSNDB06.SYSDBASE. Should a problem be
discovered, which series of tasks could you run to analyze and resolve the problem?
A.Run DSN1CHKR against DSNDB06.SYSDBASE; run REPAIR DSNDB06.SYSDBASE as necessary.
B.STOP DSNDB06.SYSDBASE; run REPAIR DBD against DSNDB06.SYSDBASE as necessary.
C.START DSNDB06.SYSDBASE ACCESS(UT); run DSN1CHKR against DSNDB06.SYSDBASE; run
REPAIR DSNDB06.SYSDBASE as necessary, START DSNDB06.SYSDBASE ACCESS(RW).
D.STOP DSNDB06.SYSDBASE; run CHECK DATA to validate RI constraints; run DSN1CHKR
DSNDB06.SYSDBASE; run REPAIR DSNDB06.SYSDBASE as necessary, START
DSNDB06.SYSDBASE.
Answer:C

IBM answers real questions   000-737 original questions   000-737   000-737

NO.13 The DB2-supplied SQL Procedure Processor stored procedure DSNTPSMP requires which two for
execution? (Choose two.)
A.DB2 for z/OS REXX Language Support
B.Workload Manager SPAS with NUMTCB=1
C.Workload Manager SPAS with NUMTCB > 1
D.Optimization Service Center
E.Java Virtual Machine
Answer:A B

IBM   000-737 test questions   000-737   000-737   000-737

NO.14 An accounting report shows high class 3 times. Which three could contribute to the class 3 times?
(Choose three.)
A.elapsed time
B.not accounted time
C.page latch
D.service task switch
E.synchronous I/O
Answer:C D E

IBM   000-737   000-737   000-737

NO.15 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

IBM pdf   000-737 study guide   000-737   000-737 original questions   000-737 original questions

NO.16 By examining a DB2 accounting report, how can you determine if DASD I/O contention is a factor in a
poor performing application?
A.Divide the number of get pages by the number of synchronous I/Os.
B.Divide the synchronous I/O wait time by the number of synchronous I/Os.
C.Divide the asynchronous I/O wait time by the number of synchronous I/Os.
D.Divide the class 2 elapsed time by the number of synchronous I/Os.
Answer:B

IBM exam   000-737 pdf   000-737 dumps

NO.17 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.
Answer:D

IBM test   000-737   000-737 practice test   000-737 certification training

NO.18 In a data sharing system, a system programmer observes very high page p-lock contention. Which two
actions can they take to reduce this contention? (Choose two.)
A.Reduce row level locking for objects used in high volume transactions.
B.For table spaces defined with LOCKSIZE ANY, use ISOLATION(UR) for high volume query transactions
using these objects.
C.ALTER heavy used table spaces to use COMPRESS NO.
D.Ensure heavy used indexes are defined with COPY NO.
E.ALTER heavy used table spaces to use TRACKMOD NO.
Answer:A E

IBM exam dumps   000-737 test questions   000-737   000-737

NO.19 What is a benefit of using the in-memory work file in DB2 9?
A.Improves performance using TEMP database.
B.Avoids I/Os for the declared global temporary tables.
C.Improves performance for small sorts.
D.Sorts a large number of rows faster.
Answer:C

IBM   000-737   000-737 braindump   000-737   000-737 certification training

NO.20 You have to recover your complete DB2 system by image copies and the RECOVER utility. You start the
recovery with DSNDB01.SYSUTILX and DSNDB01.DBD01. Which table space must be recovered next?
A.DSNDB01.SPT01
B.DSNDB01.SYSLGRNX
C.DSNDB06.SYSCOPY
D.DSNDB06.SYSDBASE
Answer:C

IBM   000-737   000-737   000-737

NO.21 Your administrative scheduler shows message DSNA679I indicating that one or both copies of your
task lists is not accessible or is corrupted. Your analysis shows that only the VSAM file is corrupt, but the
ADMIN_TASKS table is still operational. Which statement describes how to correct this situation?
A.Create an empty version of the VSAM task list and let DB2 perform an autonomic recovery using the
content of the ADMIN_TASKS table.
B.Create an empty version of the VSAM task list and use REPRO utility to copy the contents of the VSAM
cluster containing the ADMIN_TASKS table.
C.Create an empty version of the VSAM task list and use DB2 command -RECOVER TASKLIST to
recover the content of the ADMIN_TASKS table.
D.No manual interaction is needed as long as the ADMIN_TASKS table is still accessible.
Answer:A

IBM   000-737 study guide   000-737   000-737 test questions   000-737 test questions

NO.22 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.
Answer:D

IBM certification training   000-737 pdf   000-737

NO.23 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

IBM   000-737   000-737   000-737

NO.24 Within which two DB2 address spaces may the execution of a DB2 stored procedure occur? (Choose
two.)
A.Workload Manager SPAS
B.Database Services (DBM1)
C.DB2-established SPAS
D.Distributed Data Facility (DDF)
E.System Services (MSTR)
Answer:A B

IBM   000-737   000-737 study guide

NO.25 A user job runs a very long time without commit and then the application abends. The job updated a
critical table that is used by many applications. The back out is taking a long time. Which statement
describes the appropriate action to take?
A.Cancel the DB2 system since this is a critical resource that is needed by many applications.
B.Issue the -CANCEL THREAD(token) NOBACKOUT.
C.Let DB2 continue with the back out.
D.Restart the system using the LBACKOUT=AUTO system parameter.
Answer:C

IBM   000-737 certification training   000-737 exam   000-737 certification training

NO.26 Which two statements regarding system parameters are true? (Choose two.)
A.Indexes can now be mapped to 8K and 16K buffer pools assigned by default using the system
parameter IDXBPOOL.
B.Implicit table space data sets are always defined at create time without a system parameter to override
this behavior.
C.Indexes can be compressed for an entire subsystem by setting the IDXCOMP system parameter to
YES.
D.The default for BIND option DBPROTOCOL can no longer be specified using the system parameter
DBPROTCL.
E.The amount of work file storage used by any one agent cannot be controlled via system parameters.
Answer:A D

IBM certification   000-737   000-737   000-737   000-737

NO.27 Which three statements are correct for automatic management of buffer pool storage in DB2 9?
(Choose three.)
A.You do not need to ALTER BUFFERPOOL with AUTOSIZE(YES) to enable this functionality.
B.DB2 provides sizing information to WLM.
C.DB2 communicates to WLM each time allied agents encounter delays due to read I/O.
D.DB2 periodically reports BPOOL size and random read hit ratios to WLM.
E.The automatic altered buffer pool sizes are resized to the original with the recycle of the DB2
sub-system.
Answer:B C D

IBM study guide   000-737   000-737 original questions   000-737 certification

NO.28 Which two methods can be used to configure the use of a SSL secure port on a DB2 for z/OS server?
(Choose two.)
A.Specify "Y" in the SECURE column of SYSIBM.SYSLOCATIONS.
B.Specify a secure port value in the PORT column of SYSIBM.SYSLOCATIONS.
C.Update the DDF statement in the BSDS using DSNJU003.
D.Specify the TCP/IP port number in the DRDA SECURE PORT field of the Distributed Data Facility Panel
2 (DSNTIP5).
E.Specify the value of the secure port in the DRDA PORT field of DSNTIP5.
Answer:C D

IBM exam prep   000-737 test questions   000-737

NO.29 You create a system level point-in-time recovery conditional restart control record with SYSPITR value
of FFFFFFFFFFFF. Afterwards, you run the RESTORE SYSTEM utility. Which statement is correct?
A.RESTORE SYSTEM does not do anything, because this SYSPITR value indicates a "no-operation".
B.The specified LRSN is an IBM internal SYSPITR value, reserved for serviceability only.
C.RESTORE SYSTEM fails because the SYSPITR value is outside the range of valid log points.
D.The whole DB2 data sharing group is recovered without log truncation.
Answer:D

IBM answers real questions   000-737   000-737 practice test   000-737

NO.30 Which privilege is required to use the ACCESS command?
A.DISPLAY
B.STARTDB
C.MONITOR
D.ACCESSDB
Answer:B

IBM exam   000-737 test answers   000-737

ITCertKing offer the latest 70-461 exam material and high-quality 650-304 pdf questions & answers. Our C_TSCM62_65 VCE testing engine and 000-122 study guide can help you pass the real exam. High-quality NS0-504 dumps training materials can 100% guarantee you pass the exam faster and easier. Pass the exam to obtain certification is so simple.

Article Link: http://www.itcertking.com/000-737_exam.html