Thanks for your comments once again. I wonder if in this case everytime when we hit the peak in my case we have only 120 AIO servers procesess on this server then any other requests has to sit in the queue and wait for a AIO server to be released/available. If this how it works?. I must admit I'm a bit confuse with the maxreqs parameter. In our enviroment is set to 4096 but I believe this is just a hard limit assuming that the combination of maxservers and the number of CPU's doesn't go beyond this limit.
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_tables
DB2_TABLES(3) 1 DB2_TABLES(3)db2_tables - Returns a result set listing the tables and associated metadata in a databaseSYNOPSIS
resource db2_tables (resource $connection, [string $qualifier], [string $schema], [string $table-name], [string $table-type])
DESCRIPTION
Returns a result set listing the tables and associated metadata 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 tables. This parameter accepts a search pattern containing _ and % as wildcards.
o $table-name
- The name of the table. This parameter accepts a search pattern containing _ and % as wildcards.
o $table-type
- A list of comma-delimited table type identifiers. To match all table types, pass NULL or an empty string. Valid table type iden-
tifiers include: ALIAS, HIERARCHY TABLE, INOPERATIVE VIEW, NICKNAME, MATERIALIZED QUERY TABLE, SYSTEM TABLE, TABLE, TYPED TABLE,
TYPED VIEW, and VIEW.
RETURN VALUES
Returns a statement resource with a result set containing rows describing the tables that match the specified parameters. The rows are
composed of the following columns:
+------------+---------------------------------------------------+
|Column name | |
| | |
| | Description |
| | |
+------------+---------------------------------------------------+
| TABLE_CAT | |
| | |
| | The catalog that contains the table. The value is |
| | NULL if this table does not have catalogs. |
| | |
|TABLE_SCHEM | |
| | |
| | Name of the schema that contains the table. |
| | |
|TABLE_NAME | |
| | |
| | Name of the table. |
| | |
|TABLE_TYPE | |
| | |
| | Table type identifier for the table. |
| | |
| REMARKS | |
| | |
| | Description of the table. |
| | |
+------------+---------------------------------------------------+
SEE ALSO db2_column_privileges(3), db2_columns(3), db2_foreign_keys(3), db2_primary_keys(3), db2_procedure_columns(3), db2_procedures(3), db2_spe-
cial_columns(3), db2_statistics(3), db2_table_privileges(3).
PHP Documentation Group DB2_TABLES(3)