Hi Kevin,

Thanks for reply. I had my question about "message waiting" because i read
it as "waiting message". So i thought it implied something like dead lock.

Thanks for sharing your experience about system naming and sql naming.

About user lib list, i think the concept about "trusted context connection"
could be interesting. It is feature of db2 later than 8.0, I think.
http://www.ibm.com/developerworks/data/library/techarticle/dm-0609mohan/

thanks and regards,

Yiyu Jia
On Wed, Apr 27, 2011 at 4:55 PM, Wai Hung Kevin Lau <whkevinlau@xxxxxxxxx>wrote:

Yiyu,

Take an example, you call a stored procedure (can be ILE RPG program) and
it hit
duplicated key, you will get message. Who is going to receive this
message? In
the green screen, your workstation. However, if it is a sever job....,
your
server will get this message. In database server, the QZDASOINIT job
created by
your connection will get it. The question is... the user will never know
what
happen. User just wait, unless you pass the message back.


My understand is that QZDASOINIT job will be started for a new connection.
The
user id should be QUSER (I am not sure now...) and the current user is the
user
id from the server connection property.

For me, I like to control the library list by user profile instead of by
setting
library list in connection string. If you use System Name, your life will
be
much simple. Use *LIBL, your setup will be same as your green screen
application because everything is by library list and user profile.
However, my
previous company use SQL when I joined it. I spent a lot of time to
convert it
back to System Name. If you use SQL, good luck!!!


Kevin




________________________________
From: yiyu jia <jia.yiyu@xxxxxxxxx>
To: Java Programming on and around the IBM i <java400-l@xxxxxxxxxxxx>
Sent: Wed, April 27, 2011 4:14:29 PM
Subject: Re: QZDASOINIT library list - JDBC

Hi Kevin,

What do you mean "If the server job has message waiting, you won't know it
because the message is by the job QZDASOINIT. "? Is it related to
something
like mutex?

I learned that QZDASONIT could be prestarted job. Will it be started by
QZDASRVSD when it is prestarted?

What I learned from this thread is that there is different behavior for
iSeries when the connection uses system naming or sql naming. I saw
somebody
always call a stored procedure to setup library list before any further sql
statement or stored procedure called. Do you guys think this is good
practice?

Yiyu Jia

On Wed, Apr 27, 2011 at 2:13 PM, Wai Hung Kevin Lau <whkevinlau@xxxxxxxxx
wrote:

I worked with this server job few years ago in my previous company. I'm
trying
to recall my memory.

When you connect to host by Client function, it will involved number of
Servers.
(please refers to IBM manual Series Access for Windows: Administration
Version 5
Release 4 Page 28).


Let's just consider the database server.

QZDASRVSD is the daemon program
QZDASOINIT is the Server program


When you connect to the database server, the daemon program will "create"
a
Server program for this connection. Actually, it is socket programming.
Your
can refer Scott Klement's website
(http://www.scottklement.com/rpg/socktut/tutorial.html) for details.

The QZDASOINIT is the server program for your connection. The connection
properties will be the key control for your library list. I only used
java.
Thus, I can only provide you the information by IBM toolbox. Please
refers
to
IBM manual IBM toolbox for Java V5R4 page 313. I remember it was working
if I
use *LIBL and System naming. As the connection used my User Id to
signon,
the
library list is based on user profile.


For me, there is a problem. If the server job has message waiting, you
won't
know it because the message is by the job QZDASOINIT. Our operators said
they
had no resources to monitor this kind of messages. Thus, I have to do
some
job
to override the message to my message queue. I made use the "Current
User"
to
do something. I forgot the details..... I was few years ago.....

Anyway, hope it help.

Kevin








________________________________
From: Alex Pinsky <apinsky@xxxxxxxxxxxxxxx>
To: Java Programming on and around the IBM i <java400-l@xxxxxxxxxxxx>
Sent: Wed, April 27, 2011 1:05:21 PM
Subject: RE: QZDASOINIT library list - JDBC

This is how it works in our environment

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:
java400-l-bounces@xxxxxxxxxxxx] On
Behalf Of Charles Wilt
Sent: Wednesday, April 27, 2011 12:48 PM
To: Java Programming on and around the IBM i
Subject: Re: QZDASOINIT library list - JDBC

James & Alan,

System naming is being used...so you're saying the LIBL is being set from
the
JOBD of the connecting profile?

Charles

On Wed, Apr 27, 2011 at 11:51 AM, Alex Pinsky <apinsky@xxxxxxxxxxxxxxx>
wrote:
In this case it is taken from job description that is assigned to the
user profile that is used to open connections in data source
definitions XML

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of James Perkins
Sent: Wednesday, April 27, 2011 11:46 AM
To: Java Programming on and around the IBM i
Subject: Re: QZDASOINIT library list - JDBC

I've noticed that if you set naming=*system, then library list seems
to be set correctly.
--
James R. Perkins


On Wed, Apr 27, 2011 at 05:57, Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

All,

I'm trying to understand how the library list is being set for a
QZDASOINIT job servicing a JDBC connection.

The JDBC connection specifies
libraries=*libl

Which as I understand it means use the default LIBL for the server
job. I would expect to see just the libraries specified in the
QSYSLIBL and QUSRLIBL system values.

However, when I look at an active job, I see that the LIBL isn't what
I'd expect. It looks as if the library list is being taken from the
JOBD specified on the user profile used to connect.

I don't recall it working like that. Is my memory going, or am I
missing something that resetting the LIBL of the QZDASOINIT job?

Thanks,
Charles
--
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: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take
a

moment to review the archives at
http://archive.midrange.com/java400-l.


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

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

CONFIDENTIALITY NOTE: The information contained in this email or fax
is intended only for the use of the individual or entity to whom it is
addressed. If you are not the intended recipient, you are hereby
notified that any disclosure, copying, distribution, printing or other
use of, or any action taken in reliance upon, the contents of this
email
or fax
and the information contained therein is strictly prohibited.
Before opening or using attachments, check them for viruses and
defects. Our liability to you for viruses or defects associated with
any email or fax is strictly limited to resupplying any affected
attachments. If you have received this communication in error, please
immediately notify the sender by telephone at (646) 264-6217 and delete
the
original message.
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: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/java400-l.


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

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

CONFIDENTIALITY NOTE: The information contained in this email or fax is
intended
only for the use of the individual or entity to whom it is addressed. If
you are
not
the intended recipient, you are hereby notified that any disclosure,
copying,
distribution, printing or other use of, or any action taken in reliance
upon,
the
contents of this email or fax and the information contained therein is
strictly
prohibited.
Before opening or using attachments, check them for viruses and defects.
Our
liability
to you for viruses or defects associated with any email or fax is
strictly
limited to resupplying
any affected attachments. If you have received this communication in
error,
please immediately
notify the sender by telephone at (646) 264-6217 and delete the original
message.
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: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.
--
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: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.




--
******************************************
* Mr. Jia Yiyu *
* *
* Email: jia.yiyu@xxxxxxxxx *
* *
* Web: http://yiyujia.blogspot.com/*
*******************************************
--
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: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.
--
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: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.