cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

DB2 latches

Go to solution
Former Member

on ‎08-08-2015 1:08 AM

0 Kudos

Hi All,

We have a online backup pending.

When checked we are seeing a latch preventing.

0x0780000001FCDC68 241847     0          /view/db2_v105fp_<>/vbs/engn/include/sqleSuspend_inlines.h 281        SQLO_LT_preventSuspendIOLotch 1

We are unable to release the same, is there a way to release the latches during the situations

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎08-13-2015 10:32 AM
0 Kudos

Hi,

Once I've faced that some storage layer locks remained on the disks and this caused similar hanging processes or threads on database.

Can you check your storage infrastructure if there are any locks or similar to that?

Regards,

Serhat

Show replies
Show replies
Former Member
‎08-13-2015 6:30 PM
0 Kudos

Serhat,

Storage wasnt the issue, had checked with the unix team as well.

What did you do last time when you faced the same issue?

Former Member
‎08-17-2015 10:14 AM
0 Kudos

Storage colleagues determined the locks through interface and removed them. Our storage is Netapp.

Former Member
‎08-17-2015 6:53 PM
0 Kudos

Oh ok. Thanks a ton for the information.

Answers (2)

Answers (2)

Former Member
‎08-12-2015 4:33 PM
0 Kudos

Hi,

the latches shouldn't be always a problem, what's the issue with the backup ? performance ? is it hanging ?

Regards,
Javier

Show replies
Show replies
Former Member
‎08-13-2015 12:31 AM
0 Kudos

Javier,

Yes true, latches arent always the problem. But if you see it was preventing IO. Not sure what was the significance of the same.

Basically the backup wasnt showing up in db2 list utilities. Even though db2bp and list applications were showing up as Performing a backup. So it meant it was hung. db2 force application (appl id) didnt work. killing db2bp didnt work.

So decided to restart the database.

Former Member
‎08-13-2015 10:24 AM
0 Kudos

Hi,

what's the value of parameter NUM_IOSERVERS ?  this might be set too low

db2 get db cfg for <sid> | grep NUM_IOSERVERS

Regards,
Javier

Former Member
‎08-12-2015 11:39 AM
0 Kudos

Hi,

Check your DB2-related or backup-related processes ones. If you see a related one to your error, try to kill it.

Use command:

ps -ef | grep db2

Regards,

Serhat

Show replies
Show replies
Former Member
‎08-13-2015 12:26 AM
0 Kudos

Serhat,

I did try all those options and it didnt work. Thats the reason raised the message.

Ask a Question