Re: TSM db backup delayed or hung for more than few hours
Hi Sarav, May I ask which tsm client version (dsmadmc) you are using? Can you please try to update it with the latest version and then re-try? I had a similar experience a few days ago and that helped! thanks Grüße Vikas Arora *e Mail* : vikar...@gmail.com On Mon, 29 May 2023 at 13:38, Saravanan Palanisamy < evergreen.sa...@gmail.com> wrote: > 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 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 On Behalf Of > Saravanan Palanisamy > > Sent: Monday, May 29, 2023 12:17 AM > > To: ADSM-L@VM.MARIST.EDU > > 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 >
Re: TSM db backup delayed or hung for more than few hours
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 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 On Behalf Of Saravanan > Palanisamy > Sent: Monday, May 29, 2023 12:17 AM > To: ADSM-L@VM.MARIST.EDU > 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
Re: TSM db backup delayed or hung for more than few hours
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 On Behalf Of Saravanan Palanisamy Sent: Monday, May 29, 2023 12:17 AM To: ADSM-L@VM.MARIST.EDU 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
