Alguien puede comentar si algunos de Uds tienen una experiencia?
ID de mensaje . . . . : CPA0701 Gravedad . . . . . . . : 99
Tipo de mensaje . . . : Consulta
Fecha envío . . . . . : 21/10/08 Hora envío . . . . . . : 17:09:07
Mensaje . . . . : EDASTART ha recibido TCP1A77 en la sentencia *N. (C D I R)
Causa . . . . . : El programa de lenguaje de control (CL) EDASTART de la
biblioteca QWEBQRY76 ha detectado un error en la sentencia número *N. El
texto del mensaje de TCP1A77 es: STRTCPSVR se ha completado
satisfactoriamente; sin embargo se han producido errores.
Recuperación . : Este mensaje de consulta se puede evitar cambiando el
programa. Supervise en busca de un error (mandato MONMSG) y lleve a cabo la
recuperación de errores en el programa. Para continuar, elija un valor de
respuesta. !
Elecciones posibles de respuesta al
mensaje . . . : C -- Cancelar el programa CL.
D -- Volcar las variables del
programa CL y cancelar el programa CL.
Date: Tue, 21 Oct 2008 17:21:18 +0200From: [EMAIL PROTECTED]: [EMAIL
PROTECTED]: Re: Consulta Db2 web queryEl documento contiene información no
actualizada, revisa mejor lo que indican los APAR de IBM para db2 web queryA
ver, el grupo de PTFs SF99504 (base de datos) que tienes es antiguo, el ultimo
nivel es el 17.Y como indica el documento de instalar DB2 web query, lo grupos
de PTFs de Java y HTTP debes actualizarlos tambien.
El 21 de octubre de 2008 16:58, Carlos Pedrozo <[EMAIL PROTECTED]> escribió:
Hola forero; Encontre un documento que me resulto interesante para empezar a
trabajar con el Web Qry; si alguien tiene experiencia; mi consulta va en rojo.
Gracias por la ayuda. Carlos Pedrozo Just a few minutes ago (Around 10:30 in
the morning) i've received a package through DHL from IBM, which finally
contained the 5733-QU2 media. I've decided to write about my experiences with
the installation, and i'm typing this as i go through the install. The product
is a single cd, which i've put into my laptop, created a CD Image using
ImgBurn, and copied it to our i5/OS cd share. After that, i copied the CD image
to a model 515 for testing, added it to and image catalog, and mounted the
image. While this was happening, i studied the short included README note. It
contained a link to the DB2 Query for Web Getting started page. This page again
references APAR II14318, which contains the necessary PTF levels to install
this product. The installation guide is in the DB2 Web Query !
Install Guide. The first step was to verify that i had all required products
installed (using GO LICPGM, 10). There are multiple prereqs stated in multiple
documents, i've just combined these three lists into one: Tengo todo
instalado5722SS1 Option 3 - Extended Base Directory (installed by
default)5722SS1 Option 30 - Qshell (installed by default)5722SS1 Option 33 -
PASE (installed by default)5722DG1 IBM HTTP Server (installed by
default)5722JC1 IBM Toolbox for Java (installed by default)5722JV1 Option 8 -
J2SE 5.0 32bit (NOT installed by default) If you install a new licensed
program, it might be necessary to rerun the latest cumulative and group PTFs.
It makes sense to combine this with the next step. I've verified that my group
PTFs were current (using WRKPTFGRP): SF99504 - DB2 fixpack level 10SF99504
13 No instaladoDebo instalar un ptf? SF99114 - IBM HTTP Server
fixpack level 8 SF99114 6 Instalado SF99291 - Java fixpack
level 7 SF!
99291 5 Instalado I've had higher levels at all p
roducts.. If you're no current on PTFs, you might want to check my writeup
about installing PTFs with image catalogs. But there were more PTF requirements
to be met, and you'd also need some special PTFs depending on your language
feature code (It's all in APAR II14318). I've issued the following command to
retrieve the missing PTFs through my ESA internet connection:SNDPTFORD
PTFID((SI27813) (SI27814) (SI28336)) The usual QESECARE job started and used up
cpu time for about 10 minutes, and then a progress bar appeared. It started to
download the PTFs. These three PTFs are about 120MB in size.You'll also need to
download some more PTFs for use with web query itself. You can download them in
the same session, or later. The DB2 web query PTFs are about 650MB in size -
while this is not much, remember that IBMs servers are very, very slow - this
download can take about 2-4 hours. SNDPTFORD PTFID((SI28391) (SI28393)
(SI28399) (SI28406) (SI28582)) (Only use this command if you're!
using lang #2939, for other languages see APAR APAR II14318)After downloading
all these PTFs, i've started to reapply the current CUME/Groups (because i've
installed the J2SE 5.0 32bit Java product), and also the newly ordered
PTFs.After IPLing the machine, i checked if PTFs SI27813, SI27814 and SI28336
were successfully applied. They were. I also checked if all groups were marked
"Installed" using WRKPTFGRP. They were. I loaded the correct image catalog,
made sure that the correct disk was selected (F2939_01), and then issued the
installation command: RSTLICPGM LICPGM(5733QU2) DEV(OPTVRT01) After accepting
the license agreement, the installation started. After waiting for about two
hours (and watching the RST reaching more than 20′000 objects restored), the
installation finally succeeded. It's important to know that 5733QU2 needs quite
a lot of space, which is not documented anywhere from IBM's side. You'll need
650MB for CD Image, which needs about 3GB of space when ext!
racted. Add to that the space needed by PTFs (about 3-6GB), you're at
about 6-9GB of needed space. Those of you running a 595 with more than a
hundred 147GB arms might laugh at this, but the lowend 520 machines with two
mirrored 36GB disk drives might see this differently. I do wonder about the
final performance of this product, as several IBMers have stated the hardware
requirements to be extreme, but the statements are inconclusive because they
contradict each other:
Question from Rdandrew: What are the minimum hardware recommendations?Drmack
says: for any query/sql environment we recommend a minimum 8GB of memory per
CPU w/ V5R4. We have tested with 600 CPW machines and it runs well there.
Typically, 20-25 disk arms keeps your system balanced too.Question from Dblyth:
will the 515 express models run this effectively? they are limited to 8 disk
arms, 4 will be typical and 4GB memory will also be typical.Drmack says: Yes,
we think the 515 is a little powerhouse despite your picking up on the fact
that is may be under our guidelines for memory and disk I/O Source Most of our
customers are running IBMs (still expensive) low end machines - 270, 800, 520,
515 with 4 or less disk arms.Moving on, the next step is installing the 5733QU2
PTFs. This should be done before touching anything about 5733QU2. I started the
PTF installer and told it to apply PTFs immediately. This should save me from
IPLing the system again (the Java PTFs contained LIC !
fixes - needing an IPL). This procedure also needed a lot of time, about two
hours (same as the install). At first, the progress of a SAV command appeared,
that apparently saved all the files from the IFS into a savefile. After taking
it's sweet time compressing said SAVF, it started a RST command that extracted
files from another savefile. Basically, it reran the installation process again
(eating more and more time). This would explain why the 5733-QU2 PTFs have
nearly the same size as a single CD, but i wonder what IBM's excuse if for not
dealing with IFS based products more efficiently.While i'm waiting for the PTF
installation to finish, i'm pondering the time needed to do this. I've started
the whole installation thing at around 10:30, and it's 15:30 right now. That
means i've wasted about 5 hours just installing a product and it's necessary
PTFs. This wouldn't sound that bad if we were talking about a low end intel
server, but this is a high end server made by IBM, !
of which i expect the highest performance. A After the PTF procedure c
ompleted, i checked if PTFs SI28391, SI28393, SI28399, SI28406 and SI28582 were
applied correctly. They were. I continued the installation using the command:
CALL QWEBQRY76/REGWEBQRY The next steps were easy, and fully according to IBMs
documentation: CHGUSRPRF USRPRF(QWEBQRYADM) PASSWORD(mypw) GRPPRF(MRADMIN)
Porque se debe trabajar con QWEBQRYADM ? CALL QWEBQRY76/WQADDLIC 'myuser'Sign
on as QWEBQRYADMQWEBQRY76/STRWEBQRY From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]: Tue, 21 Oct 2008 15:42:30 +0200Subject: Re: Preguna db2
web query
Hola:
Nosotros hemos terminado de instalarlo.
Desde una pantalla de As400 con el usuario QWEBQRYADM arranca el qry: STRWEBQRY
Y desde tu navegador escribe lo siguiente:
http://nombre_de_tu_as400:11331/webquery
Espero que te sirva.
Saludos
E. Jurado
Dpto. Informática (F.Soria, S.A.)Tlf.:
914791512-------------------------------------------------AVISO DE
CONFIDENCIALIDAD:La información contenida en este mensaje y archivos adjuntos
es privada, confidencial y de uso exclusivo de la(s) persona(s) y entidad(es) a
la(s) que va dirigido. Si Ud. no es el destinatario de esta información se le
notifica que está expresamente prohibida la declaración, reproducción,
distribución o la toma de cualquier acción basada en el contenido de esta
comunicación. Si ha recibido este mensaje por error, le rogamos que nos lo
comunique inmediatamente y proceda a eliminarlo de todos sus sistemas.
Francisco Soria Melguizo, S.A. no asume responsabilidad legal por el contenido
de esta comunicación, ni representa la opinión de la firma, salvo que
expresamente se especifique lo contrario y que el remitente esté autorizado
para hacerlo. Gracias.
----- Original Message -----
From: Carlos Pedrozo
To: forum.help400
Sent: Tuesday, October 21, 2008 2:46 PM
Subject: RE: Preguna db2 web query
buen dia foro:Quiero hacer una consulta con respecto a WebQry (perdon por la
ignorancia); ya tengo instaldo los pgms :5733QU2 *INSTALLED IBM DB2 Web
Query for System i Option Base 5733QU2 *INSTALLED IBM DB2 Web Query for
System i Option 1 5733QU2 *INSTALLED IBM DB2 Web Query for System i
Option 2 5733QU2 *INSTALLED IBM DB2 Web Query for System i Option 4
Ahora bien desde donde se ejecuta el WebQry?. Mil gracias y perdon por hacer
una pregunta muy basica. Un saludo desde Paraguay (1 puesto en la eliminatoria
) Carlos Pedrozo
From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Mon, 20 Oct 2008 08:20:11
+0200Subject: Re: Preguna db2 web query
Hola Nicolas, ya he hecho las 2 cosas que sugieres.
Gracias
E. Jurado
Dpto. Informática (F.Soria, S.A.)Tlf.:
914791512-------------------------------------------------AVISO DE
CONFIDENCIALIDAD:La información contenida en este mensaje y archivos adjuntos
es privada, confidencial y de uso exclusivo de la(s) persona(s) y entidad(es) a
la(s) que va dirigido. Si Ud. no es el destinatario de esta información se le
notifica que está expresamente prohibida la declaración, reproducción,
distribución o la toma de cualquier acción basada en el contenido de esta
comunicación. Si ha recibido este mensaje por error, le rogamos que nos lo
comunique inmediatamente y proceda a eliminarlo de todos sus sistemas.
Francisco Soria Melguizo, S.A. no asume responsabilidad legal por el contenido
de esta comunicación, ni representa la opinión de la firma, salvo que
expresamente se especifique lo contrario y que el remitente esté autorizado
para hacerlo. Gracias.
----- Original Message -----
From: Nicolas Silva
To: forum.help400
Sent: Sunday, October 19, 2008 12:50 PM
Subject: Re: Preguna db2 web query
Hola todosDebes agregar el usuario a la licencia de dbdwebquery 5733qu2Por otro
lado tienes el usuario qwebqryadm que debes cambiarle la clave para
utilizarlo.Saludos.-- Nicolas SilvaMontevideo - Uruguay
__________________________________________________Forum.HELP400 es un servicio
m&#225;s de NEWS/400.&#169; Publicaciones Help400, S.L. - Todos los
derechos
reservadoshttp://www.help400.es_____________________________________________________Para
darte de baja visita la siguente
URL:http://listas.combios.es/mailman/listinfo/forum.help400
Discover the new Windows Vista Learn more!
__________________________________________________Forum.HELP400 es un servicio
m&#225;s de NEWS/400.&#169; Publicaciones Help400, S.L. - Todos los
derechos
reservadoshttp://www.help400.es_____________________________________________________Para
darte de baja visita la siguente
URL:http://listas.combios.es/mailman/listinfo/forum.help400
Connect to the next generation of MSN Messenger Get it now!
__________________________________________________Forum.HELP400 es un servicio
más de NEWS/400.© Publicaciones Help400, S.L. - Todos los derechos
reservadoshttp://www.help400.es_____________________________________________________Para
darte de baja visita la siguente
URL:http://listas.combios.es/mailman/listinfo/forum.help400
_________________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx__________________________________________________
Forum.HELP400 es un servicio m&#225;s de NEWS/400.
&#169; Publicaciones Help400, S.L. - Todos los derechos reservados
http://www.help400.es
_____________________________________________________
Para darte de baja visita la siguente URL:
http://listas.combios.es/mailman/listinfo/forum.help400
