Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Multiple partitions and table space,confusion,please assist.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
DB2 Guy

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Tue Jul 14, 2009 6:42 pm    Post subject: Multiple partitions and table space,confusion,please assist.
Reply with quote

If a table has multiple partitions, does that mean the table-space in which this table resides can have only "this table"?

This (above written text) I've been told by my DBA. But I'm kind of skeptical about this. This should depend on the table-space whether it can contain multiple tables or not. I tried in google and in Manuals, but I'm, probably, kind of stupid to understand on what key-words should I search on.

Can some one please assist me on this.
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Jul 14, 2009 7:48 pm    Post subject:
Reply with quote

Hi,

Partition Tablespace supports only one table per tablespace.

Segment Tablespace supports multiple tables, each segment will contain data from only one table.

Simple Tablespace supports multiple tables. - each page might contain data from different table
Cannot be created from V9, but supported.

Try googling with keyword like
DB2+administration guide+v8

Sushanth
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Jul 14, 2009 9:10 pm    Post subject:
Reply with quote

Hello,

Quote:
But I'm kind of skeptical about this.
And you are skeptical of what your dba tells you because. . . .?

At the top of the page is a link to "IBM Manuals" among which are manuals for several versions of DB2.
Back to top
View user's profile Send private message
DB2 Guy

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Thu Jul 16, 2009 11:56 pm    Post subject:
Reply with quote

Hi Dick,

..because I percept the concept of table-sapce as... as if we have a big-container (table-space) and we put multiple small-containers (tables) in it for simple table sapce. Probably it's correct to thibk this way.

I thought partition table sapce means multiple big-containers...but it seems it's not that way.

I searched on IBM but again it seems I hit a wrong manual again.. http://www.ibm.com/developerworks/db2/library/techarticle/dm-0605ahuja2/
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jul 17, 2009 1:48 am    Post subject:
Reply with quote

Hello,

Quote:
I thought partition table sapce means multiple big-containers...
It is - they just have to all be the same type of container. . .

Suggest you look in the manual about the partitioning index. This may help clarify.
Back to top
View user's profile Send private message
wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Fri Jul 17, 2009 7:10 am    Post subject: Reply to: Multiple partitions and table space,confusion,plea
Reply with quote

DBA is right.

The container concepts from DB2 LUW don't always have equivalent things in DB2 for z/OS.
Back to top
View user's profile Send private message
DB2 Guy

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Fri Jul 17, 2009 10:08 pm    Post subject:
Reply with quote

Quote:
It is - they just have to all be the same type of container. . .
But if this container is capable enough to have multiple tables..as I said here
Quote:
as if we have a big-container (table-space) and we put multiple small-containers (tables) in it for simple table sapce
isn't it that way?
Back to top
View user's profile Send private message
DB2 Guy

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Fri Jul 17, 2009 10:10 pm    Post subject: Re: Reply to: Multiple partitions and table space,confusion,
Reply with quote

wanderer wrote:
The container concepts from DB2 LUW don't always have equivalent things in DB2 for z/OS.
When will they differ then, please let me know.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jul 17, 2009 10:24 pm    Post subject:
Reply with quote

Hello,

Quote:
Quote:
It is - they just have to all be the same type of container. . .

But if this container is capable enough to have multiple tables..as I said here
A different table would equate to a different type of container. . .

Maybe looking at this from another perspective could help. . . The partitioning index determines which rows are placed in which partition. Indexes are created for a table, not a partition.
Back to top
View user's profile Send private message
wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Sat Jul 18, 2009 12:56 am    Post subject: Re: Reply to: Multiple partitions and table space,confusion,
Reply with quote

DB2 Guy wrote:
wanderer wrote:
The container concepts from DB2 LUW don't always have equivalent things in DB2 for z/OS.
When will they differ then, please let me know.


Since I don't have much experience in DB2 LUW, I can't compare well, but if you have any specific query about DB2 z/OS then I can tell if it is possible or not. Like the partition question here.

Until V7 there were lots of difference between DB2 z/OS and LUW. With V8 and V9, IBM has tried to make them somewhat similar to increase portablity especially of SQLs.

Partitioning concept is very different in z/OS though.

Anyway, since V8 you don't need an index for the table to be partitioned. The ranges can be defined in table DDL.

In V9 there is a concept of partition by growth which probably is somewhat similar to LUW(caution: I have limited LUW understanding)

The best place to look is DB2 z/OS manuals before coming to conclusion.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Adding a userid to SMTP Security table Yolanda Harvey JCL & VSAM 1 Sun Aug 13, 2017 6:16 pm
No new posts Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm
No new posts Changeman get multiple "Browse C... elixir1986 Compuware & Other Tools 4 Fri Jul 14, 2017 1:48 am
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us