On Apr 7, 2005 12:47 PM, Sven Geipel <sven-geipel@web.de> wrote:
> martin.bowes@ctsu.ox.ac.uk schrieb am 07.04.05 11:01:02:
>
> [...]
>
> > Fortunatly this is an easy exercise.
> > 1. ingstop.
> > 2. Use the CBF utility.
> > Select the 'Transaction Log' option from the main menu. It will
> > then display a log configuration screen. Given that your log has
> > been destroyed when you removed it. The system should
> > recognise this fact and provide a 'Create' option.
>
> Unfortunatly, I come not to this point:
> ingstop is ok. but cbf says:
>
> E_CL1F05 The environment variable, II_TIMEZONE_NAME, is undefined
>
> and then:
>
> II_INSTALLATION must be set before the configuration utility is run.
>
> [...]
>
> > I re-read your original post and see that you have ingprenv
> > symlinked to ./ingprenv. You need to remove that link. Then see if there
> > is a $II_SYSTEM/ingres/bin/ingprenv. If not, you'll need to restore that
> > file. I'm hoping we wont need that for this exercise - but we'll have to
> > wait and see.
>
> ok, my failure, I was root not ingres. Here is what ingprev said:
>
> II_GCN_PORT=
>

From this and what you've said before I think your ingres environment
variable file has been truncated. Check the file
/opt/CA/ingresii/ingres/files/symbol.tbl - does it contain anything.
Do you have a backup you could recover this file from?


> >
> > The .t00 files are your database! DONT DELETE THEM!
> >
> > Do an infodb cadbase and send the output. I suspect that you
> > have no backups. Which is something we'll need to consider.
>
> infodb says me:
>
> Thu Apr 7 11:28:33 2005 E_DM007F_ERROR_STARTING_SERVER Could not start the server due to an internal error.
> Thu Apr 7 11:28:33 2005 E_DM1051_JSP_NO_INSTALL The installation is not currently running. Run INGSTART then try again.
> Thu Apr 7 11:28:33 2005 E_DM1001_JSP_INIT An error occurred initializing the journal support program. Make sure program is
> installed and/or you are running with proper privilege.
>
> > See prior comment on a new disk and new log size. Lets get
> > the installation back up first. But seriously you will need to grab some
> > disk and quite frankly its hard to buy anything under 28G these days. I
> > suggest you get two and configure them as a mirror set. But that's
> > another story.
>
> Disk space is not the problem, the problem now is these small opt-partition. I can use this 2GB restore-partition and add it to opt and
> 12GB are free too, so I could create a partition with up to 18GB, if needed. When I installed this system, I didn't know that this backup
> software need so much space. I thought 4gig is a good size ...
>
> best regards
> Sven
>

Do you purge and/or prune the database regularly? I'm told that if you
don't do that then the database can grow very big - especially if
you're backing up lots of files.

Also it is possible to spread the database across different partitions
- called extending. This is possible during installation of BrightStor
- but also later using Ingres utilities. I won't go into the details
now but it may be something you should consider.

--
Paul Mason