DB2 online backup hangs

PKPChuck · #1 (**permalink**) 04-02-09, 14:17

AIX 5.2
DB2 8.2 FP 15

The daily online backup has been hanging for 8 hours. After investigating, I didnt find any other application with locks. I tried forcing the application off, but it is still connected. Then I tried forcing everything off, and the backup is still connected.

It looks like the online backup is in a limbo state, and not sure how to stop it without stopping the instance.

Charlie

ARWinner · #2 (**permalink**) 04-02-09, 14:22

I had a backup hang once. Forcing the connect never did anything and the only way to fix it was to bounce the instance.

Andy

n_i · #3 (**permalink**) 04-02-09, 15:24

Try "db2 list utilities show detail" (or "db2pd -utilities") to see if there is any work being done by the backup.

PKPChuck · #4 (**permalink**) 04-02-09, 15:27

Quote:

Originally Posted by n_i

Try "db2 list utilities show detail" (or "db2pd -utilities") to see if there is any work being done by the backup.

Quote:

Originally Posted by output

Utilities:
Address ID Type Priority DBName StartTime NumPhases CurPhase Description
0x30103830 4016 BACKUP 0 TECRPT Thu Apr 2 05:30:06 2009 1 1 online db

Progress:
Address ID PhaseNum Description StartTime CompletedWork TotalWork
0x301039B0 4016 1 n/a Thu Apr 2 05:30:06 2009 19605538385 bytes 20206287790 bytes

These numbers don't appear to be changing.

PKPChuck · #5 (**permalink**) 04-06-09, 16:13

SOLUTION

After opening a PMR with IBM, they informed us we would need to bounce the instance to resolve the hanging backup.

db2stop force
ipclean -a
db2start

This resolved the issue.

Internet Services

Web Development

Digital Marketing

Consumer Tech