Posts Tagged ‘Sybase IQ’

How to rename database in Sybase

Stored procedure sp_renamedb is used to change the user database. sp_renamedb dbname, new_name Where dbname is existing database name. new_name is the new database name.

How to start Sybase IQ server

To start Sybase IQ Server, first we have to set the Environment variables. Then, we have to create demo database. Using start_iq, we can Sybase IQ server. Setting Environmental Variables: 1. Navigate to Sybase Installation directory. In my case /opt/sapiq is the install directory.

Sybase IQ Configuration on Linux

1. Provide the http and hppts port numbers on which you want to configure Sybase IQ server. Default ports are 4282 and 4283. If you enter blank means default port 4282 and 4283.

Sybase IQ installation on Linux

We are going to install the Sybase IQ on Redhat Linux.SAP is providing for Sybase IQ 30 days Trial Evaluation copy. 1. Download the Sybase IQ from here 2. tar the Sybase IQ iq160_LinuxAMD64.tgz file by running following command. tar -xf iq160_LinuxAMD64.tgz 3. Navigate to extracted folder SAPIQ_1600_SP11-LinuxAMD64-eval is in my case. 4. Then, run […]

Powered by k2schools