Dear Venkat
This snapshot is taken just now. Currently no major issues . The problem
would resurface during peak volumes/load
BTW vmstat 5 5 also enclosed
$ vmstat 5 5
kthr memory page faults cpu
----- ----------- ------------------------ ------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
0 1 839981 600 0 0 0 32 115 0 155 669 156 16 6 75 2
0 2 839982 595 0 0 0 0 0 0 362 1922 322 1 10 83 6
0 2 839982 595 0 0 0 0 0 0 312 1304 479 16 1 83 0
0 2 839982 590 0 0 0 0 0 0 434 1567 612 26 10 62 2
1 2 839982 582 0 1 0 0 0 0 382 1653 588 41 1 57 1
regards
anand
"Venkat, Vijay" <[Email Address Removed] 11:15 AM
To: "Venkat, Vijay" <[Email Address Removed]
"'Raghavan.Anand-[Email Address Removed]
<Raghavan.Anand-[Email Address Removed] [Email Address Removed] cc:
Subject: RE: Db2 issue on AIX 4.3.3
neveermind, I didn't notice the vmstat o/p enclosed. Was this taken when
you
see the resource crunch?
-----Original Message-----
From: Venkat, Vijay [mailto:[Email Address Removed] Monday, March 01, 2004 9:43 PM
To: 'Raghavan.Anand-[Email Address Removed] RE: Db2 issue on AIX 4.3.3
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."
============================================================================
==
---------------------------------------------------------------------
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:45:31 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."
==============================================================================
----------------------------------------------------------
This email is confidential. If you are not the addressee tell the sender immediately and destroy this email without using, sending or storing it. Emails are not secure and may suffer errors, viruses, delay, interception and amendment. Standard Chartered PLC and subsidiaries ("SCGroup") do not accept liability for damage caused by this email and may monitor email traffic. Unless expressly stated, any opinions are the sender's and are not approved by SCGroup and this email is not an offer, solicitation, recommendation or agreement of any kind.
Standard Chartered Bank ("SCB") is a member of SCGroup incorporated in England with limited liability. SCB's principal office is 1 Aldermanbury Square, London, EC2V 7SB, UK. SCB is authorised and regulated by the Financial Services Authority ("FSA") and in FSA's register under no. 114276. SCB's VAT no. is GB244106593. FSA is the lead regulator for the SCGroup. For regulators in other countries contact the local compliance officer.
---------------------------------------------------------
DB2 & UDB email list listserv db2-l LazyDBA home page