• End of Life Notice, Sybase News | 26.09.2008 No Comments
    This is an External Correction to End of Life Notice for PowerBuilder 10.5.x See more here

    Tags:

  • End of Life Notice, Sybase News | 11.09.2008 No Comments
    This is an External End of Life Notice for PowerBuilder Version 10.5.X See more here

    Tags:

  • Adaptive Server Enterprise, HowTo | 11.09.2008 No Comments

    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 !

    Tags: , , ,

  • Tips & Tricks | 11.09.2008 No Comments

    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

    Tags: , , ,

  • Adaptive Server Enterprise, Tips & Tricks | 06.09.2008 No Comments

    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.

    Tags: , ,