El documento contiene información no actualizada, revisa mejor lo que indican los APAR de IBM para db2 web query
A 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* <http://www.imgburn.com/>, 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*<http://www-03.ibm.com/systems/i/software/db2/webquery/gettingstarted.html>page. > This page again references > *APAR > II14318*<http://www-912.ibm.com/n_dir/nas4apar.nsf/c79815e083182fec862564c00079d117/19f34f5766e54eef8625732d003c677d?OpenDocument&Highlight=2,II14318>, > > which contains the necessary PTF levels to install this product. The > installation guide is in the *DB2 Web Query Install > Guide*<http://www-03.ibm.com/systems/i/software/db2/pdf/DB2_Web_Query_Install.pdf> > . > > 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*<http://projectdream.org/wordpress/2007/05/24/installing-system-i-ptfs-using-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*<http://www-912.ibm.com/n_dir/nas4apar.nsf/c79815e083182fec862564c00079d117/19f34f5766e54eef8625732d003c677d?OpenDocument&Highlight=2,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* <http://isociety.org/Chat20070815.html> > 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] > Date: Tue, 21 Oct 2008 15:42:30 +0200 > Subject: 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 <[EMAIL PROTECTED]> > *To:* forum.help400 <[email protected]> > *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] > To: [email protected] > Date: Mon, 20 Oct 2008 08:20:11 +0200 > Subject: 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 <[EMAIL PROTECTED]> > *To:* forum.help400 <[email protected]> > *Sent:* Sunday, October 19, 2008 12:50 PM > *Subject:* Re: Preguna db2 web query > > Hola todos > > Debes agregar el usuario a la licencia de dbdwebquery 5733qu2 > > Por otro lado tienes el usuario qwebqryadm que debes cambiarle la clave > para utilizarlo. > > Saludos. > > -- > Nicolas Silva > Montevideo - Uruguay > ------------------------------ > > __________________________________________________ > 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 > > > ------------------------------ > Discover the new Windows Vista Learn > more!<http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE> > ------------------------------ > > > __________________________________________________ > 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 > > > ------------------------------ > Connect to the next generation of MSN Messenger Get it now! > <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 >
__________________________________________________ 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
