Hi,

I had a problem with a database today where various rows were changed.

I translated the transaction log, and see the following:

--CONNECT-1018-06813851771-DBA-2012-12-05 08:08 --BEGIN TRANSACTION-1018-06813851782 BEGIN TRANSACTION go --UPDATE-1018-06813851783 UPDATE DBA.iInv SET Precio=.84, Precio1=.84, Precio2=.84, Precio3=.84, Precio4=.84, Precio5=.84, timeStampCambio='2012-12-05 08:08:12.096' WHERE Bodega=124000100 AND Item=227 go --UPDATE-1018-06813851836 etc...

I imagine the the first line has the connection information. With "1018" being the connection number, and the other number 06813851771 some type of serial id.

Is it possible to know the connection information. In particular I'm interested in knowing the IP and the machine details for that connection.

Is it possible?

Thanks, Edgard

asked 05 Dec '12, 14:44

Edgard%20Riba's gravatar image

Edgard Riba
1111
accept rate: 0%


That information is not logged since it is not needed for recovery. You can enable auditing to cause some of that information to be logged but if auditing wasn't enabled, that information will not be present in the logs you are looking at. See http://dcx.sybase.com/index.html#1201/en/dbadmin/auditing-security.html*d5e84361

permanent link

answered 05 Dec '12, 14:55

John%20Smirnios's gravatar image

John Smirnios
8.7k377107
accept rate: 40%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×31

question asked: 05 Dec '12, 14:44

question was seen: 658 times

last updated: 05 Dec '12, 14:55