Sometimes if the shared memory is not configured correctly you can get following error when starting a Sybase Instance:- kernel os_create_region: can’t allocate … byteskernel kbcreate: couldn’t create kernel region.kernel kistartup: could not create shared memory These error messages mean that the shared memory is not correctly set on the Linux machine, please adjust the…
This post describes how to generate a temporary “sa” password in case the the existing password is lost or unknown. First of all the ASE needs to be shutdown, since you don’t have the “sa” password you need to shutdown ASE by killing the dataserver. kill -9 <PID of the dataserver> Now go to the…
Sometimes your load statement can abruptly terminate with following message:- ASE is terminating this process. If you try to bring the DB online following error message is received:- CT-LIBRARY error: ct_send(): network packet layer: internal Client Library error: State error: trying to write when connection is expecting a read. CT-LIBRARY error: ct_cancel(): network packet layer:…
It is possible to do a cross-platform dump and load procedure from any database dump that is at least at version 11.9.x, there are just some pre-requisites that must be met before the source database is dumped. The process requires that the database being dumped is in a quiescent state, i.e. there are no “open”…
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…
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…
Oracle Database Internal Mechanism 