Sven,

Your "ingprenv" command is working fine. However, your big
problem is really that the file

$II_SYSTEM/files/symbol.dat

has been truncated. This file contains vital configuration data
and is updated when you stop/start Ingres.

Unfortunately, when you are in a disk-full scenario, this file can
get truncated and the contents lost. This bug seems unsolvable, as it
has existed in Ingres since at least 1991.

Recovering this file from a backup will probably be fine, as the
information that changes in this file is usually only the socket
number used for the listener.

Cheers,

Michael Leo Java, J2EE, BEA WebLogic,
Caribou Lake LLC Oracle, Open Source, Ingres,
mleo@cariboulake.com Real Enterprise Applications

At 1:47 PM +0200 4/7/05, Sven Geipel 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=
>
>>
>> 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
>
>_________________________________________________ _____________
>Verschicken Sie romantische, coole und witzige Bilder per SMS!
>Jetzt bei WEB.DE FreeMail: http://f.web.de/?mc=021193
>
>_______________________________________________
>Info-ingres mailing list
>Info-ingres@cariboulake.com
>http://mailman.cariboulake.com/mailm...py/info-ingres