Updates from sapsybdba Toggle Comment Threads | Keyboard Shortcuts

  • sapsybdba 12:46 pm on December 22, 2015 Permalink | Reply  

    Connecting through isql in Sybase ASE 

    Hi All,

    Today I am going to discuss the ways how you can connect through isql client to Sybase ASE database.

    1. Using GUI (dbisql)
    2. isql client

    When you install the Sybase ASE database on your machine, it will install almost all the necessary components. like SCC, isql , DBA Cockpit etc.

    First thing what we need is client to connect the database. So in $SYBASE directory you will find a file called SYBASE.sh/SYBASE.csh/SYBASE.env(in Unix environment) or SYBASE.bat(in Windows)

    At first site what you need to do is set the environment variables for the Sybase ASE .

    To do this

    On Unix

    $ . ./SYBASE.sh

    On Windows

    cmd/> SYBASE.bat

    On execution of these files you will find all required environment variables will set. Like $SYBASE, $SYBASE_ASE, $SCC_HOME etc.

    Now you are ready to connect your database.

    $isql -U<username> -S <servername> -w999

    when you will hit enter let the Unix system  ask for Password, enter the Password and you are inside the database. And you will see a prompt like

    1>

    This is all about connection to the database using isql.

     

     
  • sapsybdba 5:40 am on August 14, 2015 Permalink | Reply
    Tags: ASE   

    How to start SAP ASE database server in single mode ? 

    To start a SAP ASE database server in single user mode follow the below steps :

    1) Go to $SYBASE/$SYBASE_ASE/install directory.
    2) make a copy of your RUN_servername file for the backup purpose.
    3) edit the copied file and add -m flag at the end of the file and save it as m_RUN_servername. Like below

    #!/bin/sh
    #
    # SAP ASE page size (KB):       4k
    # Master device path:   /sybase/ase157/data/master.dat
    # Error log path:       /sybase/ase157/ASE-16_0/install/sybase16.log
    # Configuration file path:      /sybase/ase157/ASE-16_0/sybase16.cfg
    # Directory for shared memory files:    /sybase/ase157/ASE-16_0
    # License properties file:      /sybase/ase157/ASE-16_0/sysam/sybase16.properties
    # Interfaces file directory:    /sybase/ase157
    # SAP Adaptive Server Enterprise name:  sybase16
    #
    /sybase/ase157/ASE-16_0/bin/dataserver \
    -d/sybase/ase157/data/master.dat \
    -e/sybase/ase157/ASE-16_0/install/sybase16.log \
    -c/sybase/ase157/ASE-16_0/sybase16.cfg \
    -M/sybase/ase157/ASE-16_0 \
    -N/sybase/ase157/ASE-16_0/sysam/sybase16.properties \
    -i/sybase/ase157 \
    -ssybase16 \
    -m

    4) shutdown the server(ASE database).
    5) start the server with m_RUN_servername file.

    eg.

    % startserver -f m_RUN_servername

    OR

    % startserver -f RUN_servername -m

    above command will also start the database server in single user mode.

    And you can verify that from the logs you will get a message like,

    00:0006:00000:00001:2015/12/22 21:20:16.52 server  *** WARNING ******************
    00:0006:00000:00001:2015/12/22 21:20:16.52 server  ASE booted single user mode – updates allowed to system catalogs
    00:0006:00000:00001:2015/12/22 21:20:16.52 server  *** WARNING ******************

    This means that server is successfully started in single user mode.

    if you will still try to connect to the server using Interactive SQL then you will omit the error like below

     

    1

     

     
  • sapsybdba 5:10 am on August 14, 2015 Permalink | Reply  

    How to create a new server using buildserver utility

     
  • sapsybdba 3:23 am on July 4, 2015 Permalink | Reply  

    About Author 

    Hello…!!

    I am Pankaj Kumar Pathak working as SYBASE DBA professional in a multinational company.

    The idea behind writing this blog is just sharing my day to day experience with others like IT professionals, DBAs, Developers and all. And hoping this will help you as a guide.

    For any suggestion, advice and queries please write me :

    pathak1611@outlook.com

     

    SAPSYBDBA

     
c
Compose new post
j
Next post/Next comment
k
Previous post/Previous comment
r
Reply
e
Edit
o
Show/Hide comments
t
Go to top
l
Go to login
h
Show/Hide help
shift + esc
Cancel