IBM Support

Web Query - Are we using this product? Which version of Web Query are we using?

Question & Answer


Question

We are moving to new hardware and are checking license keys.   Are we even using WebQuery?
Our license keys are getting updated.   Are we using WebQuery?

Cause

Moving to new hardware.
Moving to new IBM i release.
License Keys are getting updated.

Answer

There isn't a perfect way to see if your company is using WebQuery.
First check which version of WebQuery is currently installed.   
Type WRKWEBQRY on your IBM i command line.
If you see this you have a previous version of WebQuery and it has not been supported since Sep 2016.   Work with your IBM Business Partner to get a current release.
WebQuery_QU2
If you see this screen with WRKWEBQRY you can see the release you have and group PTF information on the right side of the screen.
WebQuery_WQX
This example screen capture shows that WebQuery 2.3.0 is installed with group PTF 7.
Some things to check to check if your company is using WebQuery.
1) Refer to the WRKWEBQRY screen.  What do you see for Named Users, Runtime Groups, Dev Workbench users?
From the example WRKWEBQRY screen you are shown information for this LPAR (Usage Local) and a total for the entire LPAR complex (Count All - same hardware).
2) DSPSFWRSC
- what do you have for 5733QU2, 5733QU3, 5733QU4?
- what do you have for 5733WQX?
3) WRKOBJPDM LIB(QSYS) OBJ(QWEB*) OBJTYPE(*LIB)
See below for library descriptions.
4) WRKOBJPDM LIB(QSYS) OBJ(QWQ*) OBJTYPE(*LIB)
See below for library descriptions.
5) Use this SQL query to determine if any users have used WebQuery.  Only WebQuery 2.2.x or later.
select substr(NAME,1,10) as Users,     
       LASTLOGIN, STATUS               
  from QWQREPOS.UOA_USERS              
 where LASTLOGIN is not NULL           
 order by DESCRIPTION                  
;
List of WebQuery IBM i libraries.

QWEBQRC76 - Product library for 5733QU2 v1.1.0 & v1.1.1
QWEBQRC77 - Product library for 5733QU2 v1.1.2 

QWEBQRY76- Report Broker library for 5733QU2 v1.1.0 & v1.1.1
QWEBQRY77- Report Broker library for 5733QU2 v1.1.2  

QWEBQRYRPT - Product library for 5733QU3
QWEBQRYSDK - Product library for 5733QU4

QWEBQRY, QWEBQRYX, QWQREPOS - Libraries for 5733WQX

QWQCENT, QWQRETAIL - Sample data libraries for WebQuery.

List of WebQuery IBM i user profiles.

QWEBQRYADM - 5733QU2
QWQADMIN - 5733WQX
MRADMIN, MDUNTITLED - standard for 5733QU2, your company may still be using them with 5733WQX.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m50000000CabaAAC","label":"IBM i WebQuery-\u003EFrequently Asked Questions"},{"code":"a8m500000008jKuAAI","label":"IBM i WebQuery-\u003EInstall Uninstall Upgrade Migration"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]

Document Information

Modified date:
03 November 2022

UID

ibm16618005

Page Feedback