SAP Sybase ASE: Unable to start ASE when getting “No unlocked logins with permission ‘…’ were found”? SOLVED

by Jason L Froebe on March 14, 2014, no comments

Have you received the error “No unlocked logins with permission ‘…’ were found” when attempting to start ASE? 00:0002:00000:00001:2014/03/14 08:51:04.87 server Database ‘master’ is now online. server The transaction log in the database ‘master’ will use I/O size of 2 Kb. server No unlocked logins with permission ’200′ were found. kernel ueshutdown: exiting kernel Main […]

Share Button

SAP Sybase ASE 15.7: Unquiesce / quiesce not working

by Jason L Froebe on March 5, 2014, no comments

Typically there is a set of systems that are flashed from one system to another. The basic operation is: quiesce the databases in the source Sybase ASE instance, make a copy of the disk volume groups at the SAN level, move that volume group copy to the destination system, vary on the devices, start Sybase […]

Share Button

Ed Barlow Stored Procedures: sp__monobj Updated with formatting for SAP Sybase ASE 15 and higher

by Jason L Froebe on November 20, 2013, no comments

Ed Barlow created the sp__monobj uses a heuristic algorithm to find which objects are most busy as part of the excellent Extended Stored Procedures by Ed Barlow (AKA the Ed Barlow Stored Procedures). I’ve cleaned up the format output Differences: diff sp__monobj.old sp__monobj.15 17a18,26 > ————————————————————————————————– > — Vers| Date | Who | DA | […]

Share Button

Ed Barlow Stored Procedures: sp__monrunning updated with formatting for SAP Sybase ASE 15 and higher

by Jason L Froebe on November 20, 2013, no comments

Mich Talebzadeh created the sp__monrunning stored procedure for displaying the procedures that are running for more than 100 ms as part of the excellent Extended Stored Procedures by Ed Barlow (AKA the Ed Barlow Stored Procedures). I’ve cleaned up the format output and added the dont_format option: $ diff sp__monrunning.old sp__monrunning.15 9c9,10 < create procedure […]

Share Button

Ed Barlow Stored Procedures: sp__monunusedindex updated with formatting, including owner and all indexes for SAP Sybase ASE 15 and higher

by Jason L Froebe on November 20, 2013, no comments

Ed Barlow created the sp__monunusedindex stored procedure for displaying the indexes that have not been used since server start in Sybase ASE as part of the excellent Extended Stored Procedures by Ed Barlow (AKA the Ed Barlow Stored Procedures). I’ve updated the stored procedure to include the table owner and all the indexes & index […]

Share Button
Facebook login by WP-FB-AutoConnect