Re: Files in QTEMP

I know that the total ASP is about 90000 GB and all of it is not SSD, but
don't know what % is SSD.

We are running V7R2M0

The empty tables (and index over it) exist, and I am creating a copy in
QTEMP using CRTDUPOBJ. I was thinking of moving the table and index to SSD
after creation using CHGPF and CHGLF commands.

In the program I write, read back, update couple of million records in
table, hence wanted to see if moving it to SSD would give me any
performance improvement.

I am not aware of any other SSD parameters.

On Mon, Aug 20, 2018 at 5:40 PM, Evan Harris <auctionitis@xxxxxxxxx> wrote:

Hi Vinay

you don't say anything about the SSD or ASP configuration on the box in
question so it's hard to know where to start.

What is the SSD set up on the machine you are asking about ? If it is all
SSD then everything gets created in SSD anyway.

What version of the OS are you on (it makes a difference)

How are you creating the tables ? Have you looked at any of the SSD
parameters if applicable when creating them ?

On Tue, Aug 21, 2018 at 9:13 AM, Vinay Gavankar <vinaygav@xxxxxxxxx>
wrote:

I assume my question was silly, since I cannot believe that no one knows
the answer to it, if the question made sense.

I tried creating it on the development box, but even though it creates

the

file, since the box does not have SSD, I cannot judge any performance.

On Fri, Aug 17, 2018 at 7:07 AM, Vinay Gavankar <vinaygav@xxxxxxxxx>
wrote:

Hi,

Is there any performance advantage by creating the physical and logical
files created in QTEMP by my batch job in SSD? Will the system actually

use

SSD or ignore the request?

Vinay

--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--

Regards
Evan Harris
--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD