As I know during a part of an upgrade process this is used to gain speed. May be an error prevented the reset. kind regards, Uwe
to enable or disable: dbmcli ... util_execute set log writer [on|off] in warm mode: sql_execute select * from db_state [...] 'Log writing';(null);'on' 'Log automatic overwrite';(null);'off' [...] >-----Original Message----- >From: Ilker Uyanik [mailto:[EMAIL PROTECTED] >Sent: Monday, April 26, 2004 3:09 AM >To: Hahn, Uwe; [EMAIL PROTECTED] >Subject: Re: -126,Databackup missing (Backuphistory lost) > > >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]
