Hi Experts,Can anyone help me in understanding the exact internal behaviour of 'dump marker' and 'resync marker' with respect to MSA database level replication? Questions:1. How the Replication Server will come to know about the transactions that hap...
Hi Experts,I am noticing that the license heartbeat is not validating and reflecting the details of the license key even after 2 hours. Scenario:1. Installed an ASE (16.0 SP03 PL08) Enterprise Edition(EE), Server License (SR) on a host/instance creat...
Hi Experts, We came to know that the future release of ASE (SDK) and SRS i.e; 16.1 won't be supported on Solaris (SPARC servers) and HP-Unix from the SAP Note - 3307676 (attached). Does anyone know this is official and 100% confirmed? If yes what is ...
Hi Experts,I would like to seek some clarification about lock type "intent" and it's actual behaviour. Read the manuals available online to understand it but when I am trying to relate it with respect to other process, I feel I am missing something. ...
Hi Experts,Details :PDS.PDB : ASE1.D30RDS.RDB:ASE2.D30SRS : ASE_RSI tried zapping a transaction from the outbound queue of ASE2.D30 in two scenarios by using sysadmin sqm_zap_tran and they were successful with a message "The number of zapped/unzapped...
Yes, it goes individually and after restoring a fully encrypted database the same encryption key must be used. Please see the documentation below.Encrypting an existing database in ASE.
Hi,Please check the below and see which one is feasible to you in your case.1.Using MDA tables select * from monProcessSQLText select * from monSysSQLText2. You can enable auditing to capture SQL text by turning it on to for each login/object yo...
Hi Tony,Thanks for your comment. Can you please clarify, in MSA under the approach of just dropping the subscription and defining it with 'dump marker' how/and during which point 'enable replication marker' will be sent to the PDB's transaction log? ...
Hi Tony,My whole intention behind mentioning/specifying the work 'resync' is to tell that synchronizing the out of synchronized 'RDB' but not the method to use the option 'resync marker' in RepAgent and DSI to synchronize.1. In WSB whenever we want t...