TEMPSPACE1 use 
Author Message
 TEMPSPACE1 use
Hi to all,

I had a problem with a query that cancelled due to lack of free pages
in TEMPSPACE1. Originally the TEMPSPACE1 was 2,5GB and I added another
2GB of space. Then I issued again my query and it cancelled again.

When I look at TEMPSPACE1 detail (list tablespaces show detail
command) I see that the maximum ever used space is 2,5GB. Do I have to
stop and start DB2 in order to allocate the new 2GB space?

Thank you in advance
Demetris



Fri, 07 May 2004 14:58:16 GMT
 TEMPSPACE1 use

Increase the space for a tablespace should take effect after you finish
the command.
Thanks,
Fan Ruo Xin
Quote:

> Hi to all,

> I had a problem with a query that cancelled due to lack of free pages
> in TEMPSPACE1. Originally the TEMPSPACE1 was 2,5GB and I added another
> 2GB of space. Then I issued again my query and it cancelled again.

> When I look at TEMPSPACE1 detail (list tablespaces show detail
> command) I see that the maximum ever used space is 2,5GB. Do I have to
> stop and start DB2 in order to allocate the new 2GB space?

> Thank you in advance
> Demetris



Fri, 07 May 2004 23:35:58 GMT
 TEMPSPACE1 use
Yes - you have to stop/start DB2 anytime you make changes to parameters that
effect the manager or the database (a tablespace change is definitely one of
those conditions).

ML

Quote:
> Hi to all,

> I had a problem with a query that cancelled due to lack of free pages
> in TEMPSPACE1. Originally the TEMPSPACE1 was 2,5GB and I added another
> 2GB of space. Then I issued again my query and it cancelled again.

> When I look at TEMPSPACE1 detail (list tablespaces show detail
> command) I see that the maximum ever used space is 2,5GB. Do I have to
> stop and start DB2 in order to allocate the new 2GB space?

> Thank you in advance
> Demetris



Sat, 08 May 2004 00:15:34 GMT
 TEMPSPACE1 use
Quote:


> > Hi to all,

> > I had a problem with a query that cancelled due to lack of free pages
> > in TEMPSPACE1. Originally the TEMPSPACE1 was 2,5GB and I added another
> > 2GB of space. Then I issued again my query and it cancelled again.

> > When I look at TEMPSPACE1 detail (list tablespaces show detail
> > command) I see that the maximum ever used space is 2,5GB. Do I have to
> > stop and start DB2 in order to allocate the new 2GB space?

> > Thank you in advance
> > Demetris


Quote:
> Yes - you have to stop/start DB2 anytime you make changes to parameters that
> effect the manager or the database (a tablespace change is definitely one of
> those conditions).

> ML

Sorry Mike, but I have to disagree with you. The temp tablespace is
part of a database, so maybe the database needs to be deactivated
before extra tempspace will be active but I have my doubts about it.
When a normal tablespaces is expanded the new space is available as
soon as the rebalancer finishes it's job. I'm not sure if it's works
different with temp tablespaces but I don't expect it.

Kind regards, Gert



Sat, 08 May 2004 02:12:19 GMT
 TEMPSPACE1 use
If tempspace is an SMS tablespace, all you have to do is increase the
filesystem.  However, if you have multiple containers, when one is full, the
database declares the tablespace as full.

If tempspace is a DMS tablespace, you also have to extend the container(s)
in V7.  In v6 you have to add a new container.  If the containers are
different sizes, the database will use all the available space - however it
is less efficient than using containers that are all the same size.

To go above 2GB on DB2 on AIX, the filesystem must be large file enabled.
However, a file will only be created as big as the ulimit.

Jeremy



Quote:


> > > Hi to all,

> > > I had a problem with a query that cancelled due to lack of free pages
> > > in TEMPSPACE1. Originally the TEMPSPACE1 was 2,5GB and I added another
> > > 2GB of space. Then I issued again my query and it cancelled again.

> > > When I look at TEMPSPACE1 detail (list tablespaces show detail
> > > command) I see that the maximum ever used space is 2,5GB. Do I have to
> > > stop and start DB2 in order to allocate the new 2GB space?

> > > Thank you in advance
> > > Demetris


> > Yes - you have to stop/start DB2 anytime you make changes to parameters
that
> > effect the manager or the database (a tablespace change is definitely
one of
> > those conditions).

> > ML

> Sorry Mike, but I have to disagree with you. The temp tablespace is
> part of a database, so maybe the database needs to be deactivated
> before extra tempspace will be active but I have my doubts about it.
> When a normal tablespaces is expanded the new space is available as
> soon as the rebalancer finishes it's job. I'm not sure if it's works
> different with temp tablespaces but I don't expect it.

> Kind regards, Gert



Sat, 08 May 2004 05:20:59 GMT
 TEMPSPACE1 use
For a DMS tablespace, when you need to add container, the tablespace will be
available after you submit this command. The rebalance activity will run
asynchronously.


Quote:


> > > Hi to all,

> > > I had a problem with a query that cancelled due to lack of free pages
> > > in TEMPSPACE1. Originally the TEMPSPACE1 was 2,5GB and I added another
> > > 2GB of space. Then I issued again my query and it cancelled again.

> > > When I look at TEMPSPACE1 detail (list tablespaces show detail
> > > command) I see that the maximum ever used space is 2,5GB. Do I have to
> > > stop and start DB2 in order to allocate the new 2GB space?

> > > Thank you in advance
> > > Demetris


> > Yes - you have to stop/start DB2 anytime you make changes to parameters that
> > effect the manager or the database (a tablespace change is definitely one of
> > those conditions).

> > ML

> Sorry Mike, but I have to disagree with you. The temp tablespace is
> part of a database, so maybe the database needs to be deactivated
> before extra tempspace will be active but I have my doubts about it.
> When a normal tablespaces is expanded the new space is available as
> soon as the rebalancer finishes it's job. I'm not sure if it's works
> different with temp tablespaces but I don't expect it.

> Kind regards, Gert



Sun, 09 May 2004 23:46:35 GMT
 TEMPSPACE1 use
Quote:



> > > > Hi to all,

> > > > I had a problem with a query that cancelled due to lack of free pages
> > > > in TEMPSPACE1. Originally the TEMPSPACE1 was 2,5GB and I added another
> > > > 2GB of space. Then I issued again my query and it cancelled again.

> > > > When I look at TEMPSPACE1 detail (list tablespaces show detail
> > > > command) I see that the maximum ever used space is 2,5GB. Do I have to
> > > > stop and start DB2 in order to allocate the new 2GB space?

> > > > Thank you in advance
> > > > Demetris


> > > Yes - you have to stop/start DB2 anytime you make changes to parameters that
> > > effect the manager or the database (a tablespace change is definitely one of
> > > those conditions).

> > > ML

> > Sorry Mike, but I have to disagree with you. The temp tablespace is
> > part of a database, so maybe the database needs to be deactivated
> > before extra tempspace will be active but I have my doubts about it.
> > When a normal tablespaces is expanded the new space is available as
> > soon as the rebalancer finishes it's job. I'm not sure if it's works
> > different with temp tablespaces but I don't expect it.

> > Kind regards, Gert


Quote:
> For a DMS tablespace, when you need to add container, the tablespace will be
> available after you submit this command. The rebalance activity will run
> asynchronously.

I've seen different situations with V5.2. Only after the rebalancer
was finished the new container was available for regular use.  Of
course, the old container remains available but if it's already 100%
filled, it's of no use.
I don't know if this behaviour has changed in other releases, I can't
verify it right now.


Mon, 10 May 2004 02:26:13 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. Create index/tempspace1 problem...

2. TEMPSPACE1 is FULL or file is too large (at OS or user limit)

3. Export Data using DTS Import using BULK INSERT

4. connecting to a remote server using vb+sql server using ADO

5. Problem using LEFT JOIN ON using SQL Server 6.5

6. Anybody using / developing GATEWAYS using ODS ?

7. connecting to a remote server using vb+sql server using ADO

8. Anybody using / devloping gateways using ODS ?

9. How would I get the list of word used in the query using inflection

10. Using DTS packages, using Global Variables

11. Is this possible using T-SQL instead of using cursor

12. Using dynamic SQL better than using an sp?


 
Powered by phpBB® Forum Software