The workload requirement for a Web server running in Micro-Partitioned p5-550 has increased 300 percent over the past six months. The initial partition definitions assigned 0.5 processing units and one virtual processor to the Web server partition. Three months previously， an additional 0.5 CPU was added to the Web server partition. When the technical specialist attempted to allocate a further 0.5 CPU to this partition， no additional performance was achieved. Which of the following actions would most likely resolve the problem？（）A、Add another virtual Ethernet.B、Change the partition to be uncapped.C、Change the number of virtual processors to 2.D、Increase the amount of memory assigned to the partition by 300 percent.
The workload requirement for a Web server running in Micro-Partitioned p5-550 has increased 300 percent over the past six months. The initial partition definitions assigned 0.5 processing units and one virtual processor to the Web server partition. Three months previously， an additional 0.5 CPU was added to the Web server partition. When the technical specialist attempted to allocate a further 0.5 CPU to this partition， no additional performance was achieved. Which of the following actions would most likely resolve the problem？（）
- A、Add another virtual Ethernet.
- B、Change the partition to be uncapped.
- C、Change the number of virtual processors to 2.
- D、Increase the amount of memory assigned to the partition by 300 percent.
相关考题：
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?() A. the SQL text SQLB. the execution planC. the execution contextD. the execution frequencyE. the system change number (SCN)
What is the outcome of this block of code?() A. It creates a task and workload, and executes the task.B. It creates a task and workload but does not execute the task.C. It produces an error because a template has not been created.D. It produces an error because the SQL Tuning Set has not been created.
Which two statements about workload capture and replay operations are true?() A. The clients must be created manually on the test machines to perform more realistic testing.B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?（）A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.B. Run the Automatic Workload Repository Monitor (ADDM).C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
What is the purpose of configuring Workload Manager on a server used for development and QA？（） A、To experiment with shared processor poolsB、To isolate physical hardware between workloadsC、To control resource utilization on an application-by-application basisD、To leverage Workload Partition Manager for performance trending and analysis
Companycom is converting an application over to a p5 595 server with LPARs and has underestimated the processor requirements. The system has COD processors, but the customer does not know how to size the workload. What course of action would help identify the processor requirement?（）A、Activate the Trial COD for the processors and run a test to verify outcomeB、Activate the On/Off COD for the processors and run a test to verify outcomeC、Use rmss to simulate the processor workload and run a test to verify outcomeD、Use rmps to simulate the processor workload and run a test to verify outcome
The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile，and statistics to diagnose the possible causes of the performance degradation？（）A、by using the SQL access advisorB、by using the Automatic Workload Repository reportC、by running the Automatic Database Diagnostic Monitor （ADDM）D、by using the Automatic Workload Repository Compare Period reportE、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
What are two circumstances for which it may be advisable to use the silent uninstallation method instead of an interactive method？（）A、 The Administrator is unable to successfully export DISPLAY to a remote server.B、 IBM Tivoli Workload Scheduler is installed on a server for which there is no console access.C、 DNS is not working properly and the server cannot be accessed remotely to run the uninstallation script.D、 TCP on the server on which IBM Tivoli Workload Scheduler is installed is configured for half-duplex rather than full-duplex.E、 The remote IBM Tivoli Workload Scheduler server is multi-homed， thus the return connection to IBM Tivoli Workload Scheduler cannot be established thereby requiring the use of the silent uninstaller.
A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?（）A、db2advis -d proddb -i workload.sql -P B、db2advis -d proddb -i workload.sql -partitioning C、db2advis -d proddb -i workload.sql -m P D、db2advis -d proddb -i workload.sql -m ALL
What is the location for the application server scripts？ （）A、 wastools directory in IBM Tivoli Workload Scheduler bin directoryB、 wastools directory in IBM Tivoli Workload Automation home directoryC、 appserver directory in IBM Tivoli Workload Scheduler parent directoryD、 appserver directory in IBM Tivoli Workload Automation home directory
Which of the following virtualization options are unique to AIX and PowerVM compared to other UNIX based offerings？（）A、Software virtualization through PowerVM and hardware virtualization through IBM Systems Director.B、Hardware virtualization through Workload Partitions （WPARS） and software virtualization through PowerVM.C、Software virtualization through Workload Partitions （WPARS） and hardware virtualization through PowerVM.D、Hardware virtualization through Workload Partitions （WPARS） and software virtualization through IBM Systems Director.
Which of the following interfaces is required to implement Workload Partition Mobility? （）A、 Workload Partitions Manager for AIXB、 Hardware Management Console （HMC） GUIC、 Integrated Virtualization Manager （IVM）D、 Advanced System Management Interface （ASMI）
Which two prerequisites are needed for performing workload capture and replay？（）A、Close all sessions performing queries using database linksB、running the database in shared server modeC、The database on which the workload is replayed has to be a restore of the original database to a specific SCND、setting up the directory to capture the workload
The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）A、 LOG_BUFFERB、 DB_CACHE_SIZEC、 JAVA_POOL_SIZED、 LARGE_POOL_SIZEE、 SHARED_POOL_SIZEF、 STREAMS_POOL_SIZE
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?（）A、the SQL text SQLB、the execution planC、the execution contextD、the execution frequencyE、the system change number (SCN)
You use a SQL Server 2005 database named DB1， which is located on a server named SQL1. DB1 is in use 24 hours a day， 7 days a week. A recent copy of DB1 exists on a second server named SQLtest that also runs SQL Server 2005. You detect a high number of full scans on SQL1 and conclude that additional indexes in DB1 are needed. A workload file that is suitable for Database Engine Tuning Advisor （DTA） already exists. You need to analyze the workload file by using DTA. You must ensure maximum performance on SQL1 during analysis. You must also ensure availability during the implementation of any recommendations suggested by the DTA. What should you do？（）A、Store the workload file on SQL1. Start DTA on SQLtest and connect to SQL1. Specify all workload and tuning options as necessary. In the Advanced Tuning Options dialog box， select the Generate only online recommendations check box.B、Store the workload file on SQLtest. Start DTA on SQLtest and connect to SQLtest. Specify all workload and tuning options as necessary. In the Advanced Tuning Options dialog box,select the generate only online recommendations check box.C、Store the workload file on SQL1. Start DTA on SQL1 and connect to SQL1. Specify all workload and tuning options as necessary. In the Advanced Tuning Options dialog box，select the All recommendations are offline check box.D、Store the workload file on SQLtest. Start DTA on SQLtest and connect to SQLtest.Specify all workload and tuning options as necessary.In the Advanced Tuning Options dialog box,select the All recommendations are offline check box.
单选题The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）Aby using the SQL access advisorBby using the Automatic Workload Repository reportCby running the Automatic Database Diagnostic Monitor （ADDM）Dby using the Automatic Workload Repository Compare Period reportEby analyzing the output of the V$ACTIVE_SESSION_HISTORY view
单选题What is the purpose of configuring Workload Manager on a server used for development and QA?（）ATo experiment with shared processor poolsBTo isolate physical hardware between workloadsCTo control resource utilization on an application-by-application basisDTo leverage Workload Partition Manager for performance trending and analysis
单选题What is the location for the application server scripts？ （）A wastools directory in IBM Tivoli Workload Scheduler bin directoryB wastools directory in IBM Tivoli Workload Automation home directoryC appserver directory in IBM Tivoli Workload Scheduler parent directoryD appserver directory in IBM Tivoli Workload Automation home directory
多选题What are two circumstances for which it may be advisable to use the silent uninstallation method instead of an interactive method？（）AThe Administrator is unable to successfully export DISPLAY to a remote server.BIBM Tivoli Workload Scheduler is installed on a server for which there is no console access.CDNS is not working properly and the server cannot be accessed remotely to run the uninstallation script.DTCP on the server on which IBM Tivoli Workload Scheduler is installed is configured for half-duplex rather than full-duplex.EThe remote IBM Tivoli Workload Scheduler server is multi-homed， thus the return connection to IBM Tivoli Workload Scheduler cannot be established thereby requiring the use of the silent uninstaller.
多选题Which two prerequisites are needed for performing workload capture and replay？（）AClose all sessions performing queries using database linksBrunning the database in shared server modeCThe database on which the workload is replayed has to be a restore of the original database to a specific SCNDsetting up the directory to capture the workload
多选题You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process？（）Athe SQL textBthe execution planCthe execution contextDthe execution frequencyEthe system change number （SCN）
单选题Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment， you performed the workload capture on the production database to record the peak workload. You set up the test RAC databaseand want to replay the recorded workload on the testmachine. Note the following steps that you may require to replay the database workload： 1） Preprocess the captured workload. 2） Restart the database in RESTRICTED mode. 3） Set up the Replay Clients. 4） Restore the test database to the point when the capture started. 5） Remap connections. Arrange the steps required in the correct sequence to accomplish this task on the test machine.（）A 1，4，5，3 （2 is not required.）B 1，4，3，5 （2 is not required.）C 1，2，4，5 （3 is not required.）D 2，1，5，3，4 E 1，2，4，5，3
单选题Which of the following interfaces is required to implement Workload Partition Mobility? （）A Workload Partitions Manager for AIXB Hardware Management Console （HMC） GUIC Integrated Virtualization Manager （IVM）D Advanced System Management Interface （ASMI）
单选题A system administrator has a pSeries p5-520 2-way with AIX 5L V5.2 with a peak utilization of 50%. There is a request to add a new Web server for a small department. Which of the following solutions is the best fit for this environment？（）ACreate a dedicated LPAR for the existing workload and a Micro-Partition for the Web server. BCreate a dedicated LPAR for the existing workload and a dedicated LPAR for the Web server.CCreate a Micro-Partition for the existing workload and a dedicated LPAR for the Web server.DCreate a Micro-Partition for the existing workload and a Micro-Partition for the Web server.
多选题Which two statements about workload capture and replay operations are true?（）AThe clients must be created manually on the test machines to perform more realistic testing.BRestart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.CRestart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.DThe application state of the capture system must be identical to the application state of the replay system when the workload replay begins.