Hello there.
1) According to documentation, setting
CATALOGCACHE_SZ = -1 means CATALOGCACHE_SZ = (MAXAPPLS*4)
But MAXAPPLS is set to AUTOMATIC, this means "no limit" or "no value". Again, according to documentation, CATALOGCACHE_SZ is allocated "when the database is initialized". Hence, I'm interesting, which value is really allocated instead of illusion (<no limit>*4).
"get db cfg" command does not help here, because literally displays "(MAXAPPLS* 4)".
2) There would be no room for question (1) if I have a way to reliably check CATALOGCACHE_SZ value. But I have inconsistent results:
_______________ _______________ _______________ __
| |CATALOG | "catcacheh" (token of db2mtrk -d)
MAXAPPLS|CACHE_ SZ| shown | I would expect...
--------+--------+--------+--------------------
(ignore) 100 192,0K 4K*100 = 400K
20 -1 64,0K 4K*(20*4) = 320K
AUTOMAT -1 64,0K (no assumptions)
-----------------------------------------------
Hence, I'm intresting, how are related CATALOGCACHE_SZ db config parameter, "catcacheh" token of db2mtrk, and real catalog cache size ?
--
Konstantin Andreev. 14 7046
Konstantin Andreev wrote:
Hello there.
1) According to documentation, setting
CATALOGCACHE_SZ = -1 means CATALOGCACHE_SZ = (MAXAPPLS*4)
But MAXAPPLS is set to AUTOMATIC, this means "no limit" or "no
value". Again, according to documentation, CATALOGCACHE_SZ is allocated
"when the database is initialized". Hence, I'm interesting, which value
is really allocated instead of illusion (<no limit>*4).
AUTOMATIC does not mean "no limit" or "no value".
Did you try DB2 GET DB CFG FOR <aliasSHOW DETAIL?
Jan M. Nelken
Konstantin Andreev wrote:
Hello there.
1) According to documentation, setting
CATALOGCACHE_SZ = -1 means CATALOGCACHE_SZ = (MAXAPPLS*4)
But MAXAPPLS is set to AUTOMATIC, this means "no limit" or "no
value". Again, according to documentation, CATALOGCACHE_SZ is
allocated "when the database is initialized". Hence, I'm interesting,
which value is really allocated instead of illusion (<no limit>*4).
AUTOMATIC doesn't mean "no limit" or "no value", it means the value is
determined by DB2 and dynamically adapted depending on circumstances.
>
"get db cfg" command does not help here, because literally
displays "(MAXAPPLS* 4)".
Try the autoconfigure command instead, with the no-apply option, like this:
db2 autoconfigure using MAXAPPLS CATALOGCACHE_SZ apply none
It will show both the formula and the actual value.
HTH.
--
Jeroen
Thank everybody!
AUTOMATIC does not mean "no limit" or "no value". Did you try DB2 GET DB CFG FOR <aliasSHOW DETAIL?
"Show detail", of course! I've absolutely forgotten it.
--
Konstantin Andreev.
Konstantin Andreev wrote:
"Show detail", of course! I've absolutely forgotten it.
You could also use:
db2pd -db <alias-dbcfg
and grep (or find) keyword you need:
For orthodox Windows believers:
db2pd -db sample -dbcfg | find /i "maxappls"
For progressive Windows believers (who downloaded grep for Windows) and
Unix followers:
db2pd -db smple -dbcfg | grep -i maxappls
Jan M. Nelken
Jan M. Nelken wrote:
You could also use:
db2pd -db <alias-dbcfg
db2pd is my postponed headache. It just exits silently in my system. No complains/error messages, exit code is always zero, and random command line arguments does not change this ("db2pdcfg" behaves the same). So I should leave without it.
For progressive Windows believers (who downloaded grep for Windows)
db2pd -db smple -dbcfg | grep -i maxappls
For everybody, who has wrote more than one or two scripts for Windows, installing a proper set of unix utilities under Windows is a must. sed, awk, grep,... all are should be here.
--
Konstantin Andreev.
Konstantin Andreev wrote:
db2pd is my postponed headache. It just exits silently in my system. No
complains/error messages, exit code is always zero, and random command
line arguments does not change this ("db2pdcfg" behaves the same). So I
should leave without it.
As the wise man said: We will not fix problems we don't know about...
Can you capture system calls trace on some trivial invocation of db2pd,
for example:
db2pd -db sample -dbcfg
Make sure you get this on supported Linux distribution - see http://www-306.ibm.com/software/data...inux/validate/ for details.
For DB2 V9 32-bit platform this would be RHEL 4, RHEL 5, SLES 9, SLES 10
and Novell Open Enterprise Server 9.
For each of those distributions specific kernel level and/or libraries
levels may be required.
Jan M. Nelken
On Jun 4, 10:02 pm, "Jan M. Nelken" wrote:
db2pd is my postponed headache. It just exits silently in my system. No complains/error messages, exit code is always zero, and random command line arguments does not change this.
As the wise man said: We will not fix problems we don't know about...
Certainly...
>
Can you capture system calls trace on some trivial invocation of db2pd, for example:
db2pd -db sample -dbcfg
| avalon ~ # strace db2pd -db psftprod -dbcfg 2>&1 | wc -l
| 445
It's a lot of output, I am not sure, is it appropriate to post the
trace to group? The traces are identical (accurate within memory
addresses) on invocations of db2pd with random arguments. The most
suspicios call is third preceding exit:
| access("/db2/srv/dbi/sqllib/lib/libdb2fmtdmp.so ", F_OK) = -1 ENOENT
| setuid32(0) = 0
| exit_group(0) = ?
I've checked the DB2 v9 installation pack, there is no such file in
it.
Make sure you get this on supported Linux distribution
Too bad, I have only one installation of v9, and this linux distro
(gentoo) is not officially supported. If your time permits analyzing
this problem, I gratefully supply any required details (kernel,
libraries, and so on...).
I believe this in not distro related problem. Most likely, some simple
misconfiguratio n.
--
Konstantin Andreev.
Konstantin Andreev wrote:
It's a lot of output, I am not sure, is it appropriate to post the
trace to group? The traces are identical (accurate within memory
addresses) on invocations of db2pd with random arguments. The most
suspicios call is third preceding exit:
| access("/db2/srv/dbi/sqllib/lib/libdb2fmtdmp.so ", F_OK) = -1 ENOENT
| setuid32(0) = 0
| exit_group(0) = ?
I've checked the DB2 v9 installation pack, there is no such file in
it.
Please also run this:
db2pd -v -debug db2pddbg
and include db2pddbg file with strace output.
You can uplaod compressed output to ftp server:
ftp.software.ib m.com
into directory
/ps/toibm/db2
as file:
stuuf4jun.gz
and I will have a look.
As for libdb2fmtdmp.so - this library is used for formatting internal
data structures. On customer systems internal data are written as hex dump.
This library is not needed in your case - it's not shipped to customers.
Jan M. Nelken
Jan M. Nelken wrote:
>It's a lot of output, I am not sure, is it appropriate to post the trace to group?
You can uplaod compressed output to ftp server:
ftp.software.ib m.com
into directory
/ps/toibm/db2
| # ftp ftp://ftp.software.ibm.com/
| Current remote directory is /.
| ncftp / cd /ps/toibm/db2
| Could not chdir to /ps/toibm/db2: server said: toibm: No such file or directory.
I've overlooked the /ps directory, but could not find something simular to 'toibm'. Looks like you mistyped the URL :(
--
Konstantin Andreev. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mike Meyer |
last post by:
Ok, I give up. I searched the CVS code, and can't find the place that
turns an include_dirs option in setup.cfg into a list of
directories. The reason I was looking for it is that I can't figure
out how to make include_dirs include multiple directories from
setup.cfg. Everything I try winds up putting
-I<contents_of_include_dirs>. I couldn't...
|
by: nek |
last post by:
Greetings,
Platform is W2K, DB2 V8.1 FP2.
We have a large number of servers in different cities and I would like
to occasionally update 'db cfg' parameters whenever needs arise.
Instead of connecting to each server (via remote desktop connection)
to do this, is it possible to write script containing 'db2 update db
cfg for dbname..' and...
|
by: richard |
last post by:
HI, anyone has the same issue.
I need to copy db2 admin cfg from one instance to another.
when I issue
db2look -f -d data
I only get
UPDATE DBM CFG USING cpuspeed 3.109600e-007;
UPDATE DBM CFG USING intra_parallel NO;
UPDATE DBM CFG USING federated NO;
UPDATE DBM CFG USING fed_noauth NO;
|
by: Andy S. |
last post by:
Hi,
I'm running DB2 UDB v 7.2 FP 9.
I'm connected to my database (testdb) successfully as user db2admin.
then i tried to run the following command:
get db cfg for testdb
|
by: ozegar |
last post by:
Hi,
Why BDE Administrator use IDAPI.CFG or IDAPI32.CFG?
Is this files is different by structure? And why sometimes it uses IDAPI.CFG, but sometimes IDAPI32.CFG? Is it because, wher installed Borland C++ Builder, he use IDAPI.CFG and all others IDAPI32.CFG or there is something else?
And if I need configure many computers and I just copyed this...
| |
by: aj |
last post by:
DB2 LUW 8.2 FP14 Red Hat AS 2.1
Help gurus:
I'm seeing this in my db2diag.log:
2007-08-28-15.57.58.858627-240 E8785115G359 LEVEL: Warning (OS)
PID : 18117 TID : 8194 PROC : db2dasstm
INSTANCE: md NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloqualifydir, probe:30
|
by: ruediger.papke |
last post by:
Hi,
I have an installation DB2 V9.1 on suse linux.
because of an java error when trying to create the systools catalog
i'm going to change the JDK-PATH with no success
db2 get admin cfg
.... Java Development Kit Installation Path DAS (JDK_PATH) =
AUTOMATIC(/home/dasusr/das/java/jdk)
|
by: Lekh Raj |
last post by:
Hi,
I want to update dbm cfg parameters DFT_MON_BUFPOOL and
DFT_MON_STMT from C program. I am using db2 version 9.1.2 on Linux
platform
When I use
"db2 update dbm cfg using DFT_MON_BUFPOOL ON DFT_MON_STMT ON"
command for this purpose "db2 get dbm cfg show detail" command
reflects changes in both current and delayed values of...
|
by: datapro01 |
last post by:
When issuing a get db cfg command are we supposed to be getting the
current value or future value of a parameter?
For example, I issue a get db cfg against a certain database and get
this:
Statistics heap size (4KB) (STAT_HEAP_SZ) = 20000
If I then issue a get db cfg show detail on the same database I get
this
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |