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...
Hi Experts,With respect to "installmaster" script we would like to understand the actual need of getting it in 1-off. 1. Is there any necessity to run "installmaster" after applying 1-off/N-off that is received for a SP with PL? Our understanding is ...
Hi Experts,
After we materialize master database, we found that the DSI of the master of companion ASE going down due to DR_maint unable to connect the companion ASE. After I changed the DR_maint's password (same as the one specified while running ...
Hi Experts,
I configured HADR(Sync) in my test machines and I would like to get the below questions clarified from you.Details:
A) Cluster ID database : LE1B) Host 1: Test1.dba.com Primary dataserver : ASE1 (16.0 SP03 PL05 with 4K page size) Prim...
Answering to my own questions after discussing with SAP PS and testing,1. Table will not be locked compltely when there is an intent lock (Ex or Sh) on a table. Reason : In a way, an intent lock does not really lock anything. The mechanism is more...
Hi Mark, The status bit you are highlighting is next to lqid in the dump right? If it is correct, status bit for the transaction that I zapped (for scenario 2) is showing as 32769. ENTRY ver=1100 len=212 orig=102 lorig=0 oqid=00000000000021df000032b7...
Hi Rillic, From the error provided, there is no entry for the database/SID into which the backup/dump is going to be loaded. So first get the database/SID created and check it's existence from master..sysdatabases and then proceed with your activity....
Hi Tilman,Your reply confirmed our understanding and we cascade this to our fellow DBA which have different understanding on installmaster eexecution not recieved for 1-off/N-off. Thank you once again.Regards,Dilip Voora