MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

Re: TR5 and the ......



fixed

PLEASE Let me make this VERY clear.

TR5 is *NOT released nor generally available. The midrange.com community above all other communities MUST understand the difference between a TR and an MF PTF.

Technology Refresh groups for IBM i 7.1 are ordered as SF99707 in the same way as any other PTF group. This group will contain many PTFs both SI and MF. The current TR is TR 4 and among other PTFs it includes MF99004.

There is an MF99005 PTF that is available today. This PTF is NOT TR5. It does include the major LIC updates which are required for TR5 but does not provide the new function that TR5 has advertised.

Rule1: MF9900q is included in and is the primary LIC component of TRq.
Rule2: MF9900q is but a subset of TRq.

Let's all be clear when we reference TRq that we are speaking about SF99707 and that if you have TRq then you will see 'q' in WRKPTFGRP for SF99707.

If we are speaking only about MF9900q then please refer to that rather than the TRq. MANY of you will have MF99005 already as IBM is recommending that for systems with FC #5913 RAID cards, FC #5887 SAS drawers and the new 387GB SSD.

- Larry


On 10/10/2012 10:04 AM, rob@xxxxxxxxx wrote:
At COMMON I heard a couple of things.

First, at a Pete Massiello presentation it was recommended to purge
deleted records by doing a display file description to an output file and
querying that. All well and good, but you can bypass the output file and
just do this
select NUMBER_DELETED_ROWS, SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME,
SYSTEM_TABLE_MEMBER
from qsys2/syspartitionstat
order by number_deleted_rows desc
However, the performance is really slow. Which brings me up to my
question: Has IBM improved the performance of these view with either TR5
(out now) or the database group (due in November)? I thought I heard that
at COMMON but I can't find any references to this anywhere. Is this true?
Has anyone done some time trials on this?

Rob Berendt






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact