Jignesh, I am Posting our IM's on this topic, I do not know If I
should but it
may be useful to revit this discussion.
Anand Zandy, I have a DB2 question
Anand Can I ask u
Zandy sure
Anand is it possible to restore a container if its mark bad or not
available for some reason without restoring the whole tablespace"?
Anand for eg: say 1 tablespace has 10 containers and i want to restore
only 1 container
Zandy Wow. That's some question you have there. Frankly I'm not yet
that adept with DB2 to answer it with certaintly but my gut tell me
it's possible as long as you have the backup of the transaction logs.
Zandy You can do a point in time restore
Anand Thanks
Zandy np. I can research it more if you want.
Anand My friend had a question, not me
Anand if time permits
Zandy I also depends on the version of DB2
Zandy I think in version 8 , you can do this
Anand he is using db2 udb 7.2/8.1
Anand Zandy he says .......but u know....if one container is not
available for some reason then crash recovery happens for that
tablespace
Anand he says ...................minimum recovery is a tablespace
recovery
Anand he says ...............in db2, data in tablespace is scatters
(rebalanced) in each and every container
Anand he says ....................in v8, one can drop a container
Zandy I see. Looks like your friend is right. I just did a quick
search in Google
Zandy
http://groups.google.com/groups?q=co...ups.com&rnum=1
Anand Zandy, I am just passing messages bet you guys :}>
Anand thx Zandy for your help
Zandy See one of the limitations of Db2? In informix, you can do this
since version 5
Zandy I really miss Informix :-(
Anand He says ..................but u know u cannot restore one table
in informix
Anand he is the same guy how has posted message on google :}>
Zandy :-)
Anand he is the same guy who has posted message on google :}>
Anand I guess he is correct, you can not restore one table in informix
Zandy that maybe true but there is still a workaround
Anand I asked him ............can you tell me ..what's container ...in
informix langauge ?
Anand he says ............in informix, we hve dbspace and in db2 we
hve tablespace
Zandy container is a chunk
Anand he says ...........in informix and db2, we have containers
within the tablespace/dbspace
Zandy tablespace = dbspace
Anand does informix has 2GB limitation on each chunk ?
Zandy not anymore. Since 9.4
Zandy only difference is that a tablespace in DB2 can only belong to
one database
Zandy in Informix, many databases can share a tablspace
Anand Thx a lot zandy for sharing all this info
Zandy np
jignesh74: Hi
Andy: kem cho ?
jignesh74: fine...howz u
Andy: good
jignesh74: cool
Andy: how's everything? any scoops ?
jignesh74:
jignesh74: no scoops
Andy: Hey, I got my watch, it was in the car ...sorry for the trouble
jignesh74: r u working on db2 udb database?
Andy: nope, only informix
jignesh74: hve any idea abt that
jignesh74: oh ok
jignesh74: i have one doubt
Andy: currently on Microsoft word
jignesh74:
Andy: what ?
jignesh74: container (raw device) kaa doubt hai
Andy: Shall I ask another friend who is working on db2 ?
jignesh74: yup...defi
Andy: okay, what's your question ?
jignesh74: just ask " is it possible to restore a container if its
mark bad or not available for some reason without restoring the whole
tablespace"?
jignesh74: for eg: say 1 tablespace has 10 containers and i want to
restore only 1 container
Andy: I will ask him
jignesh74: sooner the better
Andy: okay, will do
jignesh74:
jignesh74: can u ask rite now?
jignesh74: or say today?
Andy: yup, I am asking him right now
jignesh74: cool
jignesh74: i m waiting...
Andy: I have asked him, waiting for his answer
jignesh74: okie
jignesh74: i know it is not possible but just to be sure want to know
if someone expert mite have tried this...
Andy: okie, let see what he answers ..he is a techie
jignesh74: alrite...buzz me once u come get an answer from him
Andy: sure
Andy: his answer
Andy: Wow. That's some question you have there. Frankly I'm not yet
that adept with DB2 to answer it with certaintly but my gut tell me
it's possible as long as you have the backup of the transaction logs.
Andy: You can do a point in time restore
jignesh74: yes
jignesh74: hmmmm
Andy: what version of DB2 ur looking
jignesh74: as per his feedback...one can restore a container...rite?
jignesh74: db2 udb 7.2/8.1
Andy: he says ...I think in version 8 , you can do this
jignesh74: but u know....if one container is not available for some
reason then crash recovery happens for that tablespace
jignesh74: nopes
jignesh74: minimum recovery is a tablespace recovery
Andy: I am passing onto him ..what you say
jignesh74: in db2, data in tablespace is scatters (rebalanced) in each
and every container
jignesh74: in v8, one can drop a container
Andy: passing onto him...he is writing back
jignesh74: cool
Andy: he says .............I see. Looks like your friend is right. I
just did a quick search in Google
Andy:
http://groups.google.com/groups?q=co...ups.com&rnum=1
jignesh74: arre....that is my post re...
Andy: he says ...............See one of the limitations of Db2? In
informix, you can do this since version 5
jignesh74: but u know u cannot restore one table in informix....
Andy: I guess, you know more about DB2 than my friend here
Andy: does Container term in db2 matches with table in informix ?
jignesh74: arre nahi re
jignesh74: nopes
Andy: can you tell me ..what's container ...in informix langauge ?
jignesh74: in informix, we hve dbspace and in db2 we hve tablespace
jignesh74: in informix and db2, we have containers within the
tablespace/dbspace
Andy: so, what's container in db2 ?
jignesh74: all data resides in containers both in informix/db2
Andy: humm...I did not know about this ..in informix
jignesh74: arre...come on
jignesh74: containeers are raw device..u remember..each of 2gb
jignesh74: informix has a limitation of 2gb for each raw device
(container)
Andy: abbe ...chunk bole na
jignesh74: yup..wohi re
jignesh74: in US..they say containers...
Andy: ohh, okay
jignesh74: alriite...means chunks (informix) and container (db2) are
same
jignesh74: just like row and tuples
Andy: hey, chunk can be more than 2 GB ...since 9.4
jignesh74: i think u know wat is tuples
jignesh74: yup...i guess
Andy: okay, got it
jignesh74:
Andy: he says .............only difference is that a tablespace in DB2
can only belong to one database
Andy: is that right ?
jignesh74: nowadays no one says tuples
jignesh74: u can hve multiple partitions although
Andy: he says .....in Informix, many databases can share a tablspace
jignesh74: hmmmmmm
jignesh74: cool
jignesh74: yeh pata nahi tha re
jignesh74: one tablespace can share with more than one database...cool
Andy: only ...in informix ...
jignesh74: means....one chunk can have data from more than one
database...rite
Andy: okay jigu, I got to do some testing
Andy: will talk to u soon
jignesh74: or....one tablespace will hve 3 chunks of one database and
2 chunks of other database...rite
jignesh74: okie
Andy: yes
jignesh74: yes
Ian <ia*****@mobileaudio.com> wrote in message news:<41**********@corp.newsgroups.com>...
jignesh shah wrote: Hi all,
Is there a way to recover a single container if its been corrupted or
mark bad without restoring whole tablespace?
environment: db28.1/aix5.1/tsm/rs-6000.
Regards
Jignesh
No. Minimum recovery = tablespace.
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----