Exam Code: C2090-918
Exam Name: System Administration for IBM Informix Dynamic Server V11
An application uses temporary tables which currently reside in the rootdbs. The DBA has just added a temporary dbspace called “tempdbs” but notices that none of the temporary tables are using the dbspaces. Which action would the DBA take to force the temporary tables into the temporary dbspace?
A. Set TEMP DBSPACE to “tempdbs”.
B. Add another temp dbspace since the temp dbspace must be full.
C. Set the onconfig parameter TEMPTAB_NOLOG to 1.
D. Drop and re-create the temp dbspace.
Given a datetime column, how should you find the last day of the month?
A. Convert the datetime to a date then call the LAST_DATE( ) function.
B. Use the MONTH_LENGTH() function.
C. Use the END_OF_MONTH() function.
D. Use the LAST_DAY() function.
Click the Exhibit button. After loading 1,000 rows into the orders table on February 22nd the query shown in the exhibit was run on February 28th. On which column should you run update statistics?
A. column customer.id constr_time 2007-02-27 11:36:57.00000 ustnrows 76.00000000000
B. column customer.name constr_time 2007-02-24 11:36:57.00000 ustnrows 66.00000000000
C. column orders.id constr_time 2007-02-20 11:36:57.00000 ustnrows 1066.00000000000
D. column orders.type constr_time 2007-02-27 11:36:57.00000 ustnrows 66.0000000000
Given the following:
14:45:29 DR: ping timeout
14:45:29 DR: Receive error
14:45:31 DR: Turned off on primary server
14:45:31 Checkpoint Completed: duration was 170 seconds. What are two time contributors to the checkpoint duration after a DR ping timeout? (Choose two.)
A. Time taken to flush DR buffers.
B. Time taken for secondary to respond, maximum which is determined by DRTIMEOUT.
C. Time used by the transport and network layers within operating system.
D. Time spent in I/O disk flush.
E. Time consumed in applying logs in the secondary.
Which isolation level do Remote Standalone Secondary servers (RSS) support?
B. Dirty read
C. Repeatable read
D. Cursor stability
A problem has been reported with the primary key constraint (customer_num), partnum 1048928 on the stores_demo:customer table (tabid of 100). Which command can be run to perform a check on that index?
A. oncheck -ci stores_demo:”informix”.customer#customer_num
B. oncheck -c index stores_demo:”informix”.customer
C. oncheck -cd stores_demo:”informix”.customer
D. oninit -check index 1048928
A database server has 10 dbspaces and each of them consist of four 2GB chunks. Onbar is used as the backup utility. The database administrator performs a whole-system backup everyday and it takes 10 hours to complete. What should be done to reduce the backup time?
A. Decrease the value of the BAR_XFER_BUF_SIZE configuration parameter.
B. Increase the value of the BAR_WORKER_MAX configuration parameter.
C. Increase the TAPEBLK size.
D. Increase the value of the BAR_MAX_BACKUP configuration parameter.
What are two benefits of enabling the automatic index replication feature (onmode -d idxauto on) in an HDR environment? (Choose two.)
A. It eliminates roll forward errors during recovery.
B. It transfers the index from the primary without rebuilding the index.
C. If the index is fragmented, it transfers only the affected fragment(s) to repair a corrupt index on
D. It blocks the primary server by performing the checkpoint before sending the index to the secondary.
E. It creates the index on the primary but not on the secondary server.
An Informix database server has been configured with the following arameters:
BAR_MAX_BACKUP 5 BAR_NB_XPORT_COUNT 4 BAR_XFER_BUF_SIZE 10 How many data buffers will be created during an onbar parallel backup operation?
If the user Informix is connected to a database called “stores_demo”, which command should be used to check the data for the part number shown?
A. Execute function admin(“CHECK DATA”, “1048927”).
B. Execute function sysadmin:admin(“CHECK DATA”, “1048927”).
C. Execute function sysutils:admin(“CHECK DATA”, “1048927”).
D. Execute function sysmaster:admin(“CHECK DATA”, “1048927”).
In IDS version 11, what are two performance gains by enabling private memory cache for every CPU VP? (Choose two.)
A. Provides less buffer cache overhead to manage.
B. Improves concurrency which usually involves mutex locking when the multiprocessor is turned on.
C. Increases control server memory allocation on large systems.
D. Increases privacy to memory content for all virtual processors.
E. Decreases VP access time to available memory blocks.
Given INFORMIXDIR is set to /usr/informix and INFORMIXSQLHOSTS is set to /sqlhosts.myinstall, where on the file system would you expect to find the actual sqlhosts.myinstall?
Which class of VP can only have a single VP allocated?
Which two apply to Kernel-Asynchronous Input/Output (KAIO)? (Choose two.)
A. KAIO resources are only allocated at system startup.
B. KAIO services I/O requests for only critical dbspaces.
C. KAIO does not require a switch between CPU and AIO virtual processors.
D. KAIO is started when mirror dbspaces exist.
E. KAIO is assigned based on the number of CPU VPs.
After an abnormal termination of IDS, you receive the following error in the message log when trying to restart the engine on a UNIX, Linux, or a MAC platform: oninit: Fatal error in shared memory creation shared memory already initialized Which corrective action should you take?
A. Use ipcs and ipcrm to delete orphaned memory segments.
B. Use onmode -z to reinitialize IDS memory.
C. Execute oninit -ty to restart IDS.
D. Use the memcheck utility to search for orphaned semaphores.
If you want to pass IBM C2090-918 successfully, donot missing to read latest lead2pass IBM C2090-918 dumps.
If you can master all lead2pass questions you will able to pass 100% guaranteed.