RE: Database exit points/exit programs (ODBC, SQL, QZDASOINIT) -- MIDRANGE-L

Did you also end the prestart jobs? 

My procedure is

ENDHOSTSVR *DATABASE 

ENDPJ SBS(QSERVER) PGM(QIWS/QZDASOINIT))

STRHOSTSVR *ALL (probabvly dont need *ALL, buts I do it just in case!)

If your doing WRKACTJOB to look at subsystem QSERVER, dont forget to
press F14 to see all the jobs.

When you run your ODBC/SQL request, the QZDASOINIT prestart jobs should
appear in QSERVER. Look at the joblog of the jobs to see if there are
any problems. If the jobs are not appearing in QSERVER it may well be
that the problem is causing the job to crash. Do WRKSPLF QUSER and look
for the joblog. 

When I had a similar problem, it was authority issues because QUSER was
not authorised to the exit program, or the library that the exit program
ran in. 

-----Original Message-----
From: McCallion, Martin [mailto:MccalliM@Midas-Kapiti.com]
Sent: Thursday, May 25, 2000 5:23 PM
To: 'midrange-l@midrange.com'
Subject: Database exit points/exit programs (ODBC, SQL, QZDASOINIT)


Hi all.

I'm having trouble with my first attempt at using exit programs.

I have written an exit program for the database exit points.  The
intention is to log incoming SQL statements, so that I can get an idea
of what is being sent by ODBC.  After an *extremely* long time searching
through the manuals I eventually found the parameter information that I
needed, and wrote the program.

I then registered it with each of the database exit points, QIBM_QZDA_*.
The program should determine which point it has been called from and log
information accordingly.

However, nothing I can do seems to get the program to run.  I ended and
restarted the database server with ENDHOSTSVR *DATABASE and STRHOSTSVR
*DATABASE.  I even changed the "Exit Program Number" of my exit program
to 1 at each exit point (I had entered it as 10 initially, thinking that
seemed like good practice; then I read somewhere that the database
servers always look for program 1) and stopped and restarted the server
again.  But it never executes (the program has a blank last used date,
for extra evidence).

What more do I have to do?  Stop and restart QSERVER?  IPL?

TIA,

Martin.

--                                                                     
Martin McCallion                 
Midas-Kapiti International
Work:  mccallim@midas-kapiti.com
Home: martin.mccallion@ukonline.co.uk

Apologies for the length of this sig, but company policy says:
This email message is intended for the named recipient only.  It may be
privileged and/or confidential.  If you are not the intended named
recipient of this email then you should not copy it or use it for any
purpose, nor disclose its contents to any other person.  You should
contact Midas-Kapiti International as shown below so that we can take
appropriate action at no cost to yourself.

Midas-Kapiti International Ltd, 1 St George's Road, Wimbledon, London,
SW19 4DR, UK
Email: Postmaster@midas-kapiti.com Tel: +44 (0)208 879 1188 Fax: +44
(0)208 947 3373
Midas-Kapiti International Ltd is registered in England and Wales under
company no. 971479

.:. 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to 
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: 
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---