Skip to end of metadata
Go to start of metadata

Symptom

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.

 

Solution

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:

DBISQL sql stement script collection