Symptom
- Temporary Tablespace is growing to full. Temporary tablespaces are based on SMS infrastructure, they cannot be extended using a new stripe set.
Therefore, once one of the original storage paths is exhausted, no more space will be available to the temporary tablespace for future temporary objects.
To fix this, creating SAP temporary group SAPTMPGRP which failed with the below error.
========================================
CREATE STOGROUP SAPTMPGRP ON
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "END-OF-STATEMENT" was found following "TOGROUP
SAPTMPGRP ON". Expected tokens may include: "<storage_path_or_drive_list>".
SQLSTATE=42601 - Installation of gateway system failed with the above error.
Read more...
Environment
- SAP on IBM Db2 for Linux, UNIX, and Windows
- Database is using automatic storage
- SAP NETWEAVER 7.4 / 740
- SAP ERP 6.0
Product
SAP NetWeaver 7.4
Keywords
createStoGroupSAPTMPGRP, storage paths, tablespace, saptmp, storage group , KBA , sapinst , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.