Dear sirs, is there any tool to translate the messages being transferred between consolidated and remote databases? (In case of replication using SQL REMOTE technology). Thanks in advance

asked 24 Apr, 03:30

Sarkis's gravatar image

accept rate: 0%

AFAIK, you can not directly "read or translate" those messages (except when using method 3) but there are ways to get to know the message contents:

  1. Run DBREMOTE with option -v (verbose): That will list all SQL statements that are read and applied (or fail) by DBREMOTE based on the received messages. (Highly recommended to understand the work of SQL Remote...)

  2. Use DBTRAN -sr on the sending database to list those commands that will be sent (or have been sent) to the other databases. (You may need to know the according translog opffest ranges here.)

  3. Use DBREMOTE with compression option set to 0. AFAIK that will produce "readable" message files. Not recommended for production use IMHO.

permanent link

answered 24 Apr, 03:40

Volker%20Barth's gravatar image

Volker Barth
accept rate: 32%

edited 24 Apr, 03:42

What do you mean with method 3? I read the documentation for the available options for DBREMOTE and could not find any option for compression: Could you please write me an example for DBREMOTE with compression option?

(10 May, 04:22) Sarkis
Replies hidden

Here you are:

compression option [SQL Remote]

It's set like any other SQL Remote option. i.e. via

SET OPTION PUBLIC.compression = 0;

I'd highly recommend to test that in a test environment (as any other SQL Remote aspect!).

(10 May, 04:49) Volker Barth

Using -v -a -p -o & -c switches in combination will not apply the messages (-a), and will not purge them (-p), but will log the contents to the console log (-v -o).

Of course this will need to be ran on the machine which has the messages needing to be translated and connected (-c) to the database that would normally be receiving them. The messages and database files can be (safely) moved to another location together to be ran offline.

Since this will only translate the messages and will perform no other actions for the receive phase you should probably restrict this to a single pass (-b) of just the receive phase (-r) so I would add these 2 switches as well.

permanent link

answered 24 Apr, 10:44

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
accept rate: 31%

converted 03 May, 09:50

Reg%20Domaratzki's gravatar image

Reg Domaratzki

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 24 Apr, 03:30

question was seen: 66 times

last updated: 10 May, 04:52