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.
Can someone here please help me? I am guessing this info is available via SQL if only I knew where and how to look.