Today it took more than 90 min to initiate db backup at db2 level where as admin schedule issues backup db command 90 min before and backup got completed. We will monitor closely.
Regards Sarav +65 9857 8665 > On 29 May 2023, at 3:29 PM, David L.A. De Leeuw <[email protected]> wrote: > > Hi Sarav > > We had a similar case, just yesterday. I noticed the daily full database > backup schedule was missed a number of days. > Then I found that five days ago the daily full backup just hanged. > Canceling the process hung as well on "pending". > > I contacted our system administrator and she reported that db2 got "stuck". > She rebooted the server, and the next backup ran as usual. > If this repeats, we will open a PMR as well. > > Our version: 8.1.17 > > Best wishes > > David de Leeuw > > -----Original Message----- > From: ADSM: Dist Stor Manager <[email protected]> On Behalf Of Saravanan > Palanisamy > Sent: Monday, May 29, 2023 12:17 AM > To: [email protected] > Subject: [ADSM-L] TSM db backup delayed or hung for more than few hours > > V8.1.18 > > We have noticed tsm backup started at tsm level but didn’t issue any message > to db2 and tsm level db backup appears hung > > db2 list utilities show details - No process db2diag.log - didn’t see any > message like ( Starting an online db backup ) > > Tried to restart tsm server to clear db2 hung process but no luck and db > backup again hung. > > Main issue here : > > When we start tsm db backup it’s not able start and archive log became full. > Tried to increase archive log few times. > > We tried almost 3 times ( we waited more than 1 hour ) but no luck. > > we always run db backup to clear archive log so that server will up and > running. > > Same issue observed on last week in different server and today one more > server. > > We have raised PMR to check this issue. > > Did anyone face this issue in v8.1.18 ? > > We have never seen this issue earlier but noticed after upgrade to v8.1.18 > > > Usually when we issue db backup command it will immediately start and we will > see tsmdbmgr sessions in tsm server. It looks like strange issue and causing > outage for production jobs. > > > Regards > Sarav > +65 9857 8665
