MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » April 2014

Re: V7R1 and MS Linked Server issues



fixed

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





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