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')
How can you create a dynamic location alias?
A. Use the CREATE ALIAS statement.
B. Issue the -MODIFY DDF ALIAS ADD command.
C. INSERT a dynamic alias row into SYSIBM.LOCATIONS.
D. Execute the DSNJU003 utility with a DDF ALIAS statement.
What happens in DB2 11 CM once you hit RBA x'FFF800000000' in a non-data sharing environment?
A. No updates are allowed.
B. DB2 terminates and can only be restarted in maintenance mode.
C. DB2 does not allow any activity except REORG SHRLEVEL CHANGE or REFERENCE.
D. No updates are allowed unless you migrated the BSDS to 10-byte RBA/LRSN format.
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.
A member of a DB2 data sharing group (DB2A) has failed and is currently down. After a few minutes the phone starts ringing and people complain that transactions accessing table space TSA (in database DBA) get an SQLCODE -904 because of retained locks held by the member that just abended.
What is the recommended way to resolve this problem?
A. -START DB(DBA) SP(TSA) ACCESS(FORCE)
B. Restart the failed DB2 member with the LIGHT(YES) option.
C. Delete all the failed persistent connections to the lock structure with the SETXCFFORCE,CONNECTION,STRNAME=lock_strname.CONNAME=ALL command and force the deallocation of the lock structure by issuing SETXCFFORCE,STRUCTURE.STRNAME=lock_strname
D. Issue the MODIFY irlmproc.PURGE. DB2A command from an IRLM that is used by a DB2 member that is still running.}
Which DB2 system table can limit the amount of resources that can be consumed based on client or IP address of the client?
A. SYSIBM.IPLIST
B. SYSIBM.IPNAMES
C. SYSIBM.DSNRLST01
D. SYSIBM.DSNRLMT01
One of your applications is experiencing long elapsed times. You notice from DB2 accounting data that 90% of the class 2 elapsed time consists of class 3 suspension time.
Which statement describes the behavior of the application?
A. The application is the victim of excessive performance tracing.
B. The application spends the majority of its time waiting on the network.
C. The application contains complex SQL statements that are CPU intensive.
D. The application spends the majority of its time waiting for buffer pool I/O and log I/O.
Which DB2 catalog or directory table space CANNOT be reorganized?
A. DSNDB01.SCT02
B. DSNDB01.SYSUTILX
C. DSNDB06.SYSTSCPY
D. DSNDB06.SYSTSPDO
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.
When might image copies be needed in a data mirroring environment during disaster recovery?
A. To resolve outstanding units of recovery.
B. If the RBA in the BSDS is higher than the RBA in the active log.
C. Image copies would never be needed when using data mirroring.
D. If a LOAD or RECOVER utility was active at the time of the disaster.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C2090-317 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.