Miscellaneous ASE/RepServer Tools
 
Some ASE/RepServer tools by various authors (for a list of ASE-related tools on external websites, go here):


 
Sybase Replication Server
All versions
Last updated: 04 June 2015
Some Replication Server-related scripts (sp_gen_alterdef.sql, sp_gen_cmpscript.sql, sp_gen_repdef.sql, sp_gen_repset.sql, sp_gen_repsub.sql, sp_gen_subcmp.sql) were available on the former Sybase CodeXchange website. Thierry Zumer saved a copy when CodeXchange went offline. Downloaded it here.
For comments or suggestions, please contact the respective authors, as indicated in the various files.


 
Sybase ASE
11.0 11.5 11.9 12.5 12.5.4 15.x
Last updated: 29 January 2012
Abhijit Jadhav wrote a Unix 'awk' script for DBAs to check database backup information from Backup Server log file. The script can be downloaded here.
For comments or suggestions, please contact the author directly.


 
Sybase ASE
11.0 11.5 11.9 12.0 12.5 15.x
Last updated: 29 January 2012
Manish Negandhi wrote a stored procedure to check if ASE logins are in compliant with the settings for (a) password expiration (b) minimum password length (3) max failed logins. Often the requirement is to report those logins which are not in compliance with above-mentioned attributes. This stored procedure which will list out all such logins and if desired, will modify the respective attribute.
The source code for the stored procedure can be downloaded here.
For comments or suggestions, please contact the author directly.


 
Sybase Replication Server
All versions
Last updated: 14 March 2010
Vishi R wrote a Perl script to display all patterns in a RepServer Domain, including reptable true yes/no, autocorrection and warnings if there is a mismatch between repdefs/subscriptions and setreptable.
The script can be downloaded here.
For comments or suggestions, please contact the author directly.


 
Sybase ASE
All versions
Last updated: 26 January 2008
Kazuo Otani wrote various stored procedures:
  • "sp_find_obj" finds an object that you forget the location. (ASE 12.0 or later)
  • "sp_helproxy" reports all proxy table names and its sources. (ASE 12.0 or later)
  • "sp_proc_trees" shows hierarchical structure of procedures/views. (All releases)
  • "sp_seq_numbers" is a flexible sequence number generator. (ASE 12.0 or later)
  • "sp_show_permission" shows 'grant' statements that are set on the object. (ASE 11.5 or later)
  • "str_extract" is a function to extract a part of string from delimiter-separated-values. (ASE 15.0.2 or later)
They are short and easy to create. See the header of each source code for detail.
The source code for the stored procedures can be downloaded here.
For comments or suggestions, please contact the author directly.


 
Sybase ASE
All versions
Last updated: 26 January 2008
César Buzzo wrote a stored procedure to obtain the selectivity of indexed columns (sp_show_ind_cols_select).
He also wrote a stored proc (sp_Index_Redundancy) that is similar to Ibrahim Dogan's sp__dupindex (see below) but also identifies indexes with identical leading columns but different trailing columns. The SQL source code for both stored procs can be downloaded here.
For comments or suggestions, please contact the author directly.


 
Sybase ASE
All versions
Last updated: 05 October 2004
Ibrahim Dogan wrote various stored procedures:
  • sp__dupindex identifies potentially redundant indexes (whose columns are already leading columns in a different index).
For comments or suggestions, please contact the author directly.


 
Sybase ASE
All versions
Last updated: 04 August 2004
Navneet Chola wrote a script for checking the ASE errorlog. It takes a different approach than my own tool; for example, it doesn't require an ASE login and doesn't write markers to the errorlog. The tool can be downloaded here.
For comments or suggestions, please contact the author directly.


 
Sybase ASE
All versions
Last updated: 05 April 2003
Mark Kusma wrote a handy stored procedure to list all indexes containing a column with a specific name. The code can be downloaded here.
For comments or suggestions, please contact the author directly.


 
Sybase ASE
11.0 11.5 11.9 12.0 12.5
Last updated: 11 January 2002
In ASE 12.0, the sybsyntax database and the corresponding stored proc sp_syntax, were officially removed from ASE. While these were reinstated in ASE 12.5, users of 12.0 cannot use sp_syntax anymore.
Fortunately, Raymond Mardle created a version of sybsyntax and sp_syntax for ASE 12.0, which you can download here (about 20 Kb; install with isql). Please contact Raymond Mardle directly if you have any suggestions or comments.


 
Sybase Replication Server
All versions
Last updated: 16 April 2000
Mark A. Parsons has an elegant solution for replicating information in the master database (like logins, passwords, etc.) in a warm standby. Download his presentation here (330 Kb)


 
 This document is located at www.sypron.nl/misctools.html