472,802 Members | 1,279 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,802 software developers and data experts.

about the system temporary tablespace

currently we are using db2 udb v8.1 on windows, if i create a new
regular tablespace with 8k page size, on a new bufferpool pagesize
8k, when i create a system temporary tablespace relate to this
tablespace, can i use the same bufferpool i created for regular
tablespace or i need to create different one?
Nov 12 '05 #1
1 3066
<db********@yahoo.com> wrote in message
news:11**************************@posting.google.c om...
currently we are using db2 udb v8.1 on windows, if i create a new
regular tablespace with 8k page size, on a new bufferpool pagesize
8k, when i create a system temporary tablespace relate to this
tablespace, can i use the same bufferpool i created for regular
tablespace or i need to create different one?


Same bufferpool can be used for both.
Nov 12 '05 #2

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

Similar topics

18
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
0
by: Paul | last post by:
I had the exact same problem today with the Temporary Tablespace errors. My disk was dirty (chkntfs e:) and all I had to do was bounce that disk resource (we're on a cluster). Once the resource...
0
by: Erik Hendrix | last post by:
OK, I've got a question here regarding a SMS system temporary tablespace. Within here there is overall at least 1 file (SQLTAG.NAM). Now let's say that we have other files there as well created by...
6
by: gimme_this_gimme_that | last post by:
I'm new to DB2 ... The following statement results in a SQL1585N message : "A system temporary table space with sufficient page size does not exist" Note that the column FIELD_DETAIL is a...
9
by: Andy K | last post by:
Hi , I've setup the replication for db2 but at the end of the replcation , DB2 came out with the message error (see below) . I have no idea why it shows me this error . I have two tablespaces...
1
by: nkumarin001 | last post by:
Hi, Sorry i typed a wrong question last time. Please help me in this question. 1) Why we cant bring "temporary tablespace" offline? 2) Why we can bring "tempfile" offline? Regards,...
0
by: rajdb2 | last post by:
There is no option to specify use tempspace for reorg indexes all in V8 FP 12. is there any way We can force the use of temporary tablespace with reorg indexes all command? There is a space...
6
by: Troels Arvin | last post by:
Hello, I have recently run a rather large data import where the imported data i pumped through some updatable views equipped with INSTEAD OF triggers. For various reasons, the exact same data...
0
by: sammioooo | last post by:
hi,guys i am new to db2, today when i created db, the problem came out.below is the code: CREATE DATABASE testzy AUTOMATIC STORAGE NO ON 'C:\' USING CODESET UTF-8 TERRITORY US COLLATE USING...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 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: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 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: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
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=()=>{
0
by: lllomh | last post by:
How does React native implement an English player?
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth

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.