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 instalado
5722SS1 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 10
SF99504 13 No instalado
Debo instalar un ptf?
SF99114 - IBM HTTP Server fixpack level 8
SF99114 6 Instalado SF99291 - Java fixpack level 7
SF99291 5 Instalado
I’ve had higher levels at all products.. 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 extracted. 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 completed, 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 QWEBQRYADM
QWEBQRY76/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á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
Discover the new Windows Vista Learn more!
__________________________________________________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
_________________________________________________________________
Connect to the next generation of MSN Messenger
http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline
__________________________________________________
Forum.HELP400 es un servicio más de NEWS/400.
© 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
