on 2012 Sep 22 9:47 PM
Dears,
I have working on SAP ERP 6 EHP5 NW 7.02 on Sybase, and get the following error" DB error: SQL error 1105 occurred "also when try to open TCode: dbacockpit to extend the table space, the SAP GUI terminated and show the following error also <SID>: SAP System Message: Work process restated; session terminated.
so please advice how I can solve this issue, thanks in advance.
Request clarification before answering.
Hi,
In order to avoid these kind of scenarios, we have implemented seperate tempdb for sapsa user which will allow us login using isql when we face this kind of full situations.
, what is the output of the this statement.
sp_helpsegment logsegment
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks for your information
the output of sp_helpsegment logssegment is as the following
| segment | name | |
| status |
---------------------------- --------------------------------------
------------------------
| 2 | logsegment | ||
| 0 | |||
| device | size |
------------------------ ----------------------------
| master | 248.0MB |
free_pages
-----------
| 13883 |
Objects on segment 'logsegment':
| table_name | ||
| index_name | indid | |
| partition_name |
----------------------------------------
---------------------------------------- ------------------
--------------------------------------------------------
| syslogs | ||
| syslogs | 0 | |
| syslogs_8 |
Objects currently bound to segment 'logsegment':
| table_name | ||
| index_name | indid |
----------------------------------------
---------------------------------------- ------------------
| syslogs | ||
| syslogs | 0 |
| total_size | total_pages | free_pages | used_pages |
reserved_pages
----------------- --------------- --------------- ---------------
---------------
| 248.0MB | 15872 | 13883 | 68 | |
| 0 |
(return status = 0)
so what you see?
| User | Count |
|---|---|
| 13 | |
| 8 | |
| 6 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.