IQ-Multiplex Feature Wish-List
 |
Direct comments, suggestions, additions, etc. to Jeff Sexton, jsexton@odshp.com.com Links
|
|
Many ideas have been discussed among IQ-M users for future directions and feature developments for Sybase IQ-Multiplex. This page serves as a place to collect these ideas for the user group. Sybase listens to our ideas so if your idea isn't represented here, email me and I'll add it, jsexton@odshp.com.com
VLDB Support
- Database operation with some tables off-line.
Additional Data Type
- A large binary data type, similar to the text data type.
Query/SQL Enhancements
- Allow the use of position numbers in a "group by" clause, similar to the "order by" syntax, for example, "select county, state, count(*) from geographic group by 1,2".
Tools
- Continue support for isql, UNIX command line access is important for many users.
- Cut and paste capabilities in the interactive SQL tool.
- A simple Windows(tm) tool allowing developers to modify stored procedures.
- Allow Sybase Central to output to a file (one stop shopping: I'm already there looking, let me export quickly from there).
- Graphical P&T tool.
- Better ODBC support from additional third parties (dbArtisan, RapidSQL , Ambo and Teleran statistics products, cognos, etc.).
- Get PowerDesigner Warehouse Architect up to speed for IQ12.
Data Load Improvements
- Option to continue loads after an error, write out an error log for later review.
- System table level logging of load commands.
- A load command option that would allow us to turn HG and HNG indexing on/off so we are not wasting time indexing if we know we are going to load into the table and index again.
Database Backup Enhancements
- Support for Veritas.
- Support for enterprise storage systems (HDS/EMC for Shadow Copy / TimeFinder copies).
- Partitioned backups (by table, other).
Multiplex
- Allow DDL changes in multiplex mode.
Security and Administrative Enhancements
- Password aging.
- link (easily) connection IDs to a user's SQL (to handle help desk calls better by seeing quickly what they launched).
- More information from sa_conn_info such as the CPU usage per session.
- Sybase Central integration of support for IQ-M and ASE (having two versions is a pain).
- Add the ability to rename IQ main space or IQ Temp spaces.
- Simpler monitoring.
- Improve documentation on the benefits of more memory and CPU power for various platforms.
- More documentation on SQL coding for adding logins, checking for user objects (i.e. select name from sysobjects where type='P'). Many administrators need non-GUI access to the server.
- Placement of objects to avoid having to rebuild the database when disks are mispartitioned.
- Use IQ UNIQUE when adding a column.
- Ability to kill user connections at any time. Even if the user has closed their application and the query is still running.
- Add a utility which quickly shows you what servers are up and running with some status information. One IQ-M admin mentioned that he always run stop_asiq to see what servers are up.
- Add an sp_locklogin/sp_unlocklogin feature, as ASE has.
Performance Tuning
- Provide a way to simulate memory buffer and other settings to see which combinations work best (i.e. instead of change, restart, try, monitor, change again, reboot again, and so on).
- Memory allocation limits with HP/UX.
- Clarification of IQ memory parameters.
- The ability to track disk accesses by device.
Linux Support
The Most Popular Requests
These have been mentioned by a number of user group members on the mailing list:
- Continued support for isql
- Backups partitioned by table
- Data loads that can continue after an error, report the errors and log bad records to a file, instead of halting.
The last item, regarding data loads is a very popular one. Also, general monitoring and server management is also an area with a number of requests.
Again, if you have an IQ-M feature or ideas that you'd like Sybase to consider, email me and I'll add it to our list, jsexton@odshp.com.com