I want to publish a mainframe Z/OS stored procedure as a web sphere - more or less according to this article: http://www.databasejournal.com/features/db2/article.php/10896%5F3784896%5F3/
We got the web-server installed and started, and the stored-proc deployed to it. When we clicked the "go" to test the web service we got an SQL error -444 security issue.
The WSAS/CE will start under the user=system, but not under the employees userid (with or without the windows domain - we are running on Win XP).
We are getting this error: com.ibm.datatools.dsws.shared.DSWSException: com.ibm.db2.jcc.am.io: USER PROGRAM S00007SP COULD NOT BE FOUND. SQLCODE=-444, SQLSTATE=42724
I think this is either security related or connection related.
So the question is how to get the web server to run and to access the mainframe stored proc? We clicked the "save" button on the user/pass in the database connections.
If the Web-Server is running under system - how and where do we specify the user that it should use for the access to the DB2 database to run the stored-proc? Would it not use the saved user/pass in the db-connections?
Thanks,
Neal Walters
Last minute update: We just tried to run the stored proc outside of web-server, and gettig same error. Still in research why...
Another late-breaking update: We tried another Stored proc and it worked. I'd still like to know more how some of the plumbing works though. Perhaps there was just an issue with that one StoredProc.