f



Lock Mgr consuming 54G

Hello,

DB2 9.7 on a Linux server which has �TB of RAM:
In db2top's memory view, it states that the Lock Mgr is consuming 54G. 
This seems absurdly high to me. It seems that this value was chosen 
automatically:

$ db2 get db cfg |grep -i lock
 Max storage for lock list (4KB) (LOCKLIST) = AUTOMATIC(13692896)

Is there any conceivable reason why such a big lock list would ever be 
needed?

I would like to use as many automatically computed parameters as 
possible, except when it results in absurd results. Is there at way for 
me to influence the automatic calculation of the LOCKLIST value, without 
having to hard-code it completely?

It seems that DB2 needs to be restarted in order to change the value(?). 
So it's rather important to choose a good value from the start. In case I 
need to set the parameter to a fixed value: What would a pragmatic value 
be? (The documentation comes with a very long explanation which isn't 
really that useful, I think.)

-- 
Troels Arvin
0
Troels
2/13/2016 5:23:11 PM
comp.databases.ibm-db2 12448 articles. 3 followers. arunrocks (9) is leader. Post Follow

1 Replies
326 Views

Similar Articles

[PageSpeed] 12

El s=C3=A1bado, 13 de febrero de 2016, 18:23:15 (UTC+1), Troels Arvin  escr=
ibi=C3=B3:
> Hello,
>=20
> DB2 9.7 on a Linux server which has =E7=A2=BAB of RAM:
> In db2top's memory view, it states that the Lock Mgr is consuming 54G.=20
> This seems absurdly high to me. It seems that this value was chosen=20
> automatically:
>=20
> $ db2 get db cfg |grep -i lock
>  Max storage for lock list (4KB) (LOCKLIST) =3D AUTOMATIC(13692896)
>=20
> Is there any conceivable reason why such a big lock list would ever be=20
> needed?
>=20
> I would like to use as many automatically computed parameters as=20
> possible, except when it results in absurd results. Is there at way for=
=20
> me to influence the automatic calculation of the LOCKLIST value, without=
=20
> having to hard-code it completely?
>=20
> It seems that DB2 needs to be restarted in order to change the value(?).=
=20
> So it's rather important to choose a good value from the start. In case I=
=20
> need to set the parameter to a fixed value: What would a pragmatic value=
=20
> be? (The documentation comes with a very long explanation which isn't=20
> really that useful, I think.)
>=20
> --=20
> Troels Arvin

Have no idea why lock list is consuming such an absurd value.=20

We have used automatic STMM for some time to see how memory distribution ev=
olves in, say, one or two months. After that period we have seen the top va=
lues and assign them FIXED to the bufferpools or other memory consumers suc=
h as locklist (if you have enough memory).=20

I hope it helps
0
jbaron
2/15/2016 9:22:56 AM
Reply:

Similar Artilces:

Convert SAP Oracle Database to IBM DB2 Database??
Hello, I would like to hear from anyone here who has converted their SAP Oracle database to IBM DB2 database? Did you realize greater disk saving via DB2 compression? Did you run the latest version of DB2 rather than allow SAP to keep your Oracle version back-leveled? Please, DB2 Bashers need not apply, looking for the business case anyone used to convert to DB2. Thank you. Charles On 6 Feb, 01:52, "Charles Davis" <cdavis10...@comcast.net> wrote: > Hello, > > I would like to hear from anyone here who has converted their SAP Oracle > database to IBM DB2 d...

Connect to IBM DB2 database without installing the DB2 client.
Hi, To connect to the DB2 Driver, from a remote machine. Do we requier DB2 client. Can't we connect by just having IBM DB2 driver which is just a single file (db2cli.dll). I am using vb application from Windows platform to connect to DB2 on Linux machine. Regards, Santosh SB wrote: > Hi, > > To connect to the DB2 Driver, from a remote machine. Do we requier DB2 > client. > Can't we connect by just having IBM DB2 driver which is just a single > file (db2cli.dll). > I am using vb application from Windows platform to connect to DB2 on >...

java.sql.SQLException: No suitable driver when connecting to a DB2 database using driver COM.ibm.db2.jdbc.DB2XADataSource
Hi, I want to get connection to a DB2 database using the driver COM.ibm.db2.jdbc.DB2XADataSource. I have also included 'db2java.zip' in the classpath. However I am getting the exception java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at Conn.main(Conn.java:44) The code that I am using (with try/catch removed) is as follows: String url = "jdbc:db2:sample"; String driver = "COM.ibm.db2.jdbc.DB2XADataSource"; String dbuser = "db2u...

oct 24 DB2 for LUW Tech Talk: What's Hot from IOD for PureData Systems, IBM Mobile Database and DB2 for LUW
Now we can tell you more! IBM announced PureData Systems on October 9th --= a series of expert integrated solutions for your transactional and analyti= c workloads.=20 In the next DB2 Tech Talk, we'll come to you from Las Vegas with hot news f= rom the conference from a DB2 for LUW, PureData Systems perspective! We'll= also cover a new free software download called IBM Mobile Database, which = helps you enable your DB2 data apps for Android mobile users. And then we = will bring you the best of the presentations from the conference, including= an IBM Champion and other ...

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html Scott: #DataBase...

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html ...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

IBM Sets DB2 Database Free
http://www.linuxtoday.com/it_management/2006013101526NWSV Will UniVerse and UniData follow? Henrry Keultjes hbkeultjesat earthlinkdotnet csigline@hotmail.com wrote: > http://www.linuxtoday.com/it_management/2006013101526NWSV > > Will UniVerse and UniData follow? Good catch, Henry (or is it two r's now-see below). We will have to ask IBM what their intentions are with U2 in light of this, but I suspect that the PE editions will be the extent of the free offering. We shall see. Cheers! --dawn > Henrry Keultjes > hbkeultjesat > earthlinkdotnet ...

Using .NET to access to a IBM DB2 database
Hello I'm trying to connect to a IBM DB2 database with IBMDA400 Provider. I cannot choose the provider, this is the only one I can use. The tables in AS/400 don't have journal and I cannot change this. When I define an ODBC and link tables in ACCESS I can perform every actions. I change the ODBC options to commit data immediately. Using the same ODBC and the same insert statement, when I connect in my C# application using ODBCConnection, I get this error: ERROR [42S22] [IBM][Controlador ODBC do iSeries Access][DB2 UDB]SQL0206 - Column N not in specified tables. Wh...

Re: IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit,
vvcd said: > IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 > bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite > Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express > Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM > Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other > IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 > CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM > Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for Web...

DBI:ibm_db connection for IBM DB2 database
Hello, I am attempting to make a DBI connection from Ruby code running on Win32 (XP) machine to an IBM DB2 v9.5 database running under Linux On the Win32 machine, I have Ruby 1.8.6 (installed with the one-click installer) and have successfully launched the following gem installation commands for the IBM DB drivers and required libraries: >gem install activesupport -v 1.4.2 >gem install activerecord -v 1.15.3 >gem install ibm_db -v 0.8.5 I have also (as required by the IBM documentation at http://rubyforge.org/docman/view.php/2361/967/IBM_DB-0.6.0.pdf) added ‘ibm_db’ to the list of...

IBM DB2 Database Specialist
We are looking to fill the following permanent position with one of our reputed clients in Saudi Arabia (WESTERNERS ARE PREFFERED). Apply to: APPLICATION@GOAHEADCONSULTING.CO.UK Job Title IBM DB2 Database Specialist Location: Saudi Arabia Objective Responsible for the administration of DB2 subsystems and associated software on the client=92s mainframes Accountable to Data Centre Manager Responsibilities This SENIOR position involves the full spectrum of DB2 system programming activities, including product installation, customization, deployment, software tools integration, ex...

IBM.Data.DB2.iSeries database access problem
When I run the following vb.net code, I'm not able to acces the my database AMFLIB. I use to be able to access AMFLIB with the old ODBC driver from IBM iSeries Access but now I want to use the new managed IBM.Data.DB2.iSeries data provider from iSeries Access V5R3. When I remove Database=AMFLIB from the connection string, I can connect but as soon as I try to specify a known database (like my good old AMFLIB) I get the following error: IBM.Data.DB2.iSeries.iDB2ConnectionFailedException "The connection cannot be opened because an error ocurred." I'm running IBM iSeries Acc...

ibm db2 lock (row/table) status/indication
as wat ive mentioned in the title.. im would like to know whether the a particular record/table is being locked in my program. some of the methods which i would like to develop are as below: Lock(KEY, SQLCODE) - to create a lock. Returns 0 on success, 1 if a lock already exists and -1 on failure with SQLCODE. There is no necessity to use IsLock() for checking if a lock exists or not, just insert the record and check for Unlock(KEY, SQLCODE) - to remove a lock. Returns 0 on success, -1 on error with the appropriate SQLCODE. Returns 1 if no lock record is found. IsLock(Key, ...

Whether ACE threads work with IBM Db2 Database
Hi All, We are starting one Project with following Skills 1) Language :- C++ with Embedded SQL Programming ( Source file format :- .sqC ) 2) Database :- IBM UDB database 3) Platform:- Solaris Sparc 5.8 Machine. 4) ACE Threads. Please let us know, can we use ACE Threads with C++ and Db2 Embedded SQL under Solaris Sparc 5.8 Machine. Thanks & Regards, Divya ...

IBM.Data.DB2.iSeries database access problem
When I run the following vb.net code, I'm not able to acces the my database AMFLIB. I use to be able to access AMFLIB with the old ODBC driver from IBM iSeries Access but now I want to use the new managed IBM.Data.DB2.iSeries data provider from iSeries Access V5R3. When I remove Database=AMFLIB from the connection string, I can connect but as soon as I try to specify a known database (like my good old AMFLIB) I get the following error: IBM.Data.DB2.iSeries.iDB2ConnectionFailedException "The connection cannot be opened because an error ocurred." I'm runn...

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30081N communication error on DB2/POrtal on AIX
Hi, I have installed WebSphere Portal on AIX and connected to DB2 on a remote machine, Getting the followin errors when trying to get the values from database thru applications installed on Portal. Any Help Appreciated. Thanks in advance. Praveen Singh IBM Workplace, India COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "9.33.12.221". Communication function detectin...

export IBM UDB (7.2) database into DB2 Mainframe
Hi I am trying to export a database and its data from UDB 7.2 or 8.1 to Mainframe DB2. Is this possible? The last time I did this, i ended up having to write insert statements for each row. Is there a utilitity to accomplish this? Thanks John John Turek wrote: > Hi > > I am trying to export a database and its data from UDB 7.2 or 8.1 to > Mainframe DB2. Is this possible? The last time I did this, i ended > up having to write insert statements for each row. Is there a > utilitity to accomplish this? > > Thanks > > John You po...

[News] IBM Elevates Free Software Database at DB2's Expense
IBM's EnterpriseDB stake: not what you think ,----[ Quote ] | Ergo, this deal is IBM dipping its feet gingerly into a back door challenge | to Oracle, not MySQL. Ever since IBM held back on its own SQL database | invention, allowing Oracle to grab leadership of the market, it has always | responded by making DB2 cheaper. But it still plays second banana. Investing | a modest chunk in EnterpriseDB is a way of having somebody else test drive a | new strategy for carving a wedge inside the Oracle market, something that IBM | has hungered for going back at least 20 years. `---- h...

Web resources about - Lock Mgr consuming 54G - comp.databases.ibm-db2

Tumblr : How do teenagers waste hours upon hours consuming Tumblr?
Answer (1 of 6): I am a teenager and also have a fascination with Tumblr. I will try my best to explain this from our perspective as teens. This ...

Are You Consuming Your Coffee Correctly? - YouTube
Have you been doing it wrong? The Scientific Smell Challenge: https://youtu.be/bI5HEl3u848 SUBSCRIBE (it's free!): http://bit.ly/asapsci GET ...

Briton sentenced to four years for consuming hashish in Dubai
... to having 6.4 grams of the drug for his personal use and he will be deported after serving his sentence. DUBAI // A Briton charged with consuming ...

Eating meat is hurting the environment - stop consuming so much, top US nutritional panel says
The country's foremost nutrition advisory panel is taking a stand against meat: Americans should eat less of it, top experts say, in order to ...

Teen love shown to be most consuming
BACK in 1965, Cat Stevens wrote The First Cut is the Deepest. It turns out he was right. New research from a joint American and Australian study ...

Life-consuming quest
The news that Australian companies are to build open cut coalmines in the largest remaining tropical rainforest in Borneo fills me with despair. ...

Time-consuming, tiring but Facebook a 'necessary evil'
Facebook may be on the nose with the Australian public but it has become as much a 'necessary evil' as TV, and half the population still uses ...

Canadians consuming sky-high amounts of sodium, study finds
Canadians are consuming potentially dangerous amounts of sodium and Ottawa must take action to limit those levels, a leading expert on heart ...

13 Causes Of Insomnia, From Work Stress To What You're Consuming
After a long day, the only thing you want to do is crawl into bed for a good night's rest. Unfortunately, for 3.3 million Canadians, that isn't ...

Consuming Walker - AdPulp - AdPulp
It’s Sunday, which means it time to open The New York Times Magazine and read “Consumed,” the weekly column by Rob Walker. Today’s piece is about ...

Resources last updated: 2/15/2016 11:12:23 AM