SQL Anywhere database - dbunload produces olg, olh, oli files

Author

dbunload produces olg, olh, oli files

David

2005-04-27, 1:23 pm

I use a stand-alone Sybase 9.0.1.1943 database. When I call
dbunload -ar, on some production systems I see that .olg,
olh, .oli are created from subsequent executions of
dbunload. Why is this? I do not use replication.

Thanks,
David

Reg Domaratzki \(iAnywhere Solutions\)

2005-04-27, 8:24 pm

dbunload thinks that your database is involved in synchronization or
replication. It's determined this because one or more of the following are
true :

1) "SELECT CURRENT PUBLISHER FROM DUMMY" returned a non-NULL value.
2) "SELECT SYNC_ID FROM SYS.SYSSYNC WHERE PUBLICATION_ID IS NOT NULL"
returned at least one row.
3) "SELECT db_property('LTMTrun
c')" returned a non-NULL value.

--
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

<David> wrote in message news:426fdbe7.3be3.1681692777@sybase.com...
> I use a stand-alone Sybase 9.0.1.1943 database. When I call
> dbunload -ar, on some production systems I see that .olg,
> olh, .oli are created from subsequent executions of
> dbunload. Why is this? I do not use replication.
>
> Thanks,
> David

David

2005-04-27, 8:24 pm

Thanks for the help. Next question, then.

#3 returned 18446744073709551615
. Why would the LTMTrunc be
set if there is no replication enabled? How do I correct
this?

Thanks,
David

> dbunload thinks that your database is involved in
> synchronization or replication. It's determined this
> because one or more of the following are true :
>
> 1) "SELECT CURRENT PUBLISHER FROM DUMMY" returned a
> non-NULL value. 2) "SELECT SYNC_ID FROM SYS.SYSSYNC WHERE
> PUBLICATION_ID IS NOT NULL" returned at least one row.
> 3) "SELECT db_property('LTMTrun
c')" returned a non-NULL
> value.
>
> --
> 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
>
> <David> wrote in message
> dbunload. Why is this? I do not use replication. >
>
>

Reg Domaratzki \(iAnywhere Solutions\)

2005-04-27, 8:24 pm

My mistake, 18446744073709551615
(that's 2^64 - 1) should be OK. Point
three should have read

3) "SELECT db_property('LTMTrun
c')" returned a non-NULL value not equal to
zero or 2^64-1.

So are none of the three points are true then, but you're still seeing logs
being archived? What is your dbunload command line?

--
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

<David> wrote in message news:426fe89c.7544.1681692777@sybase.com...[color=darkred]
> Thanks for the help. Next question, then.
>
> #3 returned 18446744073709551615
. Why would the LTMTrunc be
> set if there is no replication enabled? How do I correct
> this?
>
> Thanks,
> David
>
>
>

David

2005-04-28, 9:23 am

dbunload.exe -c
" dbf=C:\Ship_nt\datab
ase\Shipnet. db;uid=dba;pwd=*****
;" -ar
-j 5 -v -o C:\Ship_nt\database\
ShipnetUnloadLog.txt

> My mistake, 18446744073709551615
(that's 2^64 - 1) should
> be OK. Point three should have read
>
> 3) "SELECT db_property('LTMTrun
c')" returned a non-NULL
> value not equal to zero or 2^64-1.
>
> So are none of the three points are true then, but you're
> still seeing logs being archived? What is your dbunload
> command line?
>
> --
> 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
>
> <David> wrote in message
> the help. Next question, then. >
>
>

Reg Domaratzki \(iAnywhere Solutions\)

2005-04-28, 9:23 am

David, can you send me the database? You should be able to figure out my
e-mail address from the reply-to address on my newsgroup posts.

--
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

<David> wrote in message news:4270e35d.292.1681692777@sybase.com...[color=darkred]
> dbunload.exe -c
> " dbf=C:\Ship_nt\datab
ase\Shipnet. db;uid=dba;pwd=*****
;" -ar
> -j 5 -v -o C:\Ship_nt\database\
ShipnetUnloadLog.txt
>
>

Sponsored Links