Uwe, After carefully going thru the dbm.utl, I found out that something issued SET LOG WRITER OFF, because I know I didn't, may be you can give some idea whether this command could be issued automaticaly by the system, or a SAP tool..
At the end I issued SET LOG WRITER ON and SET LOG AUTO OVERWRITE OFF, took a complete backup and I could be able to autosave_on... The MAXDB documentation only shows you how to do this using DBM GUI but I couldn't find where this is explained in the dbmcli commands... I would like to thank you for your help and quick response... Best Regards, Ilker ----- Original Message ----- From: "Hahn, Uwe" <[EMAIL PROTECTED]> To: "'Ilker Uyanik'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, April 25, 2004 11:18 AM Subject: RE: -126,Databackup missing (Backuphistory lost) > Could you please send me the dbm.knl, dbm.utl and dbm.prt, > so that I can have a look at it directly ? > Thanks > Uwe > > -----Original Message----- > From: Ilker Uyanik [mailto:[EMAIL PROTECTED] > Sent: Sonntag, 25. April 2004 17:08 > To: Hahn, Uwe; [EMAIL PROTECTED] > Subject: Re: -126,Databackup missing (Backuphistory lost) > > > I checked the dbm.utl and none of them is mentioned. I was able to run > interactive log save before, I cannot do that either... > > So basically I cannot turn on auto log and I cannot interactively save the > logs. Whne I try to do that in addition the -126 message I also observe the > folowing message in knldiag.err: > 2004-04-24 13:24:07 86 ERR 26 Log Backup of Log not allowed. Devicestate is > HistoryLost. > > I do not have any inside knowledge, but there should be a table where this > flag is set and I have no idea where it is. It is clearly not docuemnted. > > We have another Livecache system with exact same settings and I do not have > this problem there... > > Regards, > > > > Ilker > > ----- Original Message ----- > From: "Hahn, Uwe" <[EMAIL PROTECTED]> > To: "'Ilker Uyanik'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Sunday, April 25, 2004 4:24 AM > Subject: RE: -126,Databackup missing (Backuphistory lost) > > > > I assume that you enabled AUTOMATIC LOG OVERWRITE or set LOG WRITER OFF. > > Please check this. It should be mentioned in dbm.utl. > > Disable automatic log overwrite and enable log writing. > > After that you have to do the complete data backup again. > > Then you should be able to backup log or enable the autosave_log. > > Kind regards, > > UWe > > > > -----Original Message----- > > From: Ilker Uyanik [mailto:[EMAIL PROTECTED] > > Sent: Sonntag, 25. April 2004 02:39 > > To: [EMAIL PROTECTED] > > Subject: -126,Databackup missing (Backuphistory lost) > > > > > > Clear DayMaxDB documentation clearly says this message means that there is > no > > complete data backup to enable to autosave, but even after creating a > > complete data backup I do get the same message. > > > > So I cannot turn autosave on!!! The system info is : > > SERVERDB: DLC > > The database state is ONLINE > > Kernel Version 'Kernel 7.4.3 Build 031-123-063-122' > > RTE Version 'X64/AIX 7.4.3 Build 031-123-063-122' > > > > The following screen info shows that situation: > > vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv > > degu1ds011:dlcadm> dbmcli -d DLC -u control,control -uUTL > > dbmcli on DLC>backup_start DUMMYDATA DATA > > OK > > Returncode 0 > > Date 20040424 > > Time 00140850 > > Server degu1ds011 > > Database DLC > > Kernel Version Kernel 7.4.3 Build 031-123-063-122 > > Pages Transferred 9520 > > Pages Left 0 > > Volumes 1 > > Medianame DUMMYDATA > > Location /DLC/backup/DUMMYDATA > > Errortext > > Label DAT_00030 > > Is Consistent true > > First LOG Page 23454 > > Last LOG Page > > DB Stamp 1 Date 20040424 > > DB Stamp 1 Time 00140723 > > DB Stamp 2 Date > > DB Stamp 2 Time > > Page Count 9484 > > Devices Used 1 > > Database ID degu1ds011:DLC_20031008_150143 > > Max Used Data Page 0 > > > > --- > > dbmcli on DLC>autolog_on autosave > > ERR > > -24988,ERR_SQL: sql error > > -126,Databackup missing (Backuphistory lost) > > > > --- > > dbmcli on DLC> > > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > > > Best Regards, > > > > Ilker > > > > > > > > -- > > MaxDB Discussion Mailing List > > For list archives: http://lists.mysql.com/maxdb > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
