Sybase ASE – Error while loading shared libraries: libkonavm.so: cannot open shared object file

Sometimes due to missing library you can get following error in the errorlog:- error while loading shared libraries: libkonavm.so: cannot open shared object file: No such file or directory To fix such issues, find the path where libkonavm.so file is kept:- locate libkonavm.so Once the path is located, lets say its kept in /opt/sybase/ASE-16_0/symlib/libkonavm.so, create…

Sybase ASE – Read a dumpfile with headeronly

We can use the “headeronly” qualifier when reading a dumpfile to extract useful information which we can use to work out what is needed to setup a new database to load the given dump file. Using following command to read the dumpfile:- This would generate a output something like:- From the output we can get…

Sybase ASE – Rename a Database

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…

Sybase ASE – Extending an Existing Database Device

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…