«
»

Installing 5733-QU2 aka DB2 Web query for System i V1R1M0

15. October, 2007

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:

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
SF99114 - IBM HTTP Server fixpack level 8
SF99291 - Java fixpack level 7

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)
CALL QWEBQRY76/WQADDLIC 'myuser'
Sign on as QWEBQRYADM
QWEBQRY76/STRWEBQRY

The next step was to bring 5733QU2 into it’s German language version – this actually needs extra steps, and it just shows that 5733-QU2 isn’t really integrated with i5/OS (yet?).

You’ll need to enter QSHELL command prompt using STRQSH.
Then you’ll need to enter a command to translate your installation

/qibm/proddata/webquery/ibi/srv76/home/bin/tsgult.out NLSCFG /qibm/userdata/webquery/ibi/srv76/wfs 500 DEU
This will translate according to the CCSID 500 and the german language. It’s important to know that the examples mentioned in the Web Query Install PDF do not work – you need to explicitly specify both the CCSID and the language!

Next step was logging onto web query:

http://IPADRESS:11331/webquery_html/wfconsole.htm

The page took about 5 seconds to load, but it worked!

I logged in using the QWEBQRYADM credentials, and i was logged in. In the top left corner we saw the recent developments of IBMs branding effort System: OS/400. Product names are very important, and in a new product like QU2, i want to see “i5/OS”, and not “OS/400″.

I clicked on the Configuration/NLS Settings button as instructed by the manual. I was greeted by this error message:

An HTTP 500 error has been returned when attempting to communicate with the WebFOCUS web components. The application server log contains information on why this error has occurred. Contact your WebFOCUS Administrator or Information Builders Customer Support Services for further assistance

My first try was to restart web query using QWEBQRY76/ENDWEBQRY, STRWEBQRY commands. This didn’t help.

After a bit of searching i found out that the logfiles are located in /qibm/UserData/WebQuery/ibi/webfocus76/WQLWI7/logs/. I found a few messages which could indicate the problem:

2007/10/15 15:42:55.090 SCHWER Webcontainer : com.ibm.ws.webcontainer.servlet.ServletWrapper : Uncaught service() exception thrown by servlet {0}: {1}([/console/wfconsolenls.jsp, java.lang.NullPointerException]) Thread[HttpServer : 4,5,main] ::class.method=com.ibm.ejs.ras.Tr.error() ::thread=HttpServer : 4 ::loggername=com.ibm.ejs.ras
2007/10/15 15:42:55.128 SCHWER Exception occured in com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter ::class.method=com.ibm.ws.ffdc.FFDCFilter.processException() ::thread=HttpServer : 4 ::loggername=com.ibm.ws.ffdc

java.lang.NullPointerException
at _ibmjsp.console._wfconsolenls._jspService(_wfconsolenls.java:91)
[snip]
2007/10/15 15:42:55.142 SCHWER Exception occured in com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest() ::class.method=com.ibm.ws.ffdc.FFDCFilter.processException() ::thread=HttpServer : 4 ::loggername=com.ibm.ws.ffdc

javax.servlet.ServletException
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:166)
[snip]
2007/10/15 15:42:55.204 SCHWER Webcontainer : com.ibm.ws.webcontainer.webapp.WebApp : [Servlet Error]-[{0}]: {1}([/console/wfconsolenls.jsp, java.lang.NullPointerException]) Thread[HttpServer : 4,5,main] ::class.method=com.ibm.ejs.ras.Tr.error() ::thread=HttpServer : 4 ::loggername=com.ibm.ejs.ras
java.lang.NullPointerException
at _ibmjsp.console._wfconsolenls._jspService(_wfconsolenls.java:91)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:85)
[snip]

I’ve tried a few more tricks, like changing the NLS configuration to 237 DEU, and removing the NLS configuration completely. Neither did work.

I’ve opened PMR 61859,212,848 on this. Let’s see how this turns out. Moving on, i’ve tried to logon to the end user interface:

http://10.33.2.200:11331/webquery/

I was greeted with a really ugly login page, and entered my userid and password. It seems to work fine so far, updates regarding the NLS problems will be forthcoming. It’s 17:19 now, and i’m going home.

Category: IBM i, POWER  |  Comment (RSS)  |  Trackback

45 Comments

  1. mark boyce:

    I shall be doing this once my ptf email has arrived! Another late night!

    18. October, 2007, 17:29

  2. Lukas Beeler:

    Should all work out fine, you’re from an english speaking country.

    All the issues i had so far were related to NLS issues.

    18. October, 2007, 17:48

  3. Garrett Otto:

    Excellent record of the complexity of the installation process. It really shouldn’t be this hard!

    29. October, 2007, 22:04

  4. Chris:

    I also am getting the HTTP 500 error when going to the NLS settings. Any fixes on this yet or know why it occurs?

    2. November, 2007, 17:48

  5. Lukas Beeler:

    Hi Chris,

    IBI is working on a fix, should be out next week.

    2. November, 2007, 17:49

  6. Alex Martinez:

    Hi Chris:

    News 5733QU2 PTFs are now available for “DB2 WEB QUERY NLS ENHANCEMENTS”

    Install SI28719,SI28766 and SI28765

    7. November, 2007, 17:33

  7. Chris:

    Web Query has been a total BUST for me and my company so far. Everytime we try to import a query from Query400 we receive this message: (FOC1562) EDAGET: FILE AUGUSTIPL_info2.txt NOT FOUND

    I am open for suggestions as IBM has no clue at this point. When in go into IFS and change the .txt to _info2.txt it will create report. Does anybody have any idea what the heck is going on? I have these PTFs in stalled:
    SI28766 Temporarily applied
    SI28765 Temporarily applied
    SI28719 Temporarily applied
    SI28406 Permanently applied
    SI28399 Permanently applied
    SI28393 Permanently applied
    SI28391 Permanently applied

    15. November, 2007, 19:43

  8. Alex Martinez:

    Hi Chirs:
    There is another DB2 Web Query PTF SI29225 to solve new issues
    http://www-912.ibm.com/a_dir/as4ptf.nsf/ALLPTFS/SI29225

    15. November, 2007, 21:46

  9. Alex Martinez:

    Ops, this PTF SI29225 its only for 2924.There is no equiv MRI PTF yet.

    16. November, 2007, 17:09

  10. Chris:

    Alex, have you seen this issue before??

    19. November, 2007, 19:22

  11. Laurens:

    Hi Guys,

    Last week i did the installation of 5733QU2 on a Systemi 570. I did not had any installation issues but i wanted to know if it is possible to change the decimal and thousand seperator and the currency symbol. By default this is set for US. Anyone an idea?

    Thx,

    Laurens (Belgium)

    22. November, 2007, 11:29

  12. Chris:

    My system is finally running DB2 Web Query. A business partner helped me solve my issue.

    27. November, 2007, 16:30

  13. Gene:

    Laurens – have you found an answer to your question yet?

    5. December, 2007, 20:03

  14. Tomasz:

    I’ve installed 5733QU2 on my 515 with V5R4. I’ve installed all necessary PTFs and run query like manual says.
    Problem is that when I try http://:11331/webquery/ I get 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.

    Any idea what’s wrong.

    Tomasz

    7. December, 2007, 20:49

  15. Alex Martinez:

    Tomasz:

    Possible reasons for an Internal Service Error 500 when trying to sign in to DB2 Web Query include:
    o J2SE 5.0 (5722JV1 Option 8) has not been installed on the system. Installing this should solve the problem.
    o Job QP0ZSPWP has not yet completed the Javaâ„¢ setup. Wait until job QP0ZSPWP goes into THDW status. Then, try signing in again.

    9. December, 2007, 19:28

  16. Tomasz:

    Hi.
    I have product 5722jv1 opt.8 installed properly.
    I only see jobs QP0ZSPWP in OUTQ status, all of them entered system few months ago. I don’t know what shall I do with QP0ZSPWP job.

    Tomasz

    10. December, 2007, 08:40

  17. Tomasz:

    I did some investigation, I know that QP0ZSPWP should be in QTMHHTTP subsystem, but there isn’t.
    I only have jobs like:
    QHTTPSVR QSYS SBS .0 DEQW
    ADMIN QTMHHTTP BCH .0 PGM-QZHBMAIN SIGW
    ADMIN QTMHHTTP BCI .0 PGM-QZSRLOG SIGW
    ADMIN QTMHHTTP BCH .2 PGM-QLWISVR JVAW
    ADMIN QTMHHTTP BCI .4 PGM-QZSRHTTP SIGW
    ADMIN CWTOST BCI .0 PGM-QYUNLANG TIMW
    WQLWI7 QTMHHTTP BCH .0 PGM-QZHBMAIN SIGW
    WQLWI7 QTMHHTTP BCI .0 PGM-QZSRLOG SIGW
    WQLWI7 QTMHHTTP BCI .0 PGM-QZSRHTTP SIGW

    Tomasz

    10. December, 2007, 09:20

  18. Rosemary Whiteley:

    I work on two 9406 – 520’s.

    I have also installed Web Query. (both machines, finally) I have also had more than one PMR’s. The newest PTF’s recommended to me are:

    Web Query: SI29225
    LWI: SI28971
    iSeries Access: SI27741 (look that one up!)

    Also it’s recommended I try using their qwqcent data as the problems may be that my data is corrupted.

    I am having trouble joining files. We are suppose to be able to access data on different machines (AS400’s), but apparantly its one file at a time. Anyone else having this trouble?

    18. December, 2007, 20:58

  19. Moody:

    I can’t get my users to be able to create synonyms. They receive FOC1220 and FOC1528 error. Any ideas???? IBM!!!!

    8. January, 2008, 20:41

  20. Rypke Paulusma:

    Tomasz – has your peoblem been solved yet? I see that you try to connect to http://:11331/webquery/. What is the IP address of the host? I think the URL should look something like http://xx.xx.xx.xx:11331/webquery/

    I used a wrong IP address and got exactly the same error message as you did.

    Rypke

    17. January, 2008, 15:50

  21. Tomasz:

    Hi Rypke.
    My url was correct (http://IP:11331/webquery/). I asked IBM to help me solving that problem. After few hour of making ’somthing’ that IBM asked me for (checking logs mostly) I was asked to do fallowing:
    1. stop HTTP server and QHTTPSVR subsystem
    2. perform CHGAUT OBJ(‘/QIBM/ProdData/HTTP/Admin/lwi’) AUTL(QLWISVR)
    and CALL PGM(QSYSDIR/QLWIEX03) PARM(V5R4M0 V5R4M0)
    3. Download and install PTF SI28336

    After these all webquery jobs started correct and I was able to run applictaion.

    Tomasz

    18. January, 2008, 07:57

  22. Taln:

    Hi
    Who can give me the concept of format filed in Db2 Web Query? In my database I have pack and zoned numeric field exam :
    Num1 2S 0
    Num2 3P 1
    When create metadata completed and select this table to make report it in the format column those field became change to new length.
    Num1 P3
    Num2 P4.1

    21. January, 2008, 05:09

  23. Hubert Housen:

    Hello,
    Today I installed 5733-QU2 R01M00 (2 CDs 2924)
    Our system primary language is 2963.
    Secundary language is 2924.
    After the installation of the license pgms the status installation of the 5733QU2 *BASE is *ERROR. (go licpgm – option 10)
    Is it possible to continue with this installation or is it better to order
    the CDs with language 2963 ?

    6. March, 2008, 16:07

  24. Jim:

    Hello,
    I have the sign on screen up and when I try to sign in it errors with
    Invalid user ID or password. Please try again. I have all the PTF’s installed. Please Help

    17. March, 2008, 13:22

  25. Jim:

    I got pass the Invalid user, now I have the HTTP 500 error.

    17. March, 2008, 16:29

  26. Carlos:

    Hi
    I have an error with webquery
    is a mistake to create the report assistant

    Failed to retrieve master due to exception:
    ibi.webfoc.wfmre.mrutil.WFMRError: Error occured, rc= 32019

    Can someone help me

    29. April, 2008, 00:21

  27. Dave:

    Hi,
    Thanks for all the above information, it really helped.
    I now have my login screen and when I enter my userid & password it says..
    “Invalid Userid or password. Please try again”

    I can see that my userid is registered by using the WRKLICINF PRDID(5733QU2) command.

    No matter what I try, I cannot login to this system.
    I have added MRADMIN as a group profile to my userid but still nothing.
    I have no problems logging in as QWEBQRYADM on the Admin website but for Web Query I cannot.

    Am I missing something here?
    Should the password of the userid I am using be the same as if I am accessing the System i via Client Access?

    So near yet so far….Help!!!??

    Dave

    10. May, 2008, 18:50

  28. Larry:

    Hi,

    I am having the same issue as Jim and Dave, ie I have no problems logging in as QWEBQRYADM on the Admin website but for Web Query I cannot. I have the sign on screen up and when I try to sign in it errors with Invalid user ID or Password. Please try again.

    Any suggestions ?

    Larry

    20. May, 2008, 21:33

  29. Ian:

    Hi

    We have the same problem as Moody (FOC1220) errors.

    Any suggestions ?

    4. June, 2008, 15:03

  30. mehmet:

    Failed to retrieve master due to exception:
    ibi.webfoc.wfmre.mrutil.WFMRError: Error occured, rc= 32019

    I have the same error code above Could somebody tell me what is the solution.

    Carlos had the same problem as I see

    9. June, 2008, 14:41

  31. Kent:

    Hi,

    I am having the same problems as Moody and Ian, we are getting error FOC1220 and FOC1528 when tying to create synonyms.

    12. June, 2008, 09:13

  32. Robin:

    I had the same ‘invalid user id’ etc. error as described above. Since it could make no difference I ran the commands Tomasz posted above, and it solved the problem. This code makes a stack of authority changes and ran for about an hour (development LPAR).

    However this just led to the FOC errors others are getting.

    12. June, 2008, 13:36

  33. Kent:

    Hi,

    I solved the problem i mentioned earlier by;

    1. Removing the license for user.
    2. Removing user.
    3. Adding user with high authority (same as earlier).
    4. Adding licens again whit upper case characters.

    Now it works as a charm…..

    16. June, 2008, 16:21

  34. Martin:

    Regarding the problem with logging in (Larry, Jim & David) – I had the same problem and resolved it by changing system value QLOCALE to en_gb.locale Bear in mind that we’re a GB customer and, presumably, change the en_gb part as appropriate.

    Now I can move on to the next part!

    Good luck.

    20. June, 2008, 10:08

  35. Stan:

    How does one get the demo library QWQCENT Library installed???? I have 5733-QU2 installed & working & the Red Book wants to do exercises in this demo data base. I can’t find it any where??????

    1. July, 2008, 01:54

  36. Nick:

    We had the “Invalid user id” problem but this was cured by changing the QLOCALE system value as per Martin’s post. Our latest problem is that when we try to add Metadata we get an SQL error (SQLCODE -30082) connecting to the local database.

    2. July, 2008, 12:47

  37. Martin:

    Stan,

    QWQCENT is found here
    ftp://www.redbooks.ibm.com/redbooks/SG247214/

    It’s part of the ‘Additional Materials’ section of the redbook SG247214 ‘Getting started with DB2 Web Query for System i’

    2. July, 2008, 13:01

  38. Martin:

    Nick,
    Somewhere there will be the full message with a reason code that lists the causes ;
    0 — Unknown cause.
    1 — Password expired.
    2 — Password not valid.
    3 — Password missing.
    4 — Protocol violation.
    5 — User ID not found.
    6 — User ID not valid. For a DB2 for i5/OS server, this could mean a damaged user profile or PASSWORD(*NONE).
    7 — User ID revoked or disabled.
    15 — Security processing at the server failed.
    16 — The new password is not valid.
    17 — The security mechanism requested by the client is not supported or allowed at the server. See recovery information below.
    22 — Security processing at the client failed.
    23 — CCSID conversion of the password failed.

    2. July, 2008, 13:07

  39. Nick:

    Apparently it’s a known problem. It is fixed by PTF SI31020, but there is a workaround for it by creating a data area:
    CRTDTAARA DTAARA(QSYS/QSQLICON) TYPE(*CHAR) LEN(7) VALUE(*PRVCHK)
    This seems to have cured the problem.

    2. July, 2008, 15:11

  40. Stan:

    Thanks Martin, I didn’t pick up on the FTP Site…

    2. July, 2008, 17:50

  41. Matthias:

    Hello another friends of iSeries,

    I am from Germany and I started installing WebQuery last monday. Unfortunately I became signon-problems and I think, that my probs are about the same, which some of you here described.

    When I activate the wfconsole it works but the i5-login doesn’t act and show me a message “Invalid user ID or password. Please try again”.

    I tried some of your suggestions except Tomasz’ CALL QLWIEX03, but nothing will improved.

    I am not sure to type this command. Could you help me to work ultimately with WebQuery.

    Thanks a lot.

    Best regards
    Matthias

    4. August, 2008, 13:03

  42. Hugo Gonzalez:

    Hello,
    I have the sign on screen up and when I try to sign in it errors with
    Invalid user ID or password. Please try again. I have all the PTF’s installed. Please Help

    10. November, 2008, 17:14

  43. Heiko:

    I have the same error as Carlos and Mehmet when calling the report assistant. Does anybody know how to solve the problem?

    Failed to retrieve master due to exception:
    ibi.webfoc.wfmre.mrutil.WFMRError: Error occured, rc= 32019

    best regards

    23. April, 2009, 11:15

  44. Hernán:

    Hi,
    I have the same error as Carlos, Mehmet and Heiko, this occurs when calling the report assistant and the report graphics:

    Failed to retrieve master due to exception:
    ibi.webfoc.wfmre.mrutil.WFMRError: Error occured, rc= 32019

    Can someone help me.

    26. August, 2009, 13:30

  45. Hernán:

    Resolution Problem rc = 32019
    Failed to retrieve master due to exception:
    ibi.webfoc.wfmre.mrutil.WFMRError: Error occured, rc= 32019

    1) Start in the command line AS/400: STRQSH

    2) Run /qibm/proddata/webquery/ibi/srv76/home/bin/tsgult.out NLSCFG
    /qibm/userdata/webquery/ibi/srv76/wfs 284 ESP

    Note: 284 = Page Code (DSPSYSVAL QCHRID)
    ESP = languaje ID
    This values are examples of my installation (Argentina / Spanish)

    3) Logon to:
    http://sysname:11331/webquery_html/wfconsole.htm with user QWEBQRYADM

    4) Click on NLS Settings, and select the client code page to be used. See
    Appendix B the IBM® DB2® Web Query for System i™ V1R1M0 and V1R1M1 Install
    Instructions

    5) Choose the client code page ( in my case: 137 = see Appendix B).

    6) Save.

    7) Re-Start the web query and try again.

    For consultans: hechenique@yahoo.com.ar

    29. August, 2009, 14:36

Leave a comment