RE: DB2 WEB Query Installed but....

Did you install the Language PTF for your Language?

Mentioned in APAR II14318

http://www-912.ibm.com/n_dir/nas4apar.nsf/c79815e083182fec862564c00079d1
17/19f34f5766e54eef8625732d003c677d?OpenDocument&Highlight=2,II14318

And you seem to be missing the Tomcat Application Server (the most
important piece)

Job: QP0ZSPWP

Check the logfiles in
/qibm/UserData/WebQuery/ibi/webfocus76/WQLWI7/logs/


And please verify that you have the PTFS

SI27813, SI27814 (sup'd by SI28336) and SI28336

Installed, applied.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark Allen
Sent: Monday, October 22, 2007 7:58 PM
To: Midrange Systems Technical Discussion
Subject: Re: DB2 WEB Query Installed but....

All PTF's should be applied latest cume, hiper, DB2, HTTP, Java, et al
and
the 3 you mentioned in your Blog (not the language specific ones)

Yep but just ended and restarted to make sure and the log has the
following:

[Mon Oct 22 13:23:10 2007] [notice] ZSRV_MSG0385: Apache configured --
resuming normal operations.
[Mon Oct 22 13:41:44 2007] [notice] ZSRV_MSG0387: SIGTERM received.
Shutting
down.
[Mon Oct 22 13:43:56 2007] [notice] ZSRV_MSG0385: Apache configured --
resuming normal operations.

and looks like everything else is running
WQLWI7 QTMHHTTP BCH .0 PGM-QZHBMAIN SIGW
WQLWI7 QTMHHTTP BCI .0 PGM-QZSRLOG SIGW
WQLWI7 QTMHHTTP BCI .0 PGM-QZSRHTTP SIGW
EDAPGWY QSECOFR BCI .0 PGM-EDAPGWY SELW
EDAPGWY QSECOFR BCI .0 PGM-EDAPGWY SELW
EDAPGWY QSECOFR BCI .0 PGM-EDAPGWY SELW
EDAPLOG QSECOFR BCI .0 PGM-EDAPLOG TIMW
EDAPTH QSECOFR BCI .0 PGM-EDAPTH CNDW
HLISNK QWEBQRYADM BCI .0 PGM-HLISNK SELW
JSCOM3C QWEBQRYADM BCI .0 PGM-JSCOM3C TIMW
TSCOM3 QSECOFR BCI .0 PGM-TSCOM3 SELW
TSCOM3 QSECOFR BCI .0 PGM-TSCOM3 SELW
TSCOM3 QSECOFR BCI .0 PGM-TSCOM3 SELW
TSCOM3 QSECOFR BCI .0 PGM-TSCOM3 SELW

and getting the 500 Internal Server Error
Internal Server Error

The server encountered an internal error or misconfiguration and was
unable
to complete your request.

Please contact the server administrator, [no address given] and inform
them
of the time the error occurred, and anything you might have done that
may
have caused the error.

More information about this error may be available in the server error
log.





On 10/22/07, Lukas Beeler <l.beeler@xxxxxxxxxxx> wrote:

Do you have all the PTFs applied, and restarted ALL webserver

instances

after doing so?

The logs are located here:

/qibm/UserData/WebQuery/ibi/webfocus76/WQLWI7/logs/

You should find a much more usuable error message there...

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark Allen
Sent: Monday, October 22, 2007 7:31 PM
To: Midrange Systems Technical Discussion
Subject: Re: DB2 WEB Query Installed but....

oops, I thought I had but obviously not since I am now getting a
different
error when it now actuallya ttempts to connect to:

http://our400:11331/webquery

Internal Server Error

The server encountered an internal error or misconfiguration and was
unable
to complete your request.

Please contact the server administrator, [no address given] and inform
them
of the time the error occurred, and anything you might have done that
may
have caused the error.

More information about this error may be available in the server error
log.


Thanks, I'll start digging into this tonight...



On 10/22/07, Lukas Beeler <l.beeler@xxxxxxxxxxx> wrote:

Did you run
CALL QWEBQRY76/REGWEBQRY

As QSECOFR?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark Allen
Sent: Monday, October 22, 2007 7:07 PM
To: Midrange Systems Technical Discussion
Subject: DB2 WEB Query Installed but....

Been thru the redbook followed the steps as far as I can tell but

keep

getting this msg when trying to do STRWEBQRY

qwebqry76/strwebqry
28900 - CALL PGM(QCMDEXC) /* The CALL command contains
parameters */
Job 794595/QWEBQRYADM/SRV76WFS submitted to job queue QSYSNOMAX in
library
QSYS.
29800 - STRTCPSVR SERVER(*HTTP) HTTPSVR(WQLWI7)
File QATMHINSTC in library QUSRSYS with member WQLWI7 not found.
Problem detected with instance file QATMHINSTC in library QUSRSYS.

I did a search on WQLWI7 and HTTPSVR and only thing mentioned is

that

there
would be 3 of the WQLWI7 jobs running

I am obviously missing something simple (but vital). Any ideas, no

big

rush, just trying to fit this in over lunch.............
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)

mailing

list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)

mailing

list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.