by Jason L Froebe on June 17, 2013, no comments
Huge page support was disabled with SA CR 728597 due to RH bug. CR 728597: This problem is related to a possible bug in the transparent huge pages (THP) feature introduced in these operating system versions. RedHat bug 891857 has been created to track this issue. There is a huge difference between a RedHat specific bug, [...]
by Jason L Froebe on June 12, 2013, no comments
SAP/Sybase’s bold move of an Oracle Enterprise Manager clone, aka, Sybase Control Center (SCC) has been, well, not so good in the sense of being usable. It is currently undergoing a complete rewrite so until then, if you want to use Sybase Central in lieu of SCC, you will need to download Sybase IQ 15.2. [...]
by Jason L Froebe on June 5, 2013, one comment
I wrote this simple method to backup a database using a stored procedure. This allows for a user to restore a database with no knowledge of the dump/load commands. Related to Sybase ASE: A simple way to let a user restore a database using a stored procedure use sybsystemprocs go if exists (select 1 from [...]
by Jason L Froebe on June 5, 2013, one comment
I wrote this simple method to restore a database using a stored procedure. This allows for a user to restore a database with no knowledge of the dump/load commands. Related: Sybase ASE: A simple way to let users restore a database using a stored procedure use sybsystemprocs go if exists (select 1 from sybsystemprocs..sysobjects where [...]
by Jason L Froebe on April 23, 2013, no comments
I needed to copy the permissions from one database to another but the sp__helprotect stored procedure in Ed Barlow’s Extended System Stored Procedure Library for Sybase and Sql Server wasn’t producing output with “GRANT” and “REVOKE”. It also had problems with DBCC privileges. Here you go: sp__helprotect.sql /* Procedure copyright(c) 1995 by Edward M Barlow [...]