Re: Upgrading R&D LPAR from V6R1 to V7R1 TR7

On the same vein, does someone here still remember update woes going from
v4r5 to v5r2? Ancient history i know, EOL'ed i know, more than 10 years
without support, i know. but maybe someone remembers something... i'm about
to embark in one such update and feel like i'm in the dark...

Best regards,



On Tue, Nov 26, 2013 at 10:54 AM, Steinmetz, Paul <PSteinmetz@xxxxxxxxxx>wrote:

DSLO was created back in April on a test LPAR, one combined image for OS
and PTFs, now missing latest CUM and TR7.
The problem with making a new image is I don't have an LPAR with a clean
QGPL. (QGPL is part of the image)
Unfortunately, over the years, too much user data was created in QGPL.
I'm currently trying to figure out how to either update the image or find
the resources for a complete new image.
Production LPAR V7R1 will probably happen 1st quarter 2014.




-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Pete Massiello - ML
Sent: Tuesday, November 26, 2013 7:51 AM
To: Midrange Systems Technical Discussion
Subject: RE: Upgrading R&D LPAR from V6R1 to V7R1 TR7

I think you have an issue with your two "images". Before doing the
upgrade, I would examine the machine you made your DSLO image from, and
bring it up to the latest PTFs and then build you image again. Then when
loading the Production partition, I would insure that LIC, OS, and LPPs all
come from the same image.

Pete

--
Pete Massiello
iTech Solutions
http://www.itechsol.com
http://www.iInTheCloud.com





-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Steinmetz, Paul
Sent: Monday, November 25, 2013 2:38 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Upgrading R&D LPAR from V6R1 to V7R1 TR7

Chuck,

Here are the specific error details.
This error occurred on two different LPARS, I expect it to occur again on
my production LPAR.

5770SS1 V7R1M0 100423 Job Log
PENCOR06 11/23/13 01:05:03 Page 5
Job name . . . . . . . . . . : DSP01 User . . . . . . :
PAULS Number . . . . . . . . . . . : 605841
Job description . . . . . . : QSYSJOBD Library . . . . . :
QSYS
MSGID TYPE SEV DATE TIME FROM
PGM LIBRARY INST TO PGM LIBRARY INST
From module . . . . . . . . :
QSQPROC
From procedure . . . . . . :
OPEN_SYSROUTINE
Statement . . . . . . . . . : 49624
To module . . . . . . . . . :
QSQPROC
To procedure . . . . . . . :
DROP_ROUTINE
Statement . . . . . . . . . : 23943
Message . . . . : SQL CATALOG
QSYS2/SYSROUTINE HAS AN OLD FORMAT. AN IPL
MAY BE NEEDED.
Cause . . . . . : This message is
used by application programs as a general
escape message.
SQL0901 Diagnostic 50 11/23/13 00:38:20.529271
QSQPROC QSYS *STMT QSQPROC QSYS *STMT
From module . . . . . . . . :
QSQPROC
From procedure . . . . . . :
CLEANUP
Statement . . . . . . . . . : 51749
To module . . . . . . . . . :
QSQPROC
5770SS1 V7R1M0 100423
Job Log PENCOR06 11/23/13
01:05:03 Page 5
Job name . . . . . . . . . . : DSP01 User . . . . . . :
PAULS Number . . . . . . . . . . . : 605841
Job description . . . . . . : QSYSJOBD Library . . . . . :
QSYS
MSGID TYPE SEV DATE TIME FROM
PGM LIBRARY INST TO PGM LIBRARY INST
From module . . . . . . . . :
QSQPROC
From procedure . . . . . . :
OPEN_SYSROUTINE
Statement . . . . . . . . . : 49624
To module . . . . . . . . . :
QSQPROC
To procedure . . . . . . . :
DROP_ROUTINE
Statement . . . . . . . . . : 23943
Message . . . . : SQL CATALOG
QSYS2/SYSROUTINE HAS AN OLD FORMAT. AN IPL
MAY BE NEEDED.
Cause . . . . . : This message is
used by application programs as a general
escape message.
SQL0901 Diagnostic 50 11/23/13 00:38:20.529271
QSQPROC QSYS *STMT QSQPROC QSYS *STMT
From module . . . . . . . . :
QSQPROC
From procedure . . . . . . :
CLEANUP
Statement . . . . . . . . . : 51749
To module . . . . . . . . . :
QSQPROC
To module . . . . . . . . . :
QSQPROC
To procedure . . . . . . . :
DROP_ROUTINE
Statement . . . . . . . . . : 23943
Message . . . . : SQL CATALOG
QSYS2/SYSROUTINE HAS AN OLD FORMAT. AN IPL
MAY BE NEEDED.
Cause . . . . . : This message is
used by application programs as a general
escape message.
SQL0901 Diagnostic 50 11/23/13 00:38:20.529902 QSQPROC
QSYS *STMT QSQPROC QSYS *STMT
From module . . . . . . . . :
QSQPROC
From procedure . . . . . . :
CLEANUP
Statement . . . . . . . . . : 51749
To module . . . . . . . . . :
QSQPROC
To procedure . . . . . . . :
CLEANUP
Statement . . . . . . . . . : 51749
Message . . . . : SQL system error.
Cause . . . . . : An SQL system
error has occurred. The current SQL
statement cannot be completed
successfully. The error will not prevent
other SQL statements from being
processed. Previous messages may indicate
5770SS1 V7R1M0 100423 Job Log
PENCOR06 11/23/13 01:05:03 Page 6
Job name . . . . . . . . . . : DSP01 User . . . . . . :
PAULS Number . . . . . . . . . . . : 605841
Job description . . . . . . : QSYSJOBD Library . . . . . :
QSYS
MSGID TYPE SEV DATE TIME FROM
PGM LIBRARY INST TO PGM LIBRARY INST
that there is a problem with the
SQL statement and SQL did not correctly
diagnose the error. The previous
message identifier was CPF9898. Internal
error type 7112 has occurred. If
precompiling, processing will not continue
beyond this statement. Recovery .
. . : See the previous messages to
determine if there is a problem
with the SQL statement. To view the
messages, use the DSPJOBLOG
command if running interactively, or the WRKJOB
command to view the output of a
precompile. An application program
receiving this return code may
attempt further SQL statements. Correct any
errors and try the request again.
CPF87F8 Escape 40 11/23/13 00:38:20.529920
QZXMMRMX QDBXM *STMT QLPRPCPR QSYS 2158
From module . . . . . . . . :
DXXMRMX
From procedure . . . . . . :
SendMsg
Statement . . . . . . . . . : 3
Message . . . . : Unexpected
internal system error occurred in program
QZXMMRMX.
Cause . . . . . : An unexpected
error occurred in program QZXMMRMX. The

More...
internal error data is 1001 .
Recovery . . . : Look at the job log for
messages that indicate the reason
for the error.
CPF8356 Diagnostic 30 11/23/13 00:38:20.556594 QTNEND
QSYS 1C66 QTNENDAG QSYS 0190
Message . . . . : Commitment
control ended with 0 local changes not
committed.
Cause . . . . . : Pending changes
were rolled back because there were
changes not committed at the time
commitment control was ended for
commitment definition 31 with a
logical unit of work id

APPN.PENCOR06.X'ECC1DC0C3E91'.00001. There were 1 journals with a total of
0
record level changes. There were 0
object level changes. There were 0 API
commitment resources in the
commitment definition. Recovery . . . : No
recovery is required. Use the
COMMIT or ROLLBACK command before ending
commitment control to avoid this
situation. API commitment resources must be
removed using the Remove Commitment
Resource API (QTNRMVCR). Technical
description . . . . . . . . : The
commitment definition identifier is
X'1001010000000005A6C7'. The
activation group number is X'0000001F'. The
lock space id is
UDB_010000000005A6C7. The lock space associated space id is
1. The XID is

X'00000000000000000000000000000000000000000000000000000000000000000000000000

0000000000000000000000000000000000000000000000000000000000000000000000000000

0000000000000000000000000000000000000000000000000000000000000000000000000000

000000000000000000000000000000000000000000000000000000'.
CPF3D95 Diagnostic 40 11/23/13 00:38:20.569635
QLPRPCPR QSYS 30E4 QLPRPCPR QSYS 30E4
Message . . . . : Exit program
processing failed.
Recovery . . . : See the
previously listed messages to determine the cause,
and then try the request again.
CPD3DC3 Diagnostic 30 11/23/13 00:38:20.572733
QLPRPCPR QSYS 30E4 QLPRPCPR QSYS 30E4
Message . . . . : Product 5770DE1
option 2 release V7R1M0 processing not
complete.
Cause . . . . . : Product 5770DE1
option 2 release V7R1M0 could not be fully
saved or restored because
processing to complete saving or restoring library
QDBXM did not complete. Recovery
. . . : See the previously listed
messages to determine the cause,
and then try the request again.
CPD3DFD Diagnostic 30 11/23/13 00:38:20.572740
QLPRPCPR QSYS 30E4 QLPRPCPR QSYS 30E4
Message . . . . : *PGM objects for
product 5770DE1 option 2 release V7R1M0
not restored.
5770SS1 V7R1M0 100423 Job Log
PENCOR06 11/23/13 01:05:03 Page 7
Job name . . . . . . . . . . : DSP01 User . . . . . . :
PAULS Number . . . . . . . . . . . : 605841


-----Original Message-----
From: Steinmetz, Paul
Sent: Sunday, November 24, 2013 10:47 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Upgrading R&D LPAR from V6R1 to V7R1 TR7

Chuck,

Here's the error details.

ERROR PROCESSING VIEW USER_STG IN LIBRARY QSYS2.
ERROR PROCESSING VIEW USER_STG IN LIBRARY QSYS2.
ERROR PROCESSING VIEW USER_STG IN LIBRARY SYSIBMADM.
ERROR PROCESSING VIEW USER_STG IN LIBRARY SYSIBMADM.
ERROR PROCESSING VIEW VIEWS IN LIBRARY QSYS2.

Cross-reference notification 500 for request 0, type 2.
Job 605802/QSYS/QWCBTCLNUP ended on 11/23/13 at 00:09:30; 1.593 seconds
used;
ERROR PROCESSING VIEW USER_STG IN LIBRARY QSYS2.
ERROR PROCESSING VIEW USER_STG IN LIBRARY SYSIBMADM.

*PGM objects for product 5770SS1 option 2 release V7R1M0 restored.
18 objects restored. 18 objects not restored.
26 objects restored. 10 objects not restored.
28 objects restored. 8 objects not restored.

Objects for product 5770DE1 option 2 release V7R1M0 not restored.
Job 605812/QLPINSTALL/QBCHINST ended on 11/23/13 at 00:24:20; 4.323
seconds u
3 objects restored from QTEMP to QTEMP.
5770DE1 option 02 not installed in job 605812/QLPINSTALL/QBCHINST.
*LNG objects for licensed program 5770DE1 option 02 not installed.

CPF3D80 Diagnostic 20 11/23/13 00:24:20.660712
QLPINATO QSYS 1667 QLPINATO QSYS 1667
Message . . . . : 5770DE1 option 02
not installed in job
605812/QLPINSTALL/QBCHINST.
Cause . . . . . : Errors occurred
while installing *PGM objects for licensed
program 5770DE1 option 02 at
11/23/13 00:24:20. Recovery . . . : See
joblog 605812/QLPINSTALL/QBCHINST
for more information. Use the Display Job
(DSPJOB) command to display the
joblog. Correct any errors and then try the
request again.
CPF3D85 Diagnostic 30 11/23/13 00:24:20.682416
QLPINATO QSYS 1667 QLPINATO QSYS 1667
Message . . . . : *LNG objects for
licensed program 5770DE1 option 02 not
installed.
Cause . . . . . : The *PGM objects
for licensed program 5770DE1 option 02
are in error, not installed, or not
at the correct release level. The *PGM
objects for the licensed program
must be successfully installed before the
*LNG objects can be installed.
Recovery . . . : See previous messages in
the joblog to determine if the *PGM
objects for licensed program 5770DE1
option 02 failed to install.
Correct any errors, or install the required
licensed program. Then try the
request again.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Sunday, November 24, 2013 1:57 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Upgrading R&D LPAR from V6R1 to V7R1 TR7

On 23-Nov-2013 12:15 -0800, Steinmetz, Paul wrote:

V7R1 OS Upgrade from DSLO image using automatic install complete.
2 minor issues.

1) 5770DE1 2 DB2 XML Extender
resulted in error status. This also occurred on another partition
months back. I expect the same error on upcoming Production V7R1
upgrade.
Anyone else run into this

I am curious... Any clarification on what the details behind "this"
might be? Effectively, _the error_ versus _an error_ for which the
install failed, and thus left the option in an error status. That is, what
specifically were the errors that preceded the 'not installed'
error issued for that RSTLICPGM 5770DE1 OPTION(02) [as performed by the
user QLPINSTALL], as recorded in the LPP-install joblog?

Below is the fix.
1) IPL then signon as QSECOFR
2) DSPFFD QSYS/QADBXREF
- what do you see for the CCSID of the string columns?
3) CHGJOB CCSID() from step 2, the DSPFFD
4) CALL QSYS2/QSQXRLF (DLT QSYS2)
5) CALL QSYS2/QSQXRLF (CRT QSYS2)
6) CALL QSYS/QSQSYSIBM
7) CALL QSYS/QSQIBMCHK
Then run RSTLICPGM 5770DE1 OPTION(2).

Interesting. That seems to imply a dependence of that LPP option-2, on
some object(s) that should exist as part of a properly-installed OS
OPTION(01) "Extended Base" feature which is a pre-requisite to install of
any LPP. Makes one wonder if\what errors transpired in that other install
joblog, for which that prior LPP install had failed, but for which
apparently no similar notification of its failure was given.? But I recall
that, unfortunately, the joblog of that OS option(01) [kwd XTND] install
would have been /cleared/ if the install had been deemed to have been
successful [a general /feature/ of auto-install]. As such, any problem
would have to be inferred instead, from the side effects on any dependent
features, or perhaps from what the output of a CHKPRDOPT *OPSYS OPTION(01)
DETAIL(*FULL) might have revealed, issued before the corrective\recovery
actions were taken. Although as I recall [from when I was recruited to
remake that installation], I never updated the Check Product Option for
that option to fully diagnose any missing database file objects that were
created-into versus being shipped-as part of the option. Instead as I
recall, some implicit corrective action, the step
(5) of the above, would be performed [¿if a SQL catalog VIEW file was
missing?] so from the messages logged for that work, what objects were
missing might be inferred; and that I deferred improvement of the
notification of [any other] missing objects to the owners of the code.

2) PTF 5770HAS - SI50474 damaged status when attempting to apply.
Below is the fix:
- Delete SI50474
- Re-Order SI50474
- Load individually
- Apply individually

Hmm. That does not make much sense, unless the copy of that PTF was
obtained as /test/ vs being a final\GA copy. The standard recovery for a
PTF with a logically /damaged/ state, is to issue the LODPTF [irrespective
its current status] and then APYPTF for that just-loaded PTF. Notably...
the PTF should *not* need to be deleted [no DLTPTF] nor re-ordered [no
SNDPTFORD or equivalent]. Note that doing these operations
separately\individually from other PTF activity, AFaIK, should not be
necessary; beneficial, only to more closely reveal the progress of
processing just that one PTF, versus the clutter that would be seen when
loading and applying others at the same time.

The errors that were logged during the pre-damage apply [or remove]
processing would identify the origin for the status=damaged; i.e.
reveals the condition for which the process since refers to the PTF as
/damaged/ due to the prior inability to transition the PTF to the next
logical\requested status. Preventing the error(s) should prevent the PTF
being marked as /logically/ damaged when loaded and re-applied.

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

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

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

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