Purely from a memory standpoint, vmstat indicating low free pages(fre
column) is not by itself an indication of a memory constraint. The OS is
going to use memory for caching files etc optimally(i.e. use as much is
viable). Can you enclose a snap-shot of the vmstat o/p for better diagnosis,
say, the o/p from this command: vmstat 5 5?
Thanks.
-----Original Message-----
From: Raghavan.Anand-[Email Address Removed] Monday, March 01, 2004 9:31 PM
To: [Email Address Removed] Db2 issue on AIX 4.3.3
Hi All
We are using Db2 v7.2 FP 8 on AIX RS6000 2 way processor and 6 GB RAM . We
have around 8 databases on one single instance and all 8 are mission
critical applications running across Pan India and Asia Pac with numerous
concurrent users and insert/updates/select etc happening round the clock .
Currently we are facing acute resource issues and vmstat on this boxes
indicates very little free memory
Sometimes even the CPU idle time hits 0 always and users are facing
problems . Is it true that that on one instance only 1.7 GB of memory is
avalable and we need to do a database migration to new instance i. e, we
create another instance and move 2 or 3 database to the newer one . Will it
help or should we do application / system / DB2 fine tuning
Please help
regards
anand
eg vmstat 2 20
----- ----------- ------------------------ ------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
0 1 837814 554 0 0 0 32 115 0 155 667 155 16 6 75 2
0 2 837814 553 0 0 0 0 0 0 259 1287 84 0 1 99 0
0 2 838012 290 0 3 0 0 0 0 286 1215 135 0 1 96 2
0 2 838068 318 0 1 0 44 45 0 291 2344 193 2 2 96 1
0 2 837815 627 0 0 0 0 0 0 253 1663 92 1 12 87 0
0 2 837815 621 0 2 0 0 0 0 301 1339 152 2 11 86 1
2 2 837815 618 0 1 0 0 0 0 276 2024 591 72 2 25 0
0 2 837815 617 0 0 0 0 0 0 270 857 100 0 0 99 0
1 3 837815 615 0 0 0 0 0 0 313 2045 223 16 24 49 11
0 2 837815 616 0 0 0 0 0 0 241 765 85 0 0 99 0
"Trace R Jones" <trace.[Email Address Removed]
25-02-04 07:37 PM
To: [Email Address Removed]
cc:
Subject: DB2 Connect with Access Issue
Hello everyone,
I am trying to use MS ACCESS using ODBC (via DB2 Connect 8.1.4.A) to
connect to our DB2 OS390 databases. Here is the error I'm receiving:
[IBM] [CLI Driver] [DB2] SQL0440N No Authorized Routine Named "SQLTABLES"
of type "*" having compatible arguments was found. SQLSTATE=42884.
Anyone seen this or have any ideas?
TRJ
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed] <firstam.com>" made the following
annotations on 03/01/2004 09:43:14 PM
------------------------------------------------------------------------------
"THIS E-MAIL MESSAGE AND ANY FILES TRANSMITTED HEREWITH, ARE INTENDED SOLELY FOR THE USE OF THE INDIVIDUAL(S) ADDRESSED AND MAY CONTAIN CONFIDENTIAL, PROPRIETARY OR PRIVILEGED INFORMATION. IF YOU ARE NOT THE ADDRESSEE INDICATED IN THIS MESSAGE (OR RESPONSIBLE FOR DELIVERY OF THIS MESSAGE TO SUCH PERSON) YOU MAY NOT REVIEW, USE, DISCLOSE OR DISTRIBUTE THIS MESSAGE OR ANY FILES TRANSMITTED HEREWITH. IF YOU RECEIVE THIS MESSAGE IN ERROR, PLEASE CONTACT THE SENDER BY REPLY E-MAIL AND DELETE THIS MESSAGE AND ALL COPIES OF IT FROM YOUR SYSTEM."
==============================================================================
DB2 & UDB email list listserv db2-l LazyDBA home page