System information

5.4 TME 10 NetFinity with Direct Access to the IBM DB2 NT Database
Since TME 10 NetFinity supports database access through the ODBC interface,
direct access to the database is not supported anymore.
However, it still works the same as it has in older versions. The only problem is
creating the database tables. The NetFinity database creation program
NETFINDB.EXE is not included anymore in the delivered diskettes or CD install
image. The only way for you to create the tables is through the ODBC interface.
Thus, ODBC support has to be installed and configured. Since this is still a good
way to save data, we covered it in this section.
TME 10 NetFinity will automatically recognize if a DB2 database server or client
is installed on the system and shows the DB/2 databases to select in the Export
to Database window.
However, you need to create the database, build the tables and views and bind
the application package delivered with TME 10 NetFinity to the database to make
all procedures available to the system. These procedures are stored in the
package field
DB2SQLC0.BND found in the \WNETFIN directory.
1. Create a new database for the TME 10 NetFinity data.
Open the DB2 Command Line Processor and enter following commands to
create a new database:
db2 => START DATABASE MANAGER
db2 => CREATE DATABASE NETFINS
2. Create the database tables through the ODBC interface with the TME 10
NetFinity Database Administrator as described in 5.2.3, “Create TME 10
NetFinity Tables through the ODBC Driver” on page 127.
3. Bind package to the database:
•
Start DB2 command line interface.
•
Connect to the TME 10 NetFinity database.
db2 => CONNECT TO database-name
•
Bind package file and grant public access to the package.
db2 => BIND drive\path\DB2SQLC0.BND GRANT PUBLIC
•
Reset database to activate package.
db2 => CONNECT RESET
The database is now ready to store data from TME 10 NetFinity.
5.5 Export Data from TME 10 NetFinity to Database
There are several functions in TME 10 NetFinity that can export data to the
database:
•
System Information
To save data to a database do the following:
− Run the System Information service.
− From the System Information top menu choose File and select Database.
140 Systems Management from an NT Server Point of View