Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only
  • 1.  Report Server not running

    Posted 04/08/21 07:08 PM

    I'd like to attempt to schedule a report but just realized that the report server doesn't seem to be running. Web query has been functioning fine but we do not schedule anything currently. I'd like to figure out how to schedule a report and send the xls output directly via email. I believe that can be done but something seems to not be running correctly as I have no report broker console???






    #Db2
    #Support
    #SupportMigration


  • 2.  RE: Report Server not running

    Posted 04/12/21 03:34 PM

    Hi,

    Please verify that all ports are active using the WRKWEBQRY command. If ports 12332 through 12335 are inactive or partially active, this would indicate a problem with the reporting server.

    Also, which edition of Web Query are you using? You can check by using the WRKWEBQRY command and looking at the value for "Active Edition" on the right side of the screen. Scheduling reports is only available with the Standard or Scheduler editions. If you are using one of these, port 12339 should be active.






    #Db2
    #Support
    #SupportMigration