472,958 Members | 2,498 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Tempspace full at MQT refresh in DB2 V8 for Solaris

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. Detected on
container
"/db2/db2inst2/db2inst2/NODE0000/SQL00002/SQLT0001.0" (ID "0"). The
underlying
file system is full or the maximum allowed space usage for the file
system has
been reached. It is also possible that there are user limits in place
with respect to maximum file size and these limits have been reached.

The file system is not full.
The remaining limit we can think of is that we might need a file size
of more then 2 GB
But the Solaris file size limits are checked and should be unlimited
(infinity).
Can a 32 bits DB2 instance allocate larger files than 2 GB ?
Will DB2 split a large tempfile into 2 files if needed ?
Would an extra tempspcae help ?
Any other comment are wellcome

Mats Mohlin IBM SW Sweden

Nov 12 '05 #1
3 4409
Mats Mohlin wrote:
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. Detected on
container
"/db2/db2inst2/db2inst2/NODE0000/SQL00002/SQLT0001.0" (ID "0"). The
underlying
file system is full or the maximum allowed space usage for the file
system has
been reached. It is also possible that there are user limits in place
with respect to maximum file size and these limits have been reached.

The file system is not full.
The remaining limit we can think of is that we might need a file size
of more then 2 GB
But the Solaris file size limits are checked and should be unlimited
(infinity).
Can a 32 bits DB2 instance allocate larger files than 2 GB ?
Will DB2 split a large tempfile into 2 files if needed ?
Would an extra tempspcae help ?
Any other comment are wellcome

Mats Mohlin IBM SW Sweden


Yes, DB2 can allocate files > 2GB in the temp space and no, we will
not split the file if a limit is reached. Check the quota for the id
of the instance owner, many installations don't allow users to create
files > 2GB.

Regards,
Miro

Nov 12 '05 #2
To clarify - DB2 has supported >2 GB files since back in v5, when there
was no 64-bit memory addressable version of DB2. I would suspect a
ulimit problem first.

(When we talk about 32-bit and 64-bit DB2 in the manuals, it refers to
DB2's memory addressability. 32-bit DB2 has no particular 32-bit limits
for stuff like files or BIGINT values - just for memory addressability.)

miro flasza wrote:
Mats Mohlin wrote:
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. Detected on
container
"/db2/db2inst2/db2inst2/NODE0000/SQL00002/SQLT0001.0" (ID "0"). The
underlying
file system is full or the maximum allowed space usage for the file
system has
been reached. It is also possible that there are user limits in place
with respect to maximum file size and these limits have been reached.

The file system is not full.
The remaining limit we can think of is that we might need a file size
of more then 2 GB
But the Solaris file size limits are checked and should be unlimited
(infinity).
Can a 32 bits DB2 instance allocate larger files than 2 GB ?
Will DB2 split a large tempfile into 2 files if needed ?
Would an extra tempspcae help ?
Any other comment are wellcome

Mats Mohlin IBM SW Sweden


Yes, DB2 can allocate files > 2GB in the temp space and no, we will
not split the file if a limit is reached. Check the quota for the id
of the instance owner, many installations don't allow users to create
files > 2GB.

Regards,
Miro


Nov 12 '05 #3
AK
maybe it would be nice to have a look at the query that defines the
MQT.
Some techniques such as index-only access couls significantly reduce
the need for temporary space
Nov 12 '05 #4

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

Similar topics

1
by: noone | last post by:
Can u import only specific user / non-system tables ( FULL=N ) from a full export ( FULL=Y ) ? Does it matter if the export was done on 64-bit Solaris SPARC and the import will be done on an...
2
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...
1
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...
15
by: (Pete Cresswell) | last post by:
I've got a .BAT file that I use for executing various MS Access apps that I wrote way back in the days of 2.0. It's evolved over time, but it still contains a number of possible paths to...
0
by: mdb_1974 | last post by:
Hello I tried to do an initial full refresh but I failed - nothing happens (no error at all). Apply works without errors. Details of my environment: I have the following replication scenario:...
0
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...
2
by: jeffrey.bigham | last post by:
Hello, I'm developing an application in C# using the WebBrowser control and need to toggle images off and on. After some digging, I found the appropriate registry key that needs to be set and...
1
by: debayan.bhattacharya | last post by:
I am trying to add new tables to the source and target databases and adding them for replication. I am trying not to start a full refresh by issuing a CAPSTART signal. I have 1 source database and...
0
by: mg | last post by:
When make gets to the _ctypes section, I am getting the following in my output: building '_ctypes' extension creating build/temp.solaris-2.10-i86pc-2.5/home/ecuser/Python-2.5.1/ Modules/_ctypes...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
2
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

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.