Hello Community,
I have a SAP BW Sysem which is running on Oracle 11.2.0.4. This system contains the SM/OPTSTATS data since 2014. These were not investigated earlier and the size of SYSAUX grown to 2.5 TB.
So we have started working on cleaning o...
Hello,OS - AIX 7.1DB : Db2 9.7 FP6We are upgrading the system to EHP6 SPS14 and currently stuck on CURRENTPHASE MAIN_SHDIMP/SUBMOD_SHD2_RUN/RUN_RSAIMMERGE_UPG_SHDBatch job RUN_RSAIMMERGE_UPG_SHD terminated . There is no runtime error. Memory utiliza...
Hello,I am upgrading EHP6 on a ERP 6.0 System. OS : AIX 71.DB : DB2 9.7Current Kernel : 720 Patch 700Target Stack 721 Patch 400 on xmlI am stuck with this error message. It is asking for TP 721 38018.97.According to note 211077 i have downloaded and ...
Hello Guys,I am trying to rename a table in db2 which is not part of any schema. Unfortunately i am not able to it. I tried everything but it is not working. What i am doing wrong here ?My DB2 version is 9.7db2 => rename table QCM8/B28/XT6D64T to /B2...
Hi,I am working on the Script to shut down and start up SAP application through Batch file on Windows. I am succesfully able to execute my script. But my problem is i have 2 Node. On Node A Central instance is running and on Node B Application server...
Just for the information to everyone, I have received a response from Oracle support and they said there is no other way to achieve what I am trying to achieve here as all the objects can't be moved from SYSAUX table space.Regards,Subhash
Hi Reagan,Thanks for the response. I have moved only OPTSTAT related table,index, & index partition from SYSAUX to SYSAUX_TEMP, which takes 99% of space. But Database does not allow to shrink the data file because of 1% of objects are still there. So...
Hi Reagan,Thanks for the responding to my question. Yes, after performing the deletes and reorg I moved those SM/OPTSTAT related table and Indexes to the temporary table space as per the note you listed.We have tried everything, Space has been releas...
Hi Saravana,This note has the information about this error2551097 - Error 'tnsnamesOraTemplate must point to an existing file' with SWPMRegards,Subhash
Hello,As per the below notes it seems feasible to get the EWA reports for Hana System on Solution Manager 7.1. There are certain Patch which is required for this on Solution Manager so if it is already there on your system you can give it a try.In So...
