Accessing DSODB using DB2 Connector Stage

ecclesr · Post by **ecclesr** » Tue Mar 03, 2015 7:31 pm

I am working a fresh installation of DataStage

I am now trying to build a test job to access first xmeta database, then to access dsodb database using DB2 Connector stage

I have a problem ensuring i am using the correct details for the connection in the DB2 connector

Instance: db2inst1
Database: xmeta
Username: xmeta

The connection failed.

An error occurred setting the active DB2 instance to value: xmeta. The active DB2 instance is already set to value: xmeta.

Similarly for dsodb

Instance: db2inst1
Database: dsodb
Username: dsodb

What should be the values in each case

Thanking you all in advance

ray.wurlod · Post by **ray.wurlod** » Tue Mar 03, 2015 8:54 pm

If you installed DSODB tables in the XMETA database, even though in a separate tablespace, try accessing its contents via XMETA but specifying DSODB as the schema name, for example SELECT * FROM DSODB.tablename;

qt_ky · Post by **qt_ky** » Tue Mar 03, 2015 9:28 pm

You may also want to try leaving the db2 instance value blank.

ecclesr · Post by **ecclesr** » Tue Mar 03, 2015 9:58 pm

Once I am able achieved a DB2 connector connection tested I would have applied a simple sql test of the form you have provided.

At this stage I not able to achieve a connection -I am doing some thing wrong

Addition Info

./DSAppWatcher.sh -test
DSODB is turned ON in the DSODBConfig.cfg file.
Link Monitoring is ON.
Job Run Usage is ON.
Resource Monitoring is ON.
Checking Database Connection:
Driver: com.ibm.db2.jcc.DB2Driver
Connection URL: jdbc:db2://xxxxx:50000/xmeta
Successfully loaded the database driver.
Successfully connected to the database.
Schema: DSODB
DB Schema version number: 2

ray.wurlod · Post by **ray.wurlod** » Wed Mar 04, 2015 3:47 pm

ecclesr wrote:At this stage I not able to achieve a connection

"Successfully connected to the database." in the test result gives the lie to your statement.

ecclesr · Post by **ecclesr** » Wed Mar 04, 2015 6:01 pm

Successful was from ./DSAppWatcher.sh -test

This morning I was successful in testing the connection to xmeta
Instance: db2inst1
DataBase:xmeta
User: db2inst1

I am now trying to do a similar connection to dsodb, but can not seem to get the following combination correct to do a connection test via db2 connector
Instance:
DataBase:
User:

What would the default values be

Thanking you all in advance

stuartjvnorton · Post by **stuartjvnorton** » Wed Mar 04, 2015 6:08 pm

Unless the person who did the install is reading dsxchange, it would seem to be more logical to just ask them what values they actually used.
Considering it's 11.3, they can't have gone too far.

ecclesr · Post by **ecclesr** » Wed Mar 04, 2015 6:18 pm

I have
Database:dsodb
Username:dsodb

Unsure what the instance should be

stuartjvnorton · Post by **stuartjvnorton** » Wed Mar 04, 2015 7:21 pm

Take a look at RepositoryAdmin

http://www-01.ibm.com/support/knowledge ... n_ref.html

and this:

http://www-01.ibm.com/support/knowledge ... tails.html

Should be able to tell you all about your registered repositories, databases, etc.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 04, 2015 9:32 pm

In particular:

RepositoryAdmin.sh -listRepositories

RepositoryAdmin.sh -listDatabasePlatforms

RepositoryAdmin.sh -listDatabaseServers -dt DB2 -dv 10.2

RepositoryAdmin.sh -displayRepository -rn dsodb

stuartjvnorton · Post by **stuartjvnorton** » Wed Mar 04, 2015 10:25 pm

ray.wurlod wrote:In particular:
RepositoryAdmin.sh -listRepositories

RepositoryAdmin.sh -listDatabasePlatforms

RepositoryAdmin.sh -listDatabaseServers -dt DB2 -dv 10.2

RepositoryAdmin.sh -displayReposi ...

Ray...! <stamps foot>