Hello
We are currently migrating from Sybase 11 to Sybase 17. We use file replication with dbremote (SQL Remote, publications..).
We have managed to upgrade our Sybase 17. Now we are testing our replication but we are running into errors here.
Expor...
Lately our consolidated database generates a lot of 1kb files (~300 files per user).
When I translate the transaction log file, I only see commits. All statements like this:
--BEGIN TRANSACTION-1011-06217481851
BEGIN TRANSACTION
go
--COMMIT-1011-0621...
Hi,
I'm trying to find out how I can check which remotes are out of sync?
I know that sysremoteuser gives some data, but I don't know how to interpret this data.
On of there reason I want to know this is because my transactionlog files are not gettin...
I have upgrade our sql anywhere database from sybase11 to sybase17. For a week there were nog problems. The sync worked perfectly. And now we get the following error:
I. 2019-12-03 10:39:23. Scanning logs starting at offset 04932968435
I. 2019-12-...
When I open a new tab or window from a Interactive SQL window, it asks for which database and credentials. In version 11 it automatically connected to the same database from where the new window was requested.
How can I achieve this in version 17? ...
Is this what you are looking for?
When adding a new remote installation we execute the following scripts:
/* For adding a new remote site AT HQ a subscription for the user (remote site) needs to be created. */
EXECUTE IMMEDIATE ('GRANT CONNECT TO "' ...
Hello Reg
Thank you for the quick reply.
Query result again consolidated (we have many remote databases, 0777 is the one we have newly created / I am testing with now).
user_name,consolidate,type_name,address
'icatcentral','P','FILE','icatcentral'
'i...
yes. So those are just 'ping' messages?
Receiving -> applying -> unlink.
Other messages actualy contain the statements: Receiving -> applying -> {statements} -> unlink