no performance when creating or extending a tablespace

koos

Hi,

I`m a unix system administrator and they asked me to investigate a
performance problem. When de DBA extends or creats a tablespace by 2Gb then
we cannot connect to the database we already did increase the aio setting on
the OS AIX 4.3.11 but that did not resolve the problem. Have anyone any idea
what is te matter.

Koos

Jul 19 '05 #1

Subscribe Post Reply

1652

DBA Infopower Support

Hello Koos,

For a start, please ask DBA to generate statspack (or bstat/estat) report
during the event and post it to the group.

From the unix side, check what is vmstat showing on r/b columns.

Regards,

Support
DBA Infopower LLC
http://www.dbainfopower.com
"koos" <ks****@kabelfoon.nl> wrote in message
news:40**********************@news.kabelfoon.nl...

Hi,

I`m a unix system administrator and they asked me to investigate a
performance problem. When de DBA extends or creats a tablespace by 2Gb then we cannot connect to the database we already did increase the aio setting on the OS AIX 4.3.11 but that did not resolve the problem. Have anyone any idea what is te matter.

Koos

Jul 19 '05 #2

by: serge | last post by:

I have an SP that is big, huge, 700-800 lines. I am not an expert but I need to figure out every possible way that I can improve the performance speed of this SP. In the next couple of weeks I...

Microsoft SQL Server

Temporary Tablespace type to encrease performance

by: zebi | last post by:

hello, What's your opinion : The best type of temporary tablespace (DB2V7.2 SP 7 in AIX 4.3 / multiprocessor ) is DMS ou SMS ? Thanks ZEB

DB2 Database

Better index access = worse performance??

by: Sean C. | last post by:

Helpful folks, Most of my previous experience with DB2 was on s390 mainframe systems and the optimizer on this platform always seemed very predictable and consistent. Since moving to a WinNT/UDB...

DB2 Database

Poor Performance: High Real Time/CPU Time Ratio

by: Evan Smith | last post by:

My database is suffering from poor performance of late. Reports that used to run in a reasonable time, now take a while. The explain output show that the query is fully indexed, and the statistics...

DB2 Database

ruminating on 390 performance vs. VSAM

by: robert | last post by:

consider the following hypothetical (it isn't but....) - start with a COBOL/VSAM codebase that's REALLY old - end with both a COBOL/VSAM and a COBOL/DB2 system which differs in only where the...

DB2 Database

Same software, different hardware and abominable performance

by: sacha.prins | last post by:

Hi, I read a lot about DB2 INSERT performance here. I have a nice story as well. The thing is, I work on 2 installations of DB2 (on completely different locations) which run on different (but...

DB2 Database

one performance question...

by: jane | last post by:

HI, I have an performance questions... is # of tables in one tablespaces matter for performance point of view? why?

DB2 Database

Slow insert/logging performance

by: dunleav1 | last post by:

I have a process that does inserts that runs 50% slower that Oracle and Mssql. Queries normally take 50% slower than normal. DB2, Oracle, Mssql all are configured on same os, same disk array...

DB2 Database

no performance when creating or extending a tablespace

by: koos | last post by:

Hi, I`m a unix system administrator and they asked me to investigate a performance problem. When de DBA extends or creats a tablespace by 2Gb then we cannot connect to the database we already...

Oracle Database

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

no performance when creating or extending a tablespace

Similar topics