As part of an SAP IQ database analysis, the system should determine information that is available only in a restricted manner using the standard functions.
Last update: November 12, 2017
Reason and Prerequisites
As part of SAP services such as
- SAP Performance Optimization - Sybase IQ
- SAP System Administration - Sybase IQ
and to analyze complex problems, the system must determine database information that is available only in a restricted manner using the normal functions via telnet or Interactive SQL.
An archive that contains a collection of the important SQL statements is attached.
Caution: Some of the scripts perform queries on IQ storeproc;
No documentation is available. We take no responsibility for the correctness of the scripts and we will not provide any support for these.
However, you can discuss more details and usage options as part of the SAP services described above.
Scripts were created and tested on IQ16 version.
SQL Statements are attached to below link: