Minesh
>>>> There is I series group this needs to be moved to I series. Or OS/400 group. <<<<
>>>> There is a DB2 group also. <<<<
Kathy mentioned explicitly the product name of "DB2 Web Query". So, it is proper to move her question to the group named "IBM Db2 Web Query for i" as there is one such group. I see that she can also post the question in "IBM i Global" group because there are about a thousand members in that group and she stands a good chance of getting a useful response. There is no group named "I series" nor "OS/400".
Posting her question in DB2 group can potentially be a wasted effort because there are not many members there, if at all, who are familiar with DB2 Web Query for i and her question has nothing to do with any database function at all. It's about how DB2 Web Query uses an IBM i user profile to run its scheduled report job when the user's password changes since its last run.
------------------------------
Right action is better than knowledge; but in order to do what is right, we must know what is right.
-- Charlemagne
Satid Singkorapoom
------------------------------
Original Message:
Sent: Mon January 23, 2023 12:57 PM
From: minesh patel
Subject: Where is the iSeries User/password tied to a scheduled report?
There is a DB2 group also.
Original Message:
Sent: 1/23/2023 12:25:00 PM
From: Kathy Ried
Subject: RE: Where is the iSeries User/password tied to a scheduled report?
This is a DB2 Web Query problem, not an iSeries problem. The issue is when the scheduled report runs - it errors because it says User is not valid. But it is valid. That user can go into the DB2 Web Query report and run the scheduled job manually. The scheduler won't run it though.
------------------------------
Kathy Ried
Original Message:
Sent: Mon January 23, 2023 12:21 PM
From: minesh patel
Subject: Where is the iSeries User/password tied to a scheduled report?
There is I series group this needs to be moved to I series. Or OS/400 group.
Original Message:
Sent: 1/20/2023 9:15:00 AM
From: Kathy Ried
Subject: Where is the iSeries User/password tied to a scheduled report?
I have a user who writes her own DB2 reports and creates the schedules for them. Our system requires that we change our iSeries password every 90 days. So every time she changes her password, her scheduled DB2 Web Query reports do not run. Apparently they can't run because the password has changed. The scheduled log report says 'Task error: IBFSException 6000: Bad userid'. Her profile shows that there were 74 'Password verifications not valid' from last night's attempts to run her reports. Note: she does not use her iSeries User/password for anything else, she works outside of the iSeries otherwise.
Where/how is the userid/password attached to the scheduled report? is it on the report, or is it on the scheduling setup? My own scheduled reports, and others that also schedule reports, do not have a problem when changing password. Is there a setting that she may have set somewhere that is requiring the userid/password in order for the schedule job to run?
------------------------------
Kathy Ried
------------------------------