Re: JTOpen Tools DB2 SQL returning file not found after upgrading to V7R3

[John Eberhard <john@xxxxxxxxxxx>]

I suspect the problem is that the IASP information was removed from the
user profile.  I believe the default is to use the IASP associated with the
user profile.  If you want to set it in the JDBC application, you can use
the "database name" connection property when connecting using the JDBC URL.

On Wed, Oct 4, 2017 at 9:06 AM, Blalock, Bill <Bill.Blalock@xxxxxxxxxxxxx>
wrote:

> The problem seems to be caused by a CPF2110 error (Library not found).  I
> found the error in the QZDASOINIT job log, just prior to the SQL0204 error
> reported by the Java exception.
>
> This behavior began after upgrading from V7R1 to V7R3.
>
> The library is in a user ASP.  It appears that the DB2 JDBC is now
> searching SYSBASE and not the user  ASP for the library.
>
> Question 1:  Is there a setting on the AS400 which would effect this
> behavior?
>
> Question 2: From Java how do you control the ASP wich DB2 JDBC searches?
>
> Thanks all
>
> The information contained in this message is proprietary and/or
> confidential. If you are not the intended recipient, please: (i) delete the
> message and all copies; (ii) do not disclose, distribute or use the message
> in any manner; and (iii) notify the sender immediately. In addition, please
> be aware that any message addressed to our domain is subject to archiving
> and review by persons other than the intended recipient. Thank you.
> --
> This is the Java Programming on and around the IBM i (JAVA400-L) mailing
> list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/java400-l.