by: Ulrich Sprick |
last post by:
Hi all,
(DB2 V7.1 for WinNT)
I am looking for a way to determine the free space in my tablespace (containers), but I can't find out. The tablespace in question
is a system managed tablespace in...
|
by: aaronk321 |
last post by:
I'm cloning a db and I need to redirect the files using the set
tablespace container command. However, that command requires the size
of the tablepsace - I've developed the following sql which...
|
by: duoduo |
last post by:
I want to know one thing, what is best design for tablespace
containers, of course, it is DB2 EE 7.2 on AIX 4.3.3.
For example, I have RAID 0+1 storage (8 disks) on EMC Symmetrix. Now I
need to...
|
by: mairhtin o'feannag |
last post by:
Hello,
I have a tablespace striped across three drives, call them 1,2,3, just to
be clever. :) I allocated a lot more space (DMS) than I should have,
since I didn't know a way to estimate the...
|
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...
|
by: db2dude |
last post by:
Hello all,
I have a database around 600GB and all tables were self-created by the
application. Hence, we have only one huge SMS tablespace where all the
tables are stored. To get better...
|
by: sharon.zhang.ca |
last post by:
Hi,
I'm using the following command to redirect restore from source
database AAA into target database BBB:
db2 restore db AAA from /DBBACKUP taken at 20080512100655 redirect
into BBB without...
|
by: bluefalcon |
last post by:
Hello,
I had created the backup of my Production DB2 database on Dev and It was working fine.
However, we decided to updated the Dev Db with a latest version of the Prod and for that I copied over...
|
by: Justin |
last post by:
What is the difference between automatic and DMS Auto-resize
tablespace?
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
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...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
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...
|