by: Joachim Mueller |
last post by:
This sql statement dies after using more than 40GB Tempspace:
INSERT INTO dcp.cmp_mo_p_bab_kart ( currency, year,
figure, period, month_date, company, center, account,
value )
SELECT
CASE...
|
by: Mats Mohlin |
last post by:
We are testing Db2 Cube Views on DB2 V8 for Solaris
Small MQT get created OK but for a big MQT we get this message in the
db2diag.log
ADM6017E The table space "TEMPSPACE1" (ID "1") is full....
|
by: News |
last post by:
I have 18 years of mainframe DB2, and I just starting working with UDB LUW
V8.1 FixPack 6 on Sun Solaris last week.
I have been dismayed on the lack of detailed info available in the manuals
on...
|
by: Visu |
last post by:
Hi all,
DB2 - Ver 7.2 EEE on AIX
This Sytem temporary tablespace in question is created on all the 5
nodegroups, and the containers are in 5 different filesystems. For some
reason only one...
|
by: jcgeorge |
last post by:
I have a Windows DPF (v8.2.2) environment.
2 Nodes
5 Partitions
Server1 - Cat (0) Data (1) Data (2)
Server2 - Data (3) Data (4)
I want to use block-based IO, but I do not want the same size...
|
by: apple |
last post by:
How large should tempspace be relative to the largest table in a
database to do reorgs? Does tempspace have to be at least twice the
size of the table being reorged. Assuming nothing is using...
|
by: ralphedge |
last post by:
These sorts work fine on 100000 ints but if I go much higher they will
both segmentation fault
**************************MERGESORT*********************
mergesort(int *a, int size) //a is...
|
by: alexhguerra |
last post by:
Hello
Is it possible that a reorg index doesnt use a sys temporary
tablespace and use the index tablespace in a reorg index? (db2 udb v8
fixpack 12 - there are 2 8k system tablespaces on this...
|
by: db2udb |
last post by:
Hi, I have just taken over as the DBA for a database that has not had any reorgs/runstats run against it for the last three years. As a first step, I have just run reorg/runstats against the system...
|
by: erbrose |
last post by:
Hello All!
Hoping some folks could help me optimize and or choose the best route to do this process.
First off, here is what I am trying to achieve. I have a (fairly large) table of ~34million rows...
|
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: 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: 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....
|
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...
|