Various Technical documents on Sybase, MSSQL, Unix and various other subject areas.
Sybase
- Improve RepServer performance
-- Various parameters that can improve the performance of the Replication server rs_configure memory_limit, '200' -- dsi_sqt_cache_size alter connection to DCOCCDWP.defacto set dsi_sqt_max_cache_size to '62914560' go suspend connection to DCOC...
- Sybase ASE upgrade process
1.      First you need to create a new directory on Unix for the installation, e.g /progs/fps/sybase15, and copy the installation tar file to the unix machine, and uncompress and untar it. If there is no room any other place on the machine just ...
- Upgrading Rep server to REP15.0.2
Upgrade the RSSD database, start with the ID server. Install the new software for replication server version 15 on your system. Put it in a new directory e.g /progs/torigodb/syb_rs15. After gunzipping and untarring the rep server tar...
- Installing Heterogeneous Replication
To perform any heterogeneous replication, replication to and from two different datasources e.g Sybase to Oracle or DB2 to Oracle, you need to use Direct Connect or as it’s now being called Enterprise Connect Data Access. The below example is how ...
- How to add/update a table for replication
How to add/update a table for replication -Â Â Â Â Â Â Â Â Â First you need to create two scripts one to drop the existing subscription and replication definition and one to create the new table, replication definition and subscription. -Â Â...
- Installing RepServer 15
Installing RepServer 15 -         Untar the repserver installation files into a seperate directory and install the binaries etc by running setup –console. Answer no to email alerts and don't enter license information. - Â...
- Installing a Sybase ASE15 Server
The following points apply for a new installation or an upgrade to an existing server. With an upgrade just create the new filesystem side by side the existing installation and migrate over the logins, config settings, user databases etc. In an upgrade...
- How to drop a database when drop database fails
How to Drop a Database When drop database Fails Follow the steps in this section to drop a database when drop database fails. Do not use these steps unless directed to do so by this book, or unless there is no critical data in the database. 1.Log...
- How to move the master database to a new device
This error occurs when you try to extend the master database onto a device other than the master device. It is recommended that you keep user objects out of the master database. If you keep user databases off the master device, you allow space in ca...
- How to perform a load froma remote backup server
How to perform a load from a remote backup server A step by step guide: In this guide there are assumed to be two servers TROPHY_1103 and TRIDENT_1103. 1.                 Create a backup server for TROPHY_1103 cal...
- How to drop a corrupt table
1. sp_configure "allow updates", 1 go or reconfigure with override ( if System X) go 2. Use the database; get its dbid [select db_id()] and write it down for reference. 3. select id from sysobjects where name = ...
- Database status values in sysdatabases
Status control bits in the sysdatabases table Decimal                      Hex                            Status 4                                 0x04  Â...
- Using set showplan
This section explains how to use and interpret the showplan command to better understand and utilize the SQL Server query optimizer. When you send a SQL statement to the Sybase SQL Server, the request first goes to a cost-based query optimizer...
- Structure of databases as regards loading
INTRODUCTION The layout of Sybase SQL and ASE Server databases cannot be easily altered. A database, once created and altered, carries the logical layout of data and log segments for the duration of its life.  A major re-rganizatio...
- A guide to Replication server in plain English
Introduction This guide will hopefully cut to the chase and show how you can set up a simple replication system consisting of 1 dataserver, 2 databases (one replicating one receiving) and 2 replication servers, one for each database. Inst...
- DR for a Replication Server
Restoring a Primary Database ________________________________________________________________________ Phase I: Clean up the old system 1) Log on to your primary Replication Server and suspend the DSI connection to the primary database. ...
- How much Procedure cache
To caculate how much procedure cache you need, there’s a set of calculations which can be performed; The upper size = (Max number of concurrent users) * (Size of the largest plan) * 1.25 The lower size =(Total number of procedures) * (a...
- Common Repserver commands
a quick guide to some of the more common commands you’ll need; Create connection create connection to phoebe.sundry set error class rs_sqlserver_error_class set function string class rs_function_string_class set username su...
- Duplicate row removal from a table
The way to do this is to create a copy of the table using In this example I will assume I have a table called apple in database plum, and the column you want to make unique is called fruit select * into tempdb..apple from plum..apple ...
- Setting up a Historical server recording
Setting up a historical server recording As a rough guide just to see how it all works after you have the monitor server and historical server running execute the following on the historical server (log in using isql); Example Suppose ...
MSSQL
- Performance Tuning MSSQL
MSSQL has many excellent tools which can be used for discovering performance bottlenecks. Sp_monitor and dbcc perfmon To get a snapshot of what the SQL Server is doing then these commands are very usefull. Run sp_mo...