If you’re loading a database from another O/S, not only does the dump file need to be created in a quiesced state, but after the load we need to issue the sp_post_xpload command to rebuild any corrupted indexes that maybe present. Start by loading the database as usual:- load database <DB Name> from “compress::<Dumpfile_Path_and_Filename>”go You’ll…
Following command can be used to dump a Sybase ASE database into multiple stripes:- dump database to ‘compress::<dumpfile_path_and_filename>_01.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_02.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_03.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_04.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_05.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_06.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_07.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_08.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_09.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_10.dmp’go Following command can be used to load a Sybase ASE database from multiple stripes:- load database from ‘compress::<dumpfile_path_and_filename>_01.dmp’stripe on…
The directio parameter allows you to configure Adaptive Server to transfer data directly to disk, bypassing the operating system buffer cache. directio performs IO in the same manner as raw devices and provides the same performance benefit as raw devices, but has the ease of use and manageability of file system devices. You cannot set…
In the following article we would rename a Sybase ASE DB named ABC to DEF. In order to rename the database we need to set the database in single user mode, by using the following command:- sp_dboption ‘ABC’,’single user’,truegouse ABCgocheckpointgo Once the DB is set to single user mode, we would call the sp_renamedb procedure…
When the free space in the device where the DB is hosted is exhausted Sybase ASE gives following error:- In such cases sometimes we need to extend the Database device, for which first we’ll identify the devices mapped to the database by executing following command:- Once the device is identified we would use following command…
In Sybase ASE the database is hosted on devices which in turn are mapped to physical datafiles. So to create a database we should have devices already created, if not we can create new devices as:- disk init name='<Device Name>’, physname='<PATH where the datafile would be created>’, size='<Size in MB>M’, directio=true go From the above…
This post is to provide a script to auto-start Oracle Instances on Linux upon server restart. First step would be to configure /etc/oratab file as per your requirement, oratab file is in the following format: <DB NAME>:<ORACLE HOME>:<Y|N> The last letter tells oracle if the database need to restarted or not, so we would change…
This post is to provide a set of queries to monitor any user session on an Oracle Instance more efficiently. Below query (Lets name it Query1 for the sake of discussion) gives you an overall status of what all sessions are active, what wait event they are waiting on and what are they executing. set…
If you have installed SQL Server using my previous post Install SQL Server 2017 on Linux, this post is to describe the directory structure of SQL Server on Linux. MSSQL binaries are installed under /opt/mssql folder. This folder further includes mssql binaries & libraries sub-folders:- MSSQL Binaries /opt/mssql/bin :- MSSQL Libraries /opt/mssql/lib :- Then comes…
This post is to guide SQL Server 2017 installation on Linux. You can create a Linux VM following my previous post of Installing Linux 7 on Oracle VirtualBox. Once the Linux VM is build follow the instructions below to install SQL Server latest release. Step 1: Download the Microsoft SQL Server Red Hat repository configuration…
Oracle Database Internal Mechanism 