I think it is a very good reason, as maxservers=10 is just a default value which is usually not sufficient for a box running a DB that is taking advantage of async I/O, as well as all other settings for your aio. Your admins should read any of the freely available tuning guides for Oracle on AIX and other useful tuning guides for AIX on the web.
I strongly recommend following values as a start:
The values of the queue and the number of maximum started AIO servers should be monitored and tuned accordingly. But there is no doubt, that your DB will have an easier live when it is given what it needs and supports.
On the other hand, ask your admins why it should not be done? It does not damage anything nor does it waste precious amounts of RAM. In fact it is a simple tuning task which those that are responsible for performance monitoring and tuning could/should have noticed or at least be thankful that you noticed them.
Quote:
I can see in topas reaching that peak very often but is not enough to justify a chance according to our Unix Administrators.
Running your critical business applications at best possible performance with the given hardware and software should be their interesst too, especially when it involves so little effort to accomplish.
Last edited by zaxxon; 04-19-2011 at 05:30 AM..
Reason: typos and phrasing
Hello,
I have a performance problem on an AIX box. I'm not sure what is causing this and hoping someone may have suggestions. Currently I'm noticing that cpu's are waiting while the box is in a idle state. I checked the disks and none of them are at 100%. If they were then I would understand... (3 Replies)
Hiya all,
I am a newbie sysadmin to AIX, i have worked on HPUX for 3 years.
I have started a new role with in an IBM house and because there is me and one other there are a couple of issues I cannot work out:
We havehad a production server slowing down processing batch jbs over the past... (6 Replies)
I'm doing performance testing for one application which works on AIX.
But I don't know which performance parameters of memory need to be collected. Now, I just know very few:
1. page in
2. page out
3. fre
They are all collected by "vmstat" command.
I want to know, except for above... (2 Replies)
I am trying to analyze the performance of an AIX system. I think I may have a disk I/O issue, but I am asking for help to validate or invalidate this assumption. I ran the commands below during a period of peak load.
Please help me to find any performance bottlenecks. Thanks in advance for your... (15 Replies)
Gurus, i have process that runs 5 times a day.
it runs normally (takes about 1 hour) to complete in 3 runs
but it is takes about ( 3 hrs to complete) two times
So i need to figure out why it takes significanlty high time during
those 2 runs.
The process is a shell script that connect to... (2 Replies)
Hi Guys,
This is the situation I am in. Provide your views and input where should I start?
I have one P7 test server and a p520 production server. the job is taking pretty long on the P7 test server when compared to the P5 production server. below is the full detail.
Informix... (5 Replies)
Hello
I am new user of AIX; I have only basic knowledge of the UNIX commands, and I want to create script that will monitor the performance and resources usage on AIX 6.1 machine.
Basically I wan to start a loop that will grab, every 10 seconds, the CPU usage, the memory usage, the disk usage,... (1 Reply)
Hello,
I encounter some performance issues on my AIX 5.3 server running in a LPAR on a P520. How do I investigate performance issues in AIX. Is there any kind of procedure that takes me to the steps to investigate my server and find the sub systems that is causing the issues?
The performance... (1 Reply)
Hi,
I'm supposed to capture many performance stats on AIX 6 and stuck up with below:
Priority queue
Disk cache hit%
Page out rate
Swap out rate
Memory queue
I see vmstatis helpful for "page out" but not sure how to get the "rate".
Could anyone please let me know how to get these... (4 Replies)
Discussion started by: reddyr
4 Replies
LEARN ABOUT PHP
db2_procedures
DB2_PROCEDURES(3) 1 DB2_PROCEDURES(3)db2_procedures - Returns a result set listing the stored procedures registered in a databaseSYNOPSIS
resource db2_procedures (resource $connection, string $qualifier, string $schema, string $procedure)
DESCRIPTION
Returns a result set listing the stored procedures registered in a database.
PARAMETERS
o $connection
- A valid connection to an IBM DB2, Cloudscape, or Apache Derby database.
o $qualifier
- A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string.
o $schema
- The schema which contains the procedures. This parameter accepts a search pattern containing _ and % as wildcards.
o $procedure
- The name of the procedure. This parameter accepts a search pattern containing _ and % as wildcards.
RETURN VALUES
Returns a statement resource with a result set containing rows describing the stored procedures matching the specified parameters. The
rows are composed of the following columns:
+------------------+---------------------------------------------------+
| Column name | |
| | |
| | Description |
| | |
+------------------+---------------------------------------------------+
| PROCEDURE_CAT | |
| | |
| | The catalog that contains the procedure. The |
| | value is NULL if this table does not have cata- |
| | logs. |
| | |
| PROCEDURE_SCHEM | |
| | |
| | Name of the schema that contains the stored pro- |
| | cedure. |
| | |
| PROCEDURE_NAME | |
| | |
| | Name of the procedure. |
| | |
|NUM_INPUT_PARAMS | |
| | |
| | Number of input (IN) parameters for the stored |
| | procedure. |
| | |
|NUM_OUTPUT_PARAMS | |
| | |
| | Number of output (OUT) parameters for the stored |
| | procedure. |
| | |
| NUM_RESULT_SETS | |
| | |
| | Number of result sets returned by the stored pro- |
| | cedure. |
| | |
| REMARKS | |
| | |
| | Any comments about the stored procedure. |
| | |
| PROCEDURE_TYPE | |
| | |
| | Always returns 1, indicating that the stored pro- |
| | cedure does not return a return value. |
| | |
+------------------+---------------------------------------------------+
SEE ALSO db2_column_privileges(3), db2_columns(3), db2_foreign_keys(3), db2_primary_keys(3), db2_procedure_columns(3), db2_special_columns(3),
db2_statistics(3), db2_table_privileges(3), db2_tables(3).
PHP Documentation Group DB2_PROCEDURES(3)