CRTLF tested with Unit(*SSD) parameter - 16 minutes, no difference in times.
Message . . . . : - CRTLF FILE(PAULS/CCEKLC3)
SRCFILE(SOURCELIB/SYSSOURCE) SRCMBR(CCEKLC3) UNIT(*SSD)
Does SQL use a different engine, would still like to test the SQL.
Where and how to set the unit parameter on SQL.
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of David Gibbs
Sent: Tuesday, September 16, 2014 10:23 AM
To: Midrange Systems Technical Discussion
Subject: Re: Performance of large LF access path builds - SSD vs 10K spinny
On 9/16/2014 9:06 AM, Steinmetz, Paul wrote:
If I do a CRTLF and set the unit parameter, instead of the CREATE
INDEX, will this be a valid test.
You can specify "UNIT SSD" when you create an index or table to set the preferred storage unit.
The Unit option also works on alter table & alter index.
david
--
IBM i on Power Systems: For when you can't afford to be out of business!
I'm riding a metric century (100 km / 62 miles) in the 2015 American Diabetes Association's Tour de Cure to raise money for diabetes research, education, advocacy, and awareness. You can make a tax deductible donation to my ride by visiting
http://email.diabetessucks.net. My goal is $5500 but any amount is appreciated.
See where I get my donations from ... visit
http://email.diabetessucks.net/mapdonations.php for an interactive map (it's a geeky thing).
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
