Re: Shared pool vs Private Pool for SQL

Fails on i 7.1 and i 7.2 with the PTF_TEMPORARY_APPLY_TIMESTAMP field not found. However seeing that doesn't appear to be critical, removing it allows the query to run on both. It returns no rows as expected.

inputting 90 days returns a long list so the query is operating correctly.

- Larry "DrFranken" Bolhuis

www.Frankeni.com
www.iDevCloud.com - Personal Development IBM i timeshare service.
www.iInTheCloud.com - Commercial IBM i Cloud Hosting.

On 12/9/2016 7:08 AM, Rob Berendt wrote:

What is this "I do not think there were PTFs" bs?

Paste this into Run SQL Scripts (granted I'm at 7.3 and they're at 7.1):

(comment dash) (comment dash) Recent PTF's
Select PTF_IDENTIFIER, PTF_PRODUCT_ID, PTF_PRODUCT_OPTION,
ptf_PRODUCT_RELEASE_LEVEL,
PTF_PRODUCT_DESCRIPTION, PTF_RELEASE_LEVEL, PTF_PRODUCT_LOAD,
PTF_LOADED_STATUS,
PTF_SAVE_FILE, PTF_COVER_LETTER, PTF_ON_ORDER, PTF_IPL_ACTION,
PTF_ACTION_PENDING,
PTF_ACTION_REQUIRED, PTF_IPL_REQUIRED, PTF_IS_RELEASED,
PTF_MINIMUM_LEVEL, PTF_MAXIMUM_LEVEL,
PTF_STATUS_TIMESTAMP, PTF_SUPERCEDED_BY_PTF, PTF_CREATION_TIMESTAMP,
PTF_TECHNOLOGY_REFRESH_PTF, PTF_TEMPORARY_APPLY_TIMESTAMP
From QSYS2.PTF_INFO
Where PTF_STATUS_TIMESTAMP>current timestamp - 33 days
and PTF_LOADED_STATUS<> 'LOADED'
Order by PTF_LOADED_STATUS, PTF_IDENTIFIER;

I used (comment dash) because two dashes in a row has an effect on list
servers.

Rob Berendt