New to IBM Universe...Mind helping?

[markdialmark]

The company i work for has been running a Pick based system(mvbase) for several years, we are switching over to IBM Universe database in a Linux environment.

i havent had much help from IBM loading Universe, but i did manage to get it to go. I have done a t-dump (to a .vtf file)from my old PICK system of one account and am wanting to t-load this into universe. my question...

how do i attache to the .vtf file so i can perfrom a t-load to load the account.

mark

 

[bi]

Mark,

Is Universe IBM's new name for Informix? If it is, you might try asking in Tek-Tips' Informix forum.

 

[markdialmark]

I think that IBM owns Universe and Informix and they are interjoined somehow???

 

[bi]

Yeah. They probably renamed it, but I'm not sure.

 

[AIXSPadmin]

Incorrect. UniVerse was owned previously by VMark Software and was bought out shortly after or before IBM purchased Informix.

When I went back to visit friends at the company I used to work for, where we ran UniVerse, I was told that IBM was folding it into DB2 and they were going to have to go through another conversion like they did when I was there and was Unibol36 supported.

I am not sure what IBM plans to do with Informix, however, I cannot see them keeping it around. I would envision them migrating customers with Informix databases to DB2 when they get an easier way created to do it.

 

[markdialmark]

well now we have that cleared up, thank you...

anyone have any isights on my original post????

 

[KenCunningham]

Mark, there is actually a Pick forum on this site, though it isn't well-used - do a search for Pick in the forums. You might get an answer there. As an ex Prime Information man, I can sympathise with your predicament!

 

[bmulvey]

Hi,

I am running IBM UniVerse v10.0.7.1 on IBM Aix, but the ports to Linux should be just as good.

We ported from PRIME OS to PI/OPEN then UniVerse

It was a VMark product, who joined with UniData to form Ardent, who were then bought over by Informix for their middleware (Web) tools. IBM then Gobbled up Informix and called Universe and UniData U2.

As UniVerse is a multivalued database, IBM have no plans to merge it with DB2, and according to Susie Siggesmund IBM director of U2 products they are fully committed to develop and maintain it.(whatever that means)

As regards your question, universe has 2 utilities called uvbackup and uvrestore. They do backup and restore record by record, which is similar to the way tdump and tload works.

There is also a tool called fnuxi which byte swaps files. this is great when you change from say Intel to Motorola processors or vice versa (depends on byte order of multi-byte words, which is hardware specific)


Hope this is of some help

 

[AIXSPadmin]

For whatever it is worth, a friend at my former company said they have to move off of UniVerse and onto DB2.

Maybe he did not have all the details or not privvy to all the information, but that is what was conveyed to me.

 

[bmulvey]

Hi,

I was checking out the UniAdmin tool on my UniVerse system and there is a specific option to restore a PICK backup so this may help too.

To Get this install the UniVerse Clients on a PC, start UniAdmin, log-on, and next to the backup and restore tape icons there is a UniVerse import tool. One of its options is to restore from a PICK account.