identify all DBSpaces that make up a database in order to know what to restore
On Wed, 08 Sep 2004 10:58:09 -0400, sumGirl wrote:
SELECT tabname, partdbsnum( partnum )
FROM sysmaster:systabnames
WHERE dbsname = 'mydatabase';
Art S. Kagel
> Hello all. I sure hope someone here can help me because informix support did
> not seem very interested in my question. I have two systems running
> informix, one system A has much more storage space on it than the other
> (system B!). I have two databases in the same instance on system A and I
> want to restore only one of those databases to system B. I should be able to
> do this by identifying all of the dbspaces on system A that make up the
> database in question and then use ontape -D to restore the three critical
> dbspaces and plus the dbspaces that make up this database. When I ran this
> by support, they were not at all helpful and told me I might be able to use
> oncheck -PE to identify all of the dbspaces I need. They also seemed very> smug and told me that most people would just have two systems that are the
> same size in order to accomplish this...that sort of rubbed me the wrong
> way, but oh well. I need to do it and I know there must be an easier way to
> identify the dbspaces I need to restore and it burns me up that I cant get
> more help than this from IBM. The oncheck -PE is such a mess from a ease of
> use standpoint that I cant imagine how it would be useful other than going
> through it by hand with a highlighter and ruler and even then the possiblity
> for human error would be huge!
>
> Can someone here please help me? I am guessing this info is available via
> SQL if only I knew where and how to look.
Hello all. I sure hope someone here can help me because informix
support did not seem very interested in my question. I have two
systems running informix, one system A has much more storage space on
it than the other (system B!). I have two databases in the same
instance on system A and I want to restore only one of those databases
to system B. I should be able to do this by identifying all of the
dbspaces on system A that make up the database in question and then
use ontape -D to restore the three critical dbspaces and plus the
dbspaces that make up this database. When I ran this by support, they
were not at all helpful and told me I might be able to use oncheck -PE
to identify all of the dbspaces I need. They also seemed very smug and
told me that most people would just have two systems that are the same
size in order to accomplish this...that sort of rubbed me the wrong
way, but oh well. I need to do it and I know there must be an easier
way to identify the dbspaces I need to restore and it burns me up that
I cant get more help than this from IBM. The oncheck -PE is such a
mess from a ease of use standpoint that I cant imagine how it would be
useful other than going through it by hand with a highlighter and
ruler and even then the possiblity for human error would be huge!
Can someone here please help me? I am guessing this info is available
via SQL if only I knew where and how to look.
I was hoping I would hear from you Art! I cant believe support couldnt go out on a limb and give me that...thank heavens for you!