I have no idea how it got that way. I can only guess that when we built this partition there was an anomaly that nobody noticed, or we decided to go forward despite the warning message.
What do other shops do if they're a little bit behind on PTFs? Do they install the PTFs and the version upgrade in one outage window, or do they have two separate outages? Note that this is a test machine so we won't be affecting production yet.
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Wednesday, September 21, 2016 1:39 PM
To: Midrange Systems Technical Discussion
Subject: RE: [EXTERNAL] Re: Missing SYSIBM.SYSDUMMY1 object
Well, if applying a database group PTF replaces those missing objects,
and any right thinking person will be applying a database group ptf when
doing an upgrade,
then we can answer yes.
https://urldefense.proofpoint.com/v2/url?u=http-3A__www-2D01.ibm.com_support_docview.wss-3Fuid-3Dnas3b456521728163d1586257c23004ced27&d=DQICAg&c=3crv0V5Gxwbo5hXTsiQI6g&r=PkbfvkKxtcDeNvEOH5BjJL4QM0EQmj0cLL71lzl405I&m=JDXzAUhhvZ3BXc1uT-KFjKd_Ml8izkS7YayZ-Yc9d4Q&s=SerY-BOjbd2X2BJMeaebqve_NSOArXibEZf8MsPqRzc&e=
What did you do to your system to hose it up like this?
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
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.dekko.com&d=DQICAg&c=3crv0V5Gxwbo5hXTsiQI6g&r=PkbfvkKxtcDeNvEOH5BjJL4QM0EQmj0cLL71lzl405I&m=JDXzAUhhvZ3BXc1uT-KFjKd_Ml8izkS7YayZ-Yc9d4Q&s=A9uJTfNFhtcEl1jI0mL6ichoO4fqZoNOV9pt7NYqWJ0&e=
From: "Maassel, John R." <John_Maassel@xxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 09/21/2016 01:28 PM
Subject: RE: [EXTERNAL] Re: Missing SYSIBM.SYSDUMMY1 object
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
I was able to restore the object and rebuild the view. Thanks for the
advice.
Will upgrading from 6.1 to 7.2 replace any other missing objects?
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
CRPence
Sent: Wednesday, September 21, 2016 12:42 PM
To: midrange-l@xxxxxxxxxxxx
Subject: [EXTERNAL] Re: Missing SYSIBM.SYSDUMMY1 object
On 21-Sep-2016 10:55 -0600, Rob Berendt wrote:
I would think a restore is entirely feasible. Another option is to
use iNav and retrieve the SQL source used to create that table.
Another option is to stop using it. Most uses revolved around stuff
like this:
select current time from sysibm.sysdummy1
These can often be replaced with the VALUES or the VALUES INTO
statement
values current time
A distinction with a difference.?:
I expect more appropriate is to suggest that SELECT would be replaced
with the use of a VALUES-clause [aka the _row-values clause\expression_
or values-row] in the query that defines the VIEW. That clause can
generate a derived-table [of one or more rows], in place of a SELECT
that might otherwise be composed to utilize the SYSDUMMY1 in SYSIBM [or
my preference, use the physical table QSQPTABL in QSYS2]. That is to
suggest, the VALUES _statement_ and VALUES INTO _statement_ are
something entirely different, despite the former looking quite similar
syntactically, neither of which can be referenced directly within a VIEW.
--
Regards, Chuck
--
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://urldefense.proofpoint.com/v2/url?u=http-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DQICAg&c=3crv0V5Gxwbo5hXTsiQI6g&r=PkbfvkKxtcDeNvEOH5BjJL4QM0EQmj0cLL71lzl405I&m=vPYGc0BgzrcFeCpRW0QeimCM4wD4BXLsFhA2LhR92UU&s=y56AHrPso7wJBDhemmUJhzTO00vaQK_RTTEvaRjzkwc&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://urldefense.proofpoint.com/v2/url?u=http-3A__archive.midrange.com_midrange-2Dl&d=DQICAg&c=3crv0V5Gxwbo5hXTsiQI6g&r=PkbfvkKxtcDeNvEOH5BjJL4QM0EQmj0cLL71lzl405I&m=vPYGc0BgzrcFeCpRW0QeimCM4wD4BXLsFhA2LhR92UU&s=SXaznuxqo8i7XcGoX7l0DqqJrbYO8aJTJbaLn_FYq-8&e=
.
Please contact support@xxxxxxxxxxxx for any subscription related
questions.
________________________________
Notice from Bob Evans Farms: This e-mail message, including any
attachments, may contain confidential information that is intended only
for the person or entity to which it is addressed. Any unauthorized
review, use, disclosure or distribution is strictly prohibited. If you are
not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message and any attachments.
--
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://urldefense.proofpoint.com/v2/url?u=http-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DQICAg&c=3crv0V5Gxwbo5hXTsiQI6g&r=PkbfvkKxtcDeNvEOH5BjJL4QM0EQmj0cLL71lzl405I&m=JDXzAUhhvZ3BXc1uT-KFjKd_Ml8izkS7YayZ-Yc9d4Q&s=TSfybWa5rAt2YQgLKUDsWowGs8A3A1P_fhfHP5qtS0s&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://urldefense.proofpoint.com/v2/url?u=http-3A__archive.midrange.com_midrange-2Dl&d=DQICAg&c=3crv0V5Gxwbo5hXTsiQI6g&r=PkbfvkKxtcDeNvEOH5BjJL4QM0EQmj0cLL71lzl405I&m=JDXzAUhhvZ3BXc1uT-KFjKd_Ml8izkS7YayZ-Yc9d4Q&s=xh0lcOteEcgJpkuFaUrOr0BWRjnfdGbbIYkIrf4uNiI&e= .
Please contact support@xxxxxxxxxxxx for any subscription related
questions.
--
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://urldefense.proofpoint.com/v2/url?u=http-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DQICAg&c=3crv0V5Gxwbo5hXTsiQI6g&r=PkbfvkKxtcDeNvEOH5BjJL4QM0EQmj0cLL71lzl405I&m=JDXzAUhhvZ3BXc1uT-KFjKd_Ml8izkS7YayZ-Yc9d4Q&s=TSfybWa5rAt2YQgLKUDsWowGs8A3A1P_fhfHP5qtS0s&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://urldefense.proofpoint.com/v2/url?u=http-3A__archive.midrange.com_midrange-2Dl&d=DQICAg&c=3crv0V5Gxwbo5hXTsiQI6g&r=PkbfvkKxtcDeNvEOH5BjJL4QM0EQmj0cLL71lzl405I&m=JDXzAUhhvZ3BXc1uT-KFjKd_Ml8izkS7YayZ-Yc9d4Q&s=xh0lcOteEcgJpkuFaUrOr0BWRjnfdGbbIYkIrf4uNiI&e= .
Please contact support@xxxxxxxxxxxx for any subscription related questions.
________________________________
Notice from Bob Evans Farms: This e-mail message, including any attachments, may contain confidential information that is intended only for the person or entity to which it is addressed. Any unauthorized review, use, disclosure or distribution is strictly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message and any attachments.
midrange.com
