You need to create a partitioned table to store historical data and you issued the following command: CREATE TABLE purchase_interval PARTITION BY RANGE (time_id) INTERVAL (NUMTOYMINTERVAL(1,’month’)) STORE IN (tbs1,tbs2,tbs3) ( PARTITION p1 VALUES LESS THAN(TO_DATE(’1-1-2005’, ’dd-mm-yyyy’)), PARTITION p2 VALUES LESS THAN(TO_DATE(’1-1- 2007’, ’dd-mm-yyyy’))) AS SELECT * FROM purchases WHERE time_id < TO_DATE(’1-1-2007’,’dd-mm-yyyy’); What is the outcome of the above command?()
A new p5 customer has just installed a partitioned p5-550 alongside some older POWER4 servers. The pSeries technical specialist has received a call to say that the existing HMC (7315) cannot connect to the new server. How can the specialist help the customer?()
Which statements are true regarding system-partitioned tables?()
You need to create a partitioned table to store historical data and you issued the following command: What is the outcome of the above command?()
A customer currently has five partitioned POWER4 systems and is adding new systems. When the pSeries technical specialist introduces the first p5 system with CoD into this environment, how should the HMC be handled?()
When planning for a logically partitioned system,which of the following should be used as part of a review to ensure that each partition has the required resources? ()
Companycom is considering a large partitioned p5 590 to consolidate several smaller systems in their data center. Due to the complexity of the consolidation, the customer is asking the technical support specialist to give them a report which shows pre order PCI adapter placement and validates them against IBM's recommendations. The concern is that the factory will not install the adapters in the appropriate slots as the customer pre-selected. What IBM tool is available to provide this?()