Sybase ADDICT

Create a temporary user database is an easy thing to do. Associate group of users to a temporary database can help you to reduce system tables contentions and increase your application availibility in case of tempdb full situation.

First, make sure you have created all necessary devices you need to create the temporary database. Devices can be created on rawdevices or filesystems.

In this example, we will create a temporary database of 4Gb on device named “tempdb_stats”, then we will bind a user named “userstats” to it.

- Create the tempdb that will be used by the login:

USE master
go
create temporary database tempdb_stats on tempdb_stats = 4000
go
USE tempdb_stats
go

- Create the login that will use the tempdb

exec sp_addlogin 'userstats', 'xxxxxxxx', @defdb='master', @deflanguage='us_english'
go
exec sp_locklogin 'userstats', 'unlock'
go

- Let’s bind the login to the tempdb:

sp_tempdb 'bind', 'lg', 'userstats', 'DB', 'tempdb_stats'
go

That’s it !

In some situations, you might need to force EBF installation. In order to do that, you will have to setup INSTALL_ALL_PATCH variable.

On Unix do:

export INSTALL_ALL_PATCH=1

On Windows do:

set INSTALL_ALL_PATCH=1

Then you can start EBF installation (console mode here):

setup -console

You just have to run a simple query in isql to find all the reserved words for Adaptive Server Enterprise and Sybase SQL Server. To list all reserved words for Adaptive Server Enterprise, log in to isql and run this query:

1> select name from spt_values where type = "W"
2> go


The spt_values table is a look-up table in the master database that stores system values used by other server processes.