RE: Performance of large LF access path builds - SSD vs 10K spinny

Rob,

I'd like to test the Create Index in batch mode.
What do I need to set this up?

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, September 16, 2014 11:36 AM
To: Midrange Systems Technical Discussion
Subject: RE: Performance of large LF access path builds - SSD vs 10K spinny

You can specify UNIT SSD on the CREATE INDEX.
Now, this may not show up when prompting in STRSQL. Tough case (or some other more appropriate word).
But it is in the manual
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/db2/rbafzxcindx.htm


CREATE INDEX

The CREATE INDEX statement creates an index on a table at the current
server.
...
media-preference

.-UNIT ANY-.
|--+-UNIT SSD-+-------------------------------------------------|



Rob Berendt