SQL Anywhere database - to interpreting the Log file

Author

to interpreting the Log file

Gilberto Assis

2005-05-12, 8:23 pm

Hi every all,

I'd like to interpret a log file, for this I am use the
DBTRAN. Well, I receive the log translated, but don't know
who signify from numbers (0008359821, 0008359840,
0008359984, ...) like show below:

----BEGIN TRANSACTION-1030-0008359840
--BEGIN TRANSACTION
--UPDATE-1030-0008359984
--UPDATE FIRST usuario.CONTROLE
-- SET DATA_BASE='2005/apr/26 00:00:00.0'
-- WHERE DATA_BASE='2005/apr/19 00:00:00.0'
-- AND DATA_EVOLUCAO='2005/apr/01 00:00:00.0'
-- AND COD_RECIBO='000000'
-- AND DATA_IMPLANTACAO='19
97/jan/01 00:00:00.0'
-- AND STATUS_CONTABILIZACA
O='S'
--COMMIT-1030-C

someone can help me?
thanks and sorry for my poor english.

Gilberto

Reg Domaratzki $iAnywhere Solutions$

2005-05-12, 8:23 pm

Those numbers represent the log offset at which the operation took place.

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

<Gilberto Assis> wrote in message
news:4283c13c.734d.1681692777@sybase.com...
> Hi every all,
>
> I'd like to interpret a log file, for this I am use the
> DBTRAN. Well, I receive the log translated, but don't know
> who signify from numbers (0008359821, 0008359840,
> 0008359984, ...) like show below:
>
> ----BEGIN TRANSACTION-1030-0008359840
> --BEGIN TRANSACTION
> --UPDATE-1030-0008359984
> --UPDATE FIRST usuario.CONTROLE
> -- SET DATA_BASE='2005/apr/26 00:00:00.0'
> -- WHERE DATA_BASE='2005/apr/19 00:00:00.0'
> -- AND DATA_EVOLUCAO='2005/apr/01 00:00:00.0'
> -- AND COD_RECIBO='000000'
> -- AND DATA_IMPLANTACAO='19
97/jan/01 00:00:00.0'
> -- AND STATUS_CONTABILIZACA
O='S'
> --COMMIT-1030-C
>
> someone can help me?
> thanks and sorry for my poor english.
>
> Gilberto

Gilberto Assis

2005-05-13, 9:23 am

thanks to response...

I think which those numbers having some time relation, need
to know when the operation happened ...for example:

--CONNECT-1030-0008359821-cps_usuario-2005/apr/26 17:49
----BEGIN TRANSACTION-1030-0008359840
--BEGIN TRANSACTION
--UPDATE-1030-0008359984
--UPDATE FIRST cps.MPT_CONTROLE
-- SET DATA_BASE='2005/apr/26 00:00:00.0'
-- WHERE DATA_BASE='2005/apr/19 00:00:00.0'
-- AND DATA_EVOLUCAO='2005/apr/01 00:00:00.0'
-- AND COD_RECIBO='000000'
-- AND DATA_IMPLANTACAO='19
97/jan/01 00:00:00.0'
-- AND STATUS_CONTABILIZACA
O='S'
--COMMIT-1030-0008360029
--COMMIT WORK
--CONNECT-1002-0008360030-cps-2005/apr/26 17:54
----BEGIN TRANSACTION-1002-0008360041

In to code above, the operations happened in 5 minutes, how
to know accurately when "UPDATE-1030-0008359984" occured?
how to know which time her happened?

Gilberto Assis

> Those numbers represent the log offset at which the
> operation took place.
>
> --
> 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
>
> <Gilberto Assis> wrote in message
> news:4283c13c.734d.1681692777@sybase.com...
>
>

Gilberto Assis

2005-05-13, 9:23 am

thanks to response...

I think which those numbers having some time relation, need
to know when the operation happened ...for example:

--CONNECT-1030-0008359821-cps_usuario-2005/apr/26 17:49
----BEGIN TRANSACTION-1030-0008359840
--BEGIN TRANSACTION
--UPDATE-1030-0008359984
--UPDATE FIRST cps.MPT_CONTROLE
-- SET DATA_BASE='2005/apr/26 00:00:00.0'
-- WHERE DATA_BASE='2005/apr/19 00:00:00.0'
-- AND DATA_EVOLUCAO='2005/apr/01 00:00:00.0'
-- AND COD_RECIBO='000000'
-- AND DATA_IMPLANTACAO='19
97/jan/01 00:00:00.0'
-- AND STATUS_CONTABILIZACA
O='S'
--COMMIT-1030-0008360029
--COMMIT WORK
--CONNECT-1002-0008360030-cps-2005/apr/26 17:54
----BEGIN TRANSACTION-1002-0008360041

In to code above, the operations happened in 5 minutes, how
to know accurately when "UPDATE-1030-0008359984" occured?
how to know which time her happened?

Gilberto Assis

> Hi every all,
>
> I'd like to interpret a log file, for this I am use the
> DBTRAN. Well, I receive the log translated, but don't know
> who signify from numbers (0008359821, 0008359840,
> 0008359984, ...) like show below:
>
> ----BEGIN TRANSACTION-1030-0008359840
> --BEGIN TRANSACTION
> --UPDATE-1030-0008359984
> --UPDATE FIRST usuario.CONTROLE
> -- SET DATA_BASE='2005/apr/26 00:00:00.0'
> -- WHERE DATA_BASE='2005/apr/19 00:00:00.0'
> -- AND DATA_EVOLUCAO='2005/apr/01 00:00:00.0'
> -- AND COD_RECIBO='000000'
> -- AND DATA_IMPLANTACAO='19
97/jan/01 00:00:00.0'
> -- AND STATUS_CONTABILIZACA
O='S'
> --COMMIT-1030-C
>
> someone can help me?
> thanks and sorry for my poor english.
>
> Gilberto

Reg Domaratzki $iAnywhere Solutions$

2005-05-13, 9:23 am

The only operations in the log file with timestamps on them are CONNECT and
CHECKPOINT operations. You can't figure out what time any other operations
occurred, just the order in which they occurred.

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

<Gilberto Assis> wrote in message
news:4284b594.3add.1681692777@sybase.com...[color=darkred]
> thanks to response...
>
> I think which those numbers having some time relation, need
> to know when the operation happened ...for example:
>
> --CONNECT-1030-0008359821-cps_usuario-2005/apr/26 17:49
> ----BEGIN TRANSACTION-1030-0008359840
> --BEGIN TRANSACTION
> --UPDATE-1030-0008359984
> --UPDATE FIRST cps.MPT_CONTROLE
> -- SET DATA_BASE='2005/apr/26 00:00:00.0'
> -- WHERE DATA_BASE='2005/apr/19 00:00:00.0'
> -- AND DATA_EVOLUCAO='2005/apr/01 00:00:00.0'
> -- AND COD_RECIBO='000000'
> -- AND DATA_IMPLANTACAO='19
97/jan/01 00:00:00.0'
> -- AND STATUS_CONTABILIZACA
O='S'
> --COMMIT-1030-0008360029
> --COMMIT WORK
> --CONNECT-1002-0008360030-cps-2005/apr/26 17:54
> ----BEGIN TRANSACTION-1002-0008360041
>
> In to code above, the operations happened in 5 minutes, how
> to know accurately when "UPDATE-1030-0008359984" occured?
> how to know which time her happened?
>
> Gilberto Assis
>
>

Stephen Rice

2005-05-13, 11:23 am

While this won't get you the times from an existing log, turning on auditing
will provide timestamps for all of the audit records. These will give you
pretty exact timing for the actual statements

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions
------------ Please Post -------------
"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
wrote in message news:4284b8fd$1@foru
ms-1-dub...
> The only operations in the log file with timestamps on them are CONNECT
> and
> CHECKPOINT operations. You can't figure out what time any other
> operations
> occurred, just the order in which they occurred.
>
> --
> 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
>
> <Gilberto Assis> wrote in message
> news:4284b594.3add.1681692777@sybase.com...
>
>

Sponsored Links