Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Need help with load on Gupta 6.1.2 Base.

67 views
Skip to first unread message

Andreas Meyer

unread,
Nov 25, 1997, 3:00:00 AM11/25/97
to

Ive to integrate a database A (80 MB) into a database B (300 MB).
But doing this with unload / load wasn't successful ! Ive used the
following commands with 16 Bit Centura WinTalk:

unload database
control SERVER/dbdat:sqlbase\unload\A\A.ucf
overwrite on server;

connect B;

load sql
control SERVER/dbdat:sqlbase\unload\A\A.lcf
on server
log SERVER/dbdat:sqlbase\unload\A\A.log;

(each segment specified in the load control file has 2MB)

The result of the unload command was perfect. But the load failed.
After about 40 minutes i've got the error 3926 which is not documented
but has perhaps something to do with log disk space. But i am sure
that my SERVER has enough free hard disk space (550 MB) and the
log filepath in the sql.ini points to my server (i saw the log files
there).

What can i do to accomplich my task ?

Andreas Meyer

Michael Vandine

unread,
Nov 26, 1997, 3:00:00 AM11/26/97
to

According to my error.sql file,

03926 LOG LSC Log disk space critically short

Reason: Transaction rolled back due to LOW LOG DISK SPACE

Remedy: CHECK LOG DISK SPACE IMMEDIATELY. Long running transactions
pin down disk log files that could otherwise be deleted.
SQLBase has determined that free log disk space is
critically low and has forced this transaction to roll
back since it is pinning log files that must be released
to preserve the integrity of the database. SQLBase will
be forced to shutdown in the near future if this action
does not successfully recover log disk space.

You're running out of log space (or the database system thinks you are).

This is sometimes a bogus message. If you're on the latest version
(6.1.2), make sure you apply PTF3 and then insert the following in your
server SQL.INI file in the server section:

disablelogspacecheck=1

This will get you by the current problem.
--
Mike Vandine
[TeamAssist]
Argyle Diamonds
mike.v...@nospam.argylediamonds.com.au
(Take out the 'nospam.' from the E-mail address to reply)


Andreas Meyer <a...@hackenberg.de> wrote in article
<347B37...@hackenberg.de>...

Andreas Meyer

unread,
Nov 26, 1997, 3:00:00 AM11/26/97
to

Thank you very much !
Andreas

Jerry O'Brien

unread,
Dec 13, 1997, 3:00:00 AM12/13/97
to

Hi,
Make sure you have a backup and set recovery off.

Jerry O'Brien

Andreas Meyer wrote in message <347B37...@hackenberg.de>...

0 new messages