You can change the intra_parallel to no and the DB2_MMAP_READ,WRITE to
being off to free up .5 Gig of shared on each instance.
Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email Address Removed] [Email Address Removed]
Raghavan.Anand-Ba
[Email Address Removed]
hartered.com To
[Email Address Removed]
03/02/2004 12:31 cc
AM
Subject
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]
y.com> To: [Email Address Removed] cc:
25-02-04 07:37 PM 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] 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.
---------------------------------------------------------
---------------------------------------------------------------------
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]DB2 & UDB email list listserv db2-l LazyDBA home page