DB2 Concepts and Enovia V6 Installation on AIX

Enovia V6 installation on AIX with DB2 was always a problem for us to maintain various environments. We always used single instance and single database. Moreover Application Server, Web Server and Database Server were on same hardware.

This time database server was different. Somehow db was moved to other server without consulting environment owner. Hence our environment was directly affected. We tried to move some parameters by changing few paths in environment and installation files. But it did not work. We made sure that we have a db2 client installed on our application server. But all efforts were unsuccessful.

Finally we concluded that if instance is moved or renamed will not work for current environment and new installation is required. So we decided to for a new installation. Following was our plan which was successful for installation. Deployment is pending.

  1. We used existing instance (e.g. INST1)
  2. We used existing db user (e.g. dbuser)
  3. Now we created 2 different databases on DB Server. (e.g db1 and db2)
  4. Next task was to configure client to access these 2 databases. Hence we created one more instance on client (dbuser, yes we kept name same as server db user). Our client has same user name for db user as dbuser on server.
  5. We cataloged dbs on client instance as db1db for db1 and db2db for db2.

Rest all was easy to do. When we install Enovia V6 on AIX using DB2 as database system we need 2 parameters. Following are the details.

  1. Database Instance name on which we catalog our database. In our case this name is dbuser (Do not get confused. J This is instance name on client with same name for database user. ) This is required while installing Studio as well as Server.
  2. Catalog Name as connection string which is used to generate Bootstrap file (e.g. MATRIX-R)

Rest of the Enovia installation is almost same as on windows. On 2012, DS has provided GUI for installation which is a great help for administrators. Yes, there are few annoying things like installer always refers to default path and does not consider your custom paths even if you provide at the start of installation.

This was a good learning for us when installing Enovia V6 2012 on AIX with DB 9.7.

If you have any queries, please ping me.

-Ashish Kulkarni

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s