emebohw

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.

art s. kagel

SELECT tabname, partdbsnum( partnum )
FROM sysmaster:systabnames
WHERE dbsname = 'mydatabase';
Art S. Kagel

emebohw

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!