SQL Anywhere Feedback - Stop dbmlsync.exe from reusing "AA", "BB".

Author

Stop dbmlsync.exe from reusing "AA", "BB".

Breck Carter [TeamSybase]

2005-07-16, 7:23 am

Please stop dbmlsync.exe from reusing the "xx" portion of the
"yymmddxx.LOG" file names when DELETE_OLD_LOGS = 'ON' is used in
conjunction with dbmlsync -x and multiple synchronizations are done
within a single day.

At best it is disconcerting, at worst it is confusing, to see "AA"
reappear as soon as it is deleted... please don't reuse "AA" until you
have to wrap from "ZZ".

Breck Easily Disconcerted

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Reg Domaratzki \(iAnywhere Solutions\)

2005-07-17, 8:23 pm

Have you considered using delete_old_logs = 'delay' ? Transaction log files
whose naming convention indicates that they were created on the same day
will not be deleted. That should guarantee that the file yymmddXX.log will
not be re-used.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:00ohd1pnnhapisp
a29fqpg384gmb5og04k@
4ax.com...
> Please stop dbmlsync.exe from reusing the "xx" portion of the
> "yymmddxx.LOG" file names when DELETE_OLD_LOGS = 'ON' is used in
> conjunction with dbmlsync -x and multiple synchronizations are done
> within a single day.
>
> At best it is disconcerting, at worst it is confusing, to see "AA"
> reappear as soon as it is deleted... please don't reuse "AA" until you
> have to wrap from "ZZ".
>
> Breck Easily Disconcerted
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com

Breck Carter [TeamSybase]

2005-07-18, 7:23 am

On 17 Jul 2005 13:09:53 -0700, "Reg Domaratzki \(iAnywhere
Solutions\)" <FirstName.LastName@ianywhere.com> wrote:

>Have you considered using delete_old_logs = 'delay' ? Transaction log files
>whose naming convention indicates that they were created on the same day
>will not be deleted. That should guarantee that the file yymmddXX.log will
>not be re-used.

Doh! of course... thanks! (it's like an NSAID for the ego :)

Breck

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Greg Fenton

2005-07-18, 9:23 am

Breck Carter [TeamSybase] wrote:
>
> it's like an NSAID for the ego
>

I had to Google that one....couldn't you have just said "ibuprofen" ? :-)

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Breck Carter [TeamSybase]

2005-07-18, 1:23 pm

On 18 Jul 2005 07:24:23 -0700, Greg Fenton
<greg. fenton_NOSPAM_@ianyw
here.com> wrote:

>Breck Carter [TeamSybase] wrote:
>
>I had to Google that one....couldn't you have just said "ibuprofen" ? :-)

Indeed... but I wanted to explicitly include the letters AI
(anti-inflammatory), as in "reduces swelling of the ego" :)

Breck

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Sponsored Links