XI and BASIS problem
Yesterday, I encountered a SYSFAIL in smq2 (queues). The error was 'SQL error in the database when accessing a table'. I contacted our basis guy and he increase the table space. After that, the queues were running again. But we asked ourselves, why did this happen? Will this error occur again after a few weeks? How come XI is taking up a lot of space since its only job is to act as a gateway. Why is it storing data? How can we prevent this kind of SYSFAIL from happening again?
Shabarish Vijayakumar replied
the data i guess is usually stores the information reg the message. So if you need to track back and and view the log or status of a old message these tables come to be of help.
I guess you can have the table contents cleared or archive XI messages on a time basis perhaps to ensure the issue doesnt come up again