Hallo Agnes, please do your change to 1000 pages and after restart look at the parameter LOG_SEGMENT_SIZE.
(dbmcli -d ... -u ... param_getvalue LOG_SEGMENT_SIZE) The 1/3 logsize rule is only used if this parameter is 0. The logsegmentsize cannot be greater than 1/2 logsize and not smaller than 11 but in all other cases the parameters value should be taken as set. bye Uwe > -----Original Message----- > From: MICHEL, Agnes > Sent: Mittwoch, 22. Mai 2002 18:02 > To: [EMAIL PROTECTED] > Subject: parameter LOG_SEGMENT_SIZE to make automatic log backups more > oft en > > > Hello to everybody, > > To make some backup & restore tests on our SAPDB db, we need > to have several > automatic log backups produced (AutoLog is ON). > > Pb : our log area is 2 Gb , and if we let the default value > of the parameter > LOG_SEGMENT_SIZE, we have to make a lot of updates to have a > chance to see > one automatic log backup ! So we changed the value of > LOG_SEGMENT_SIZE to > 1000 pages + stop/start of the db, then we made several > updates, but the db > still performs an automatic log backup when the log area is > filled at 33 % > (about 85000 pages). > What's wrong ? > > Thanks for your help, > Agnes Michel > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
