All host server jobs are running. When I try to connect I get a general security error. Here is
something we found that is a match for the problem, but not a match for the solution.
<snip>
ODBC General Security Error - Unable to Start Database Server
Problem Summary:
ODBC connections fail with the following message:
General security error, unable to start database server.
The joblog for the QZDASRVSD job in the QSERVER subsystem shows many instances of message CPF1887 -
Error occurred changing IPL attributes. This message is followed by many instances of message CPIAD07
RC5 - Starting of the host server job failed.
Resolution:
The *PUBLIC authority on the QGPL library was changed from *CHANGE to *USE. Once the authority was
returned to *CHANGE, ODBC worked without error.
</snip>
This is exactly what is happening, but the resolution is incorrect for us, QGPL is already at *CHANGE.
Sounds to me that there is an object a *USE that shouldn't be. How to find it is the problem...
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott
Klement
Sent: Friday, November 30, 2007 1:00 PM
To: Midrange Systems Technical Discussion
Subject: Re: JDBC Connectivity
Have you run STRHOSTSVR to start the servers that JDBC connects to?
For example, the following command should be sufficient for JDBC:
STRHOSTSVR SERVER(*DATABASE *SVRMAP *SIGNON)
If you plan to use other features of the Java Toolbox, though, it might
make sense to do the following instead:
STRHOSTSVR SERVER(*ALL)
Murphy, Mark wrote:
I am trying to connect to a V4R5 machine using JDBC, and the connection is not working. The same
connection works fine with a V5R2 machine, though I am not convinced that the issues are with the OS
release, but with which servers or Licensed Programs are installed on the box. I have tried looking
for server side requirements, but am unable to find them. Does anyone have a link or some
information
about what is required on the Server for JDBC to work?
Mark Murphy
Star Base Consulting, Inc.
e: murphym@xxxxxxxxxx
This e-mail transmission contains information that is intended to be confidential and privileged.
If you receive this e-mail and you are not a named addressee you are hereby notified that you are not
authorized to read, print, retain, copy or disseminate this communication without the consent of the
sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately
by informing the sender that the message was misdirected. After replying, please delete and otherwise
erase it and any attachments from your computer system. Your assistance in correcting this error is
appreciated.
midrange.com
