Re: Change the job log settings on QZDASOINIT

Pete,

(Sorry about the late post)
Maybe you could try changing QZDASOINIT's Job Description
(QGPL/QDFTSVR) and change the log settings.

Another way could be using an exit program. Check a utility
called ODBCLOG, by Bob Pascas, at

http://www.rpgiv.org/ODBCLOG.htm

Hope this helps,

Luis Rodriguez

------------------------------

message: 6
date: Tue, 12 Feb 2008 13:01:43 -0700
from: Pete Helgren <Pete@xxxxxxxxxx>
subject: Re: Change the job log settings on QZDASOINIT

Thanks Antonio. Actually I am a HUGE fan of WRKODBCJOB.
It has helped
me out immensely over the years and has been an essential
part of any
ODBC or JDBC installation I do. The problem is, of
course, that
although the job logs are available while the connection
is active, once
terminated the joblog is gone, unless you make the
changes to the job
definition itself (which is what triggered the original
question)

Great to hear that others are getting good use out of
this great utility.

Pete


Antonio Fernandez-Vicenti wrote:

Pete,
not exactly what you're asking for, but sometime ago

found a very useful

a free utility WRKODBCJOB.
If you google for WRKODBCJOB you'll find many

references to it. One

leads you to Bryan Dietz home page (think he wrote it)

at

http://www.as400pro.com/tipView/category/Systems/key/376

There you'll find the link to his free WRKODBCJOB

utility.

As shown in his example on that page, when viewing info

about those jobs

you can (option 10) view their JobLog.

As mentioned, I found this very helpful. Worth to give

it a try.

Antonio

-------------------------------------------------------------------------------

Subject: Change the job log settings on QZDASOINIT
I have a problem with an application that uses ODBC

to connect to DB2

for i5/OS. For the customer, the quickest fix is to

stop and start the

application, which disconnects from the System i and

then restarts the

connections. However, the information in the

QZDASOINIT connection job

is lost. The job log isn't retained. I am pretty

sure that this is

because of the way the prestart job is defined but I

am not sure.

Anyone have a quick pointer on how to get a job log

retained when a

QZDASOINIT job is ended?
Thanks,
Pete

Luis Rodriguez

IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions


____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ