Altibase is an in-memory database software with high performance, fault tolerance and transaction management convenience. It is widely used in fields such as communications, online banking, securities trading, real-time applications and embedded systems. Now we start installing it under Windows system.
(1) Download the installation package
First, select the altibase installation package to be downloaded. The download address of the installation package is PKG Search. According to your own system platform, select the corresponding version to download.
Once the download is complete, select Run as administrator.
(2) Installation
Basically just keep clicking Next
Select initial database size, character encoding
Select the database directory and log directory. It is recommended not to move
Check property settings
Install for all users and install drivers
Next step
start installation
Just choose the community version
Do you want to start “postinstall winbat” now? – This script will create the database, click on the select box, next.
Add altibase as a Windows service to facilitate self-starting in the future
Configure service name and system login password
Service registration successful
ALTBASE HDB was successfully registered as a Windows service, but the ALTBASE HDB service failed to start. Click OK first and then set it up.
At this point, the installation is complete!
When prompted to restart the computer, click Yes after saving all work progress. Restart the computer!
(3) Post-installation settings
After restarting,remember that the service registration was successful but the service could not run?
Right click on this computer and select Manage
Find the altibase service you just registered in Services
After opening, set the login identity as the local system account, click Apply and Confirm
Start the current service and the status is running.
(4) Login
Altibase uses ISQL to connect to the database, and the default connection method is TCP/IP.
Login command:
isql -s <host> -u <user> -p <password> -port <port>
Among them,
Note: In Altibase, after installation, the default administrator username is sys and the password is manager.
Open the CMD window and enter the command:
isql -s 127.0.0.1 -u sys -p manager -port 20300
When iSQL> appears, the login is successful!
If you want to change the login password, you can use the sql statement:
ALTER USER sys IDENTIFIED BY "new_password";
Among them, new_password is the new password you want to set. If you are not an administrator, you can log in with an administrator account, create a new user and set a password. For example, if you want to change the password to 123456: ALTER USER sys IDENTIFIED BY “123456”;
(5) Completed
At this point, Altibase has been installed under Windows system!
View all tables in the memory library:
select * fom tab;
You can view all table information and use SQL statements to operate the database.
For example: create a database and add data, rememberto submit!
The knowledge points of the article match the official knowledge files, and you can further learn related knowledge. Java Skill TreeHomepageOverview 138332 people are learning the system