This command for Linux/Unix as well as Windows. Make sure that the network communication between SAP Instance host able to connect to DB. On the other hand you also need to check your network settings. ( As optional for more detailed log you can use R3trans -vd this give more detailed description of the steps along with relevant SAP notes ) In this trans.log steps for during connection will be listed, also with steps that doesn’t work well at the time of connection. If you get this error message, you need to check trans.log from the location where you issue R3trans -d command. If you get put ” R3trans finished (0000)”, this return code shows that the database is available and client connectivity is possible.īut in here we are discussing about possible error. This command checks whether connection to database is possible or not. In here switch user to adm user on SAP Instance host and issue ” R3trans -d “. using sapcpe process, which is part of SAP startup procedureĪfter this step, check how the problem can be investigated further.Ī first check you can run R3trans tool. Since DB2 version 9.1 for LUW, this software is located in global directory of your SAP system.įrom this location files needed by SAP system are copied at the system start to executables folder of the SAP systems.Įg: /usr/sap///exe. In here you need to check client software that enables SAP work process to establish connection to database. Here you can see the status of DB as ACTIVEĪs DB is active but still cannot accessed by SAP instance so need to check DB client software, this could be one of the reason.Ĭhecking client software and the connections between client SW and server side of DB.įor further steps getting to root cause of the issue you need to take closer look at the architecture Operating system running at database server= xxxxxxįirst database connect timestamp = 07:35:34.818230 In here you can check this by logging on to database host as user db2ĭb2 52> db2 get snapshot for database on ĭatabase path = /db2//db2/NODE0000/SQL00001/M EMBER0000/ These errors gives impression that DB is not up and running, when checked further DB is running fine. You will see error message like ” Database is not available via R3trans – Database must be started first “ I would like to present couple of scenarios regards to connections from SAP system to the database isn’t possible anymore. This issue can occur because of several reasons. SAP instance ( ABAP only ) connects to database using client software, when you work with distributed environments this issue could occur and SAP instance wont be able to connect to DB.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |