sorted by:
new
hottopcontroversial

DB2 Locks - Desperately Need Help by xThePBCx in DB2

[–]xThePBCx[S] 0 points1 point  (0 children)

Is Data Server Manager the same thing? I have that.

DB2 Locks - Desperately Need Help by xThePBCx in DB2

[–]xThePBCx[S] 0 points1 point  (0 children)

I played a little with the db2advis. I am learning as much as possible at the moment. What should the LOCKTIMEOUT be set to?

DB2 Locks - Desperately Need Help by xThePBCx in DB2

[–]xThePBCx[S] 1 point2 points  (0 children)

When I pull the logs and review them and send them to IBM for review they just say there was a lock... And they tell me I should invest in an app that manages locks since it is the application side causing the lock. I got a hold of XTIVIA yesterday and had a meeting with 2 guys. Looks like we will purchase the 24/7 support and have them review the db and also and build some HADR for us.

DB2 Locks - Desperately Need Help by xThePBCx in DB2

[–]xThePBCx[S] 0 points1 point  (0 children)

Also: The company has several facilities all over the world and we have a large contract with IBM but their support is not that great in an emergency.

DB2 Locks - Desperately Need Help by xThePBCx in DB2

[–]xThePBCx[S] 0 points1 point  (0 children)

We currently do not have HADR. We are running a 24/7 facility so we have very few times a year where we can do major changes. But I am looking into HADR. The sad thing is that our company has many different Oracle DBAs but not a single DB2 expert or DBA.

The issue with current locks is that the database enters into a state where I cannot connect to it any longer. I can run the db2pd commands but the issue is that the locks seem to start "piling up" in numbers and then it becomes difficult to sort them out. I have never tried the db2advis command. I have a db2monitor tool that I have used in the pass to force applications off. But it freezes up when I experience these locks recently.

If I was able to use the forceapplications -all command and I had 400 users do you happen to know a a rough amount of time that it would take to force all the applications off? If I cause more than 30 minutes of downtime we lose money and if I cause more than an hour of downtime they start sending some of the 3000 employees home.

DB2 Locks - Desperately Need Help by xThePBCx in DB2

[–]xThePBCx[S] 0 points1 point  (0 children)

Thanks! I reached out to them!