When specifying "A" for the acceptance option in the column SECURITY_IN in the SYSIBM.LUNAMES catalog table, which statement is correct?
A. An inbound ID is subject to translation.
B. A request does not need an authentication token.
C. With this option, VTAM cannot be defined with SECACPT=ALREADYV.
D. For outbound requests, the encrypted password is extracted from RACF.
The frequency of data being changed for several tables in the new Billing application is very unpredictable. A different approach to manage Runstats for these objects is desired. To provide additional information on update patterns for the new Billing Application, the DBA can use what information to better understand the unpredictable workload patterns on the tablespaces?
A. SYSIBM.SYSCOPY
B. SYSIBM.SYSSTATS
C. SYSIBM.SYSTABLES
D. SYSIBM.SYSTABLESPACESTATS
To monitor the storage used above and below the 2GB bar, what must occur?
A. Start a statistics class 1 trace.
B. Start a monitor class 1 and 2 trace.
C. Start an audit class 3 trace.
D. Start accounting class 7 and 8 traces.
When is changing an index from non-clustering to clustering NOT allowed?
A. If the table space is defined as member cluster.
B. If the data is not ordered by the new clustering index.
C. If the new clustering index is for a table that uses hash organization.
D. If the new clustering index OBID is greater than the old clustering index OBID.
Which DB2 trace has potentially the highest level of overhead, and should typically be run in specific situations and only for short durations?
A. The DB2 audit trace.
B. The DB2 statistics trace.
C. The DB2 accounting trace.
D. The DB2 performance trace.
How do you enable parallelism in a dynamic SQL statement?
A. BIND with DEGREE(1)
B. BIND with DEGREE(ANY)
C. Use SET CURRENT DEGREE = ANY
D. Use SET CURRENT DEGREE = '1'
What must be in place for the support of index compression?
A. User defined algorithm.
B. Compression dictionary.
C. Table space compression.
D. Page size larger than 4K.
Which of the following types of SQL statements are NOT eligible to be stored in the dynamic SQL statement cache?
A. MERGE
B. INSERT
C. SELECT
D. OPEN
The new billing application is seeing Class 2 Elapsed Time being made up of mainly Class 3 Synchronous database I/O time. All of the DB2 objects for the new billing application are in BP5. What command can be used to research the details behind the database I/O time associated with the new billing application?
A. DISPLAY DDF DETAIL
B. START TRACE(AUDIT)
C. DISPLAY BUFFERPOOL(*)
D. DISPLAY BUFFERPOOL(BP5) LSTATS(ACTIVE) DETAIL
What WLM action will establish performance objectives for DDF threads and their related address space?
A. Insure the NUMTCB is set to a value greater than 10.
B. Specify DDF for the value of APPLENV to the name of the WLM environment.
C. Execute the WLM_REFRESH stored procedure for the DDF application environment.
D. Create a WLM service definition that assigns service classes to the DDF threads.
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-612 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.