Getting Started
This chapter is a quick tutorial for newcomers. You can learn the basics of this program step by step.
First Look
Add a Platform
Add a Database
Connect to a Database
Edit DB Connection Information
Disconnect from a Database
Remove a Database
Remove a Platform
The AdminCenter for DBA window has two panes. The left one is for managing platform and database connections in a tree structure. The right one shows monitoring results.
Once connected to a database, you will see two main folders: Monitors and AMOND.
The Monitors folder has two child folders: User Monitors and System Monitors.
- "User Monitors" is a folder for user-defined monitors. DBAs can create their own monitors in this folder.
- "System Monitors" folder includes default monitors provided by AdminCenter for DBA.
The "AMOND" folder has two menus: DB Profile Job and OS Profile Job. These are to manage Profile Jobs at AMOND. As described in the previous chapter, DBAs can fully control DB Profile Jobs, such as adding/removing/editing/starting/stopping them.
OS Profile Jobs, however, cannot be created or removed by DBAs.
This will be discussed in greater detail in the "Working with Monitors" and "Working with Profile Jobs" chapters.
Before adding a new ALTIBASE database connection, you need add the platform which is a machine on which ALTIBASE DBMS(s) have been installed.
To add a platform, please follow these steps:
- Select "Registered Platforms" at the top of the left section.
- Open the context menu by clicking on it once with the right mouse button.
- Execute "Add Platform".
- 1.Fill in the input fields:
- Platform Name: You can enter any name, as long as it is unique in Altibase Explorer.
- Address: The IP address of the new platform.
- Click "OK".
Back to list
Now, it's time to add a new database connection based on the registered platform.
AMOND-based ALTIBASE
To add a platform, please follow these steps:
- Select the platform you added.
- Open the context menu by clicking on it once with the right mouse button.
- Execute "Add AMOND-based Altibase".
- Enter the AMOND information:
- AMOND Name: Enter any name you like, as long as it is unique.
- Port: The port number of the AMOND instance to connect to.
- User Id: A valid User ID for the AMOND connection.
- Password: The password for the user ID.
- Execute "Connection Test" and press the "Next" button.
- 1.Fill out the Altibase information
- Altibase Name: Enter any name you like, as long as it is unique.
- NLS for Client: This option is provided for use with Altibase versions 5.1.5 or lower. Choose an appropriate one if necessary.
- Fill out MR information
- MR Name: Enter any name you like as long as it is unique.
- NLS for Client: This option is for ALTIBASE 5.1.5 or lower version. Choose appropriate one if you need.
- Fill out Platform information for MR
- Platform Name: Enter any name you like, as long as it is unique.
- Address: The address of the new platform for MR
- Click on the "Finish" button.
Stand-alone Altibase Instance
- Select the platform you added.
- Open context menu by single click of right mouse button over it.
- Execute "Add Stand-alone Altibase Instance".
- Fill in the fields:
- Altibase Name: Enter any name you like, as long as it is unique in Altibase Explorer.
- DB Port: The port number of the database to connect to.
- DB Name: The name of the database to connect to.
- User ID: A valid user ID for the database.
- Password: The password associated with the user ID.
- NLS for client: Choose a character set for translating data from the DBMS on the client side. (This option is not necessary for Altibase DBMS versions 5.3.1 and above.)
- JDBC driver: The location of the JDBC driver to be used.
- To check your entries, please click "Connection Test".
- Click "OK" if everything is fine.
Back to list
You are ready to connect to the database.
- Select the database you added.
- Open context menu by single click of right mouse button over it.
- Execute "connect". This may take some time depending on your environment.
- When you have connected successfully, you will see the default system monitors and profile jobs management menus.
- If the connection fails, a warning dialog appears and gives you some information to help you solve the problem.
Back to list
Sometimes, you may need to edit database connection information; for example, you may need to change the account used to establish the database connection. This is possible only when the target database is disconnected.
AMOND-based ALTIBASE
In the case of an AMOND-based Altibase connection, AMOND manages most of the information pertaining to Altibase and the MR. So, with AdminCenter for DBA, the DBA can fully modify the AMOND connection information only on the client side. If the DBA wants to modify Altibase connection information, he/she needs to modify it by editing the AMOND configuration file on the server side.
- Select the database you added.
- Open the context menu by clicking on it once with the right mouse button.
- Execute "Edit AMOND".
- Change the fields as you wish.
- To verify your entries, please click "Connection Test".
- Click "OK" if everything is fine.
Stand-Alone Altibase Instance
- Select the database you added.
- Open the context menu by clicking on it once with the right mouse button.
- Execute "Edit".
- Change the inputs as you wish.
- To verify inputs, please hit "Connection Test".
- Click "OK" if everything is fine.
Back to list
After finishing your work, you need to close the connection to the target database.
- Select the target database.
- Open context menu by single click of right mouse button over it.
- Execute "Disconnect".
Back to list
When a registered database is no longer in use, you may want to remove it from Altibase Explorer.
- Select the target database.
- Open context menu by single click of right mouse button over it.
- Execute "Remove".
Back to list
When a registered platform is no longer in use, you may want to remove it from Altibase Explorer. However, keep it mind that if you remove a platform, all of the database connections associated with the target platform will also be removed.
- Select the target database.
- Open context menu by single click of right mouse button over it.
- Execute "Remove".
Back to list