Re: Red Brick SQL BackTrack (Back Track)

5.1.7!! Boy, this is a blast from the past. You may have more luck posting this question on "redbrick-list@iiug.org". I dusted-off some old memories, and believe that Red Brick (when it was it's own company in Los Gatos, CA.) and BMC (The makers of BackTrack) parted ways some time before Informix bought Red Brick, and as I remember it seemed to be based on the reliability of BackTrack. And I believe that 5.1.7 was the last version of Red Brick that worked with BackTrack. Check with the guys and gals on the redbrick-list, but I thought that Red Brick doesn't use transactions, so after you've completed you import the database is static, and available to be backed-up using your favorite file system backup utility. I remember one of the ways that tech support reproduced bugs was to ask the client to tar-up their data and schema and send it to them . . . Hope this helps. Brice Avila Minneapolis, Minnesota paul_p_francis@hotmail.com (Paul) wrote in message news:<c6ae8f05.0406091753.52be1f6e@posting.google.com>... > Spin up the phono player, slip on the 45 adapter, these are some > goldie oldies. > > Recently, a little known DW system of ours crashed and had to be > rebuilt from old and fragged fs backup tapes. The server is an > AXP-OSF4/Tru64 running Red Brick (5.1.7). Amazingly Red Brick is up > and running with data objects intact but most of the data is lost. As > we replenish the data from various sources, we started looking for a > way to make logical backups. In the meanwhile we started doing > physical backups of the PSU's daily. > > While rummaging around in our storage room I came across a SQL > BackTrack CD and docs for Red Brick version 1.0.2. Obviously this > wasn't being used previously and I've been tasked with trying to get > this running. > > I installed the Back Track CD and everything seems to have installed > well. For those familiar with this software, the license was accepted > and inserted into rbw.config. Other items such as the catalog, the > pool are also done. I've created a backup segment, etc. and most of > the other items checklisted in the documentation. But, when I run this > command: > rb_btbackup -database wtv -level 0 > > I get this error: > SQL-BackTrack for Red Brick Warehouse > Copyright (c) 1991-1998, DataTools, Inc. > Version 1.0.2 > > *** Started on 06/09/2004 17:28:04 > > [dump initiator 24458] DT-31517E: Red Brick API error, result code = > 4. > [dump initiator 24458] DT-31515E: can not connect to Red Brick > Warehouse server. > [dump initiator 24458] DT-33534W: Online backup completed with errors. > > *** Finished on 06/09/2004 17:28:04 > *** Elapsed time: 0 seconds > *** Highest return code: 255 > *** rb_btbackup completed with errors. > > I believe I may have the problem identified. The rb_btbackup seems to > call rb_btdi at a certain point, like this: > rb_btdi -database WTV -level 0 -tasks 1 MG9K8GRYSR63TG28 > JJ24XH4ETMLM3G3 > > This seems to be failing on the encrypted userid and password. The > fstat on rb_btdi is > "COFF format alpha demand paged setuid executable or object module not > stripped - version 3.11-8" > > When I run it directly it gives me this: > *** ERROR *** : This program cannot be executed directly > > Using rb_btcreate, I've reinitialized the userid and passwords several > times all to no avail. I then went into the RB_HOST/WTV_profile file > and manually tried changing things to encrypted, plain, blank, etc. > all of which generated the same error. I also tried passing > userid/password as parms when calling rb_btbackup which didn't work. > > I tried to trace rb_btdi but it only runs literally for about 1/10 > second. Is there a way to pin trace to an executable indefinitely?? > If anyone has ideas/suggestions as to solutions or even with further > diagnosis, I would certainly appreciate it. > > Thanks, > --Paul