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

5.1.7!! Boy, this is a blast from the past. You may have more luck
posting this question on "redbrick-list (AT) iiug (DOT) 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 (AT) hotmail (DOT) com (Paul) wrote in message news:<c6ae8f05.0406091753.52be1f6e (AT) posting (DOT) google.com>...