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...
Hi Experts,
Due to a slowness issue we want to delete a cached plan(referring SAP note 2114568) for the 1st parallel process of a stored procedure (that gets executed as 30 parallel processes). Is there a way to backup an existing cached query plan...
repdef-and-sub-details.txtHi Experts,I have a stored procedure that has a table 'temp_display' and the sequence of operations that happens on it are "drop, get the data into it again from main table using select into(as the EOD changes data) and then...
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
Hi Mike,Please find the below to setup SSL for ASE 16.0.https://help.sap.com/docs/SAP_ASE/c06a453f9967403e975210b1b335765b/a947d4ebbc2b10148b4f9a768ad74302.html?version=16.0.2.3SAP Note : 1899365 Regards,Dilip Voora