Scripts infrastructure for IQ

[Former Member]

Hi All,

We are trying to build the scripting infrastructure for SAP IQ.

We wanted to know whats a good starting point.

scanning the IQ message file

Check the space usage in database

dbcc check.

What other points should we consider?

[Former Member · Accepted solution]

1.  you will want to scan the servername.iqmsg, $SYBASE/IQ-*/logfiles/ stderr and stdout files.  Remember that IQ sits on top of SQL Anywhere.

2.  sp_iqdbspace for dbspace level

3.  sp_iqcheckdb

4.  # of connections in use, # of active connections

5.  backups (successful & unsucessful)

Others as well but are largely dependent on the application.

[Former Member · Accepted solution]

Hi Jason,

Thanks so much for the response.

We have IQ primarily for SAP BW NLS application. Can you please throw some light on the same as well please.

[javier_barthe]

Hi,

When you talk about "scripting infrastructure" you mean database checks / health state?

Thanks.
Javier.

[Former Member]

Whatever we do like for other databases.