473,326 Members | 2,125 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Testing db2 imp and load

hello,

I have tested to import around 10,000,000 delimited flat file(about 1G)
into DB2 UDB 8.2 in AIX machine. I have 4 WAY and 8GB AIX box (no
application running this time. it's a development machine)

During the import, I didn't modify the bufferpool size and I had to
cancel half way because it was taking way too long.

My question is will adding say lots of bufferpool help in this case? I
am using commitcount of 5000? Will commitcount slows it down
significantly? Nevermind the disk layout (I only have 2 x 73.4 disks),
what can possibly be faster way to import the 10 million rows into the
database? In other words, how do I maximize the import and reduce the
import time?

if anyone can help mention the parameters that affect the import, I
will apprecite much. Will the same parameters apply to DB2 Load?

Db2 Novice

Nov 12 '05 #1
1 1811
Ian
DB2 Novice wrote:
hello,

I have tested to import around 10,000,000 delimited flat file(about 1G)
into DB2 UDB 8.2 in AIX machine. I have 4 WAY and 8GB AIX box (no
application running this time. it's a development machine)

During the import, I didn't modify the bufferpool size and I had to
cancel half way because it was taking way too long.


Read the Data Movement & Utilities Guide. This is discussed.

Short answer: Use LOAD.

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Andrew | last post by:
Hi, I am thinking about ways for efficient techniques for isolation testing. Here is the problem as I see it: Complex OO systems are designed with massive number of dependencies between modules...
0
by: Michael Weiner | last post by:
I know this is quite a bit off topic, but i was wondering if anyone else out there had any experience with Segue's Silk Performer load testing tools. More specifically, i am trying to compile a...
1
by: Manish Gupta | last post by:
Hi there Can any one tell me the way to do load / stress testing of a client server based application. This is a Stand-alone application made using C#. Regards Manish
0
by: Von Shean | last post by:
Are there any tools from microsoft or any 3rd party in the following catagories 1. Functional Client/Server Testing 2. Functional Web Testing 3. Web Load Testing 4. DB Load Testing In dotNet...
6
by: Shabam | last post by:
A web application of mine developed using C# + MS SQL runs fine normally. However when I stress test it with a load testing software (using about 60 simultaneous users) some instances start...
2
by: Curtis Justus | last post by:
Hi, I've been searching for solutions to two issues that are undoubtedly common to everybody. The first is how do my team and I adequately perform unit testing. The second is how can I measure...
0
by: Chuck | last post by:
Sorry for the advertisement but I think this is something that people could actually use. I am creating a new product called Simple Load Testing and I thought I would see if anyone would be...
2
by: Chris | last post by:
I am looking for web testing software. Can anyone recommend something, preferably not expensive. It also has to be useful for classic ASP as well as .net. I looked at ANTS, which I liked but it...
5
by: =?Utf-8?B?U2FsYW1FbGlhcw==?= | last post by:
Hi, I know that VS 2005 has a lot of testing features and already used them for doing web load testing. I am wondering if it is possible to load test a win forms application. I don't mean writing...
11
by: VK | last post by:
In the continuation of the discussion at "Making Site Opaque -- This Strategy Feasible?" and my comment at http://groups.google.com/group/comp.lang.javascript/msg/b515a4408680e8e2 I have...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.