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

Sue,

I added "unit SSD" option to both CRTLF and CREATE INDEX.
No impact on times, 16 minutes for both, same as original run with "Unit *any"
While the IDX was building, I did a WRKSYSACT, I did see 4 jobs/tasks for the IDX build

Conclusion.
No difference in performance for IDX builds between SSD and 10k spinny.

Am I missing something?
Shouldn't the SSD be faster?

RUNSQL REQUEST('CREATE INDEX pauls/Paullf2 ON paulssd (EKNROV, EKACEC, EKBGO6, EKCNBR, EKNUO9, EKNUPA, EKCEK6) rcdfmt EKCPTT UNIT SSD')

Paul



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

RUNSQLSTM doesn't care.
https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014914890
And, it's like SEU is going to give you decent prompting for sql statements anyway.

It's time to ditch prompting for most of your sql statements. iNav uses a different approach with their 'Run SQL scripts' function. "Insert from Examples". Even then, if you rely upon that you are going to miss out on a whole lot of function available if you RTM.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "Steinmetz, Paul" <PSteinmetz@xxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
Date: 09/16/2014 02:14 PM
Subject: RE: Performance of large LF access path builds - SSD vs
10K spinny
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Rob,

What type of source member will this be?

Paul

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

Store your CREATE INDEX in a source member.
Submit a job that executes
RUNSQLSTM SRCFILE(MYLIB/MYSQLSOURC) SRCMBR(MYINDEX)


Rob Berendt