The Sybase ASIQ North American Users' Group

IQ Stored Procedures

Procedures provided by Ronald M Watkins

• gziped tar file (March '03): iqprocs.tgz

  Note: the PS command is pre-configured for IQ 12.4.3, and will require the end-user to un-comment a line in a temp table to support IQ 12.5 servers. The line is marked in the source code.

  Provide 'help=1' as a parameter to these procedures for help.

Also...

• sp_iqspaceinfo

IQ tools provided by Mark D. Mumy

• Java monitor tool, java_mon.zip

Also...

• Schema and DDL utilities, utility_scripts.zip
• Idle connection disconnect script for:
  Version 12.4.3
  Version 12.5
  Version 12.6
  

  The "disconnect_idle_connections" event will disconnect any connections in Sybase IQ that have been truly idle in the server. An idle connection is considered one that is not executing a command or returning data. The default behavior is to terminate the connection after 10 minutes of inactivity. The README.txt file contained in the zip files have more details on the expected behavior.

Procedures provided by Yannick Sansonnet

• ap_table_indexsize.sql
• ap_tablesize.sql

Note: no warranties, implied or otherwise, are offered for these stored procedures. Use at your own risk.

Back to the IQUG page