Yes you will have to create an 8k page system temporary tablespace for your
regular table space that is also 8k. The docs. are very clear on this.
The buffer pool can be shared by both the temprary and the regular
tablespace.
Regards, Pierre.
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
----- Original Message -----
From: "Sheuehua" <db2udbdba-ezmlmshield-x54999909.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Sunday, December 10, 2006 9:41 AM
Subject: system temporary tablespace


>
>
>
>
> Hi all,
> I am using db2 v.7.2; I will create a regular table space with
> 8K page size; all other table space are all 4K ( including one system
> temporary tables pace with 4K) in production already. I know I have to
> create a 8K page size buffer pool, do I need to create another system
> tablespace with 8K page ? Please advise !!
>
> Thanks all.
>
> Sue
>
>
> **********************************************************************
> This e-mail transmission and any attachments that accompany it may
> contain information that is privileged, confidential or otherwise exempt
> from disclosure under applicable law and is intended solely for the use of
> the individual(s) to whom it was intended to be addressed. If you have
> received this e-mail by mistake, or you are not the intended recipient,
> any disclosure, dissemination, distribution, copying or other use or
> retention of this communication or its substance is prohibited. If you
> have received this communication in error, please immediately reply to the
> author via e-mail that you received this message by mistake and also
> permanently delete the original and all copies of this e-mail and any
> attachments from your computer. Thank you.
> **********************************************************************
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>



DB2 & UDB email list listserv db2-l LazyDBA home page