MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » April 2014

Re: V7R1 and MS Linked Server issues



fixed

When V7R1 was installed in that partition, the required ptfs were
installed, but our OPS did not have the two "DLTF's" in their run notes
(they prepared the V7 install checklist several months before). The new
version of Memo to Users does say "failure to do so will result in having
to run RCLSTG *DBXREF" and that is what we had to do.
If anything, IBM should (if have not already) put the DLTF's into the new
resave.
Jim Franz

On Fri, Apr 18, 2014 at 7:57 AM, <rob@xxxxxxxxx> wrote:

Hopefully you will open a PMR on this and pursue with a passion.
Be quick about it.
IBM should be issuing a new resave of 7.1 to support TR8 and if this is a
problem with the upgrade then it should be fixed in that resave.


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
http://www.dekko.com





From: Jim Franz <franz9000@xxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Date: 04/17/2014 09:14 PM
Subject: Re: V7R1 and MS Linked Server issues
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Chuck,

I did see the change in the Memo to Users from Rob's note, we did do the
RCLSTG *DBXREF for whole system (single library RCLDBXREF failed
immediately with note that there were problems and a dedicated system
version for whole system must be run.
Ran Tues night, and had mostly good results.
All the files we cared about in existing apps now work from linked server.
Some other files tested did not, but the developers on that side of the
house
did not care.. We could not detect a pattern to the work/not work.
I used sql to compare systable rows (Verifying System Catalog Information
for ODBC Use:
http://www-01.ibm.com/support/docview.wss?uid=nas8N1019539
but could not see a difference
Thanks,
Jim Franz

----- Original Message -----
From: "CRPence" <CRPbottle@xxxxxxxxx>
Newsgroups: midrange.midrange-l
To: <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, April 17, 2014 6:26 PM
Subject: Re: V7R1 and MS Linked Server issues


On 15-Apr-2014 07:11 -0500, rob@xxxxxxxxx wrote:
On 15-Apr-2014 07:01 -0500, rob@xxxxxxxxx wrote:

The 7.1 Memo To Users was last updated in April 2014. Now, does that
sound recent to anyone?
On printed page 52, which is pdf page 64, there is a section flagged
as recently added. Check that out and see if that might be related to
your issue.
<
http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/rzaq9/rzaq9.pdf>

On 14-Apr-2014 13:08 -0500, J Franz wrote:
<snip>
This works for a few files, but most do not (have noticed new
files since upgrade have worked, but not verified always true).
</snip>

This makes it sound even more like a problem with the database cross
reference files.
New files created are updated successfully into the database cross
reference files, which are probably used by this service.
Old files are not 'right' in the database
--
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.







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