Restrict IP address proc in Sybase

SQL Maybe useful to use to restrict users by ip address create group restrictedusergroup go create proc restrictuser as declare @ip char(15) select @ip = ipaddr from master..sysprocesses where spid = @@spid if @ip in (‘10.160.43.46′,’10.160.43.45′, and so on) begin select syb_quit() end go sp_modifylogin dbo_db,’dbo_db’,restrictuser go grant execute on …

cross platform dump and load in Sybase

Cross platform dump http://www.sybase.com/content/1033627/18XPDL_1253_WP.pdf after you run the code dump the database and copy to the location once you have done this you can then load the database. Sample of code to run USE master go EXEC sp_dboption ‘db’,’single user’,true go USE master go EXEC sp_dboption  ‘db’,’dbo use only’,true go …

Performance and Tuning in Sybase

MEMUSAGE: This is useful for validation your SQLserver memory configuration, dbcc memusage reports three pieces of information. The current allocation of memory within SQL server Up to the 20 largest tables and or index currently in datacache. Up to the 20 largest sored procs currently in procedure cache. Examble for …

Dev Usage Proc Sybase

This proc will help you check devusage in Sybase ase IF OBJECT_ID(‘dbo.sp_dba_devusage’) IS NOT NULL BEGIN     DROP PROCEDURE dbo.sp_dba_devusage     IF OBJECT_ID(‘dbo.sp_dba_devusage’) IS NOT NULL         PRINT ‘<<<>>>’     ELSE         PRINT ‘<<<>>>’ END go create proc sp_dba_devusage as set nocount on select distinct      name = d.name,      …

Database locking proc Sybase

This proc will help you find blocking on a Sybase database   IF OBJECT_ID(‘dbo.sp_dba_dblock’) IS NOT NULL BEGIN     DROP PROCEDURE dbo.sp_dba_dblock     IF OBJECT_ID(‘dbo.sp_dba_dblock’) IS NOT NULL         PRINT ‘<<<>>>’     ELSE         PRINT ‘<<<>>>’ END go create procedure sp_dba_dblock as declare @PRNTBUFFER varchar(150), @CURRENTDB …

Sybase Proc to help find db space

This proc will help you find db space in a Sybase server   IF OBJECT_ID(‘dbo.sp_dba_dbspace’) IS NOT NULL BEGIN     DROP PROCEDURE dbo.sp_dba_dbspace     IF OBJECT_ID(‘dbo.sp_dba_dbspace’) IS NOT NULL         PRINT ‘<<<>>>’     ELSE         PRINT ‘<<<>>>’ END go create procedure sp_dba_dbspace as set nocount on …

Sybase IPG Group White Paper

Sybase IPG Group White Paper Series :            Sybase IQ 12 Technical Series Index Selection Criteria Sybase IQ 12.5 Index Selection Criteria Richard Soundy                         Sybase IPG (Analytics) Group for EMEA                         November 2003 Abstract This document details the basic steps for the determination of the required indexes for a Sybase …

Sybase IQ as a Data Warehousing Database Solution

Sybase IQ as a Data Warehousing Database Solution   There are a number of points to look at when deciding whether to use Sybase IQ as a database platform.  It is specialised the target audience is inherently limited by feature set.   Some background – Sybase IQ is the Sybase …

Create a OCS client in sybase

This is an easy script to help you create a ocs client on an apps box. This will help you create a client on any server or host.   !#/bin/bash PROJ=OCS VERSION=OCS1251_EBF12655 cd /opt/sybase cp defaultpath.profile .profile cp defaultpath.kshrc .kshrc cp defaultpath.inputrc .inputrc cp defaultpath.vimrc .vimrc cp defaultpath.sqshrc .sqshrc cp …

quiesce rep server

to do this you will need to first suspend all the log transactions do this by isql -S server_rep -U repadmin -P password admin health go this well show false of quiese is not right next run suspend log transfer from all go then run admin quiesce_force_rsi go then run …