'SQL1024N A database connection does not exist. SQLSTATE=08003' error while executing 'db2 -x' command through command stage in Datastage 9.1

data-warehouse datastage
Balasubramaniam Selva Perumal picture Balasubramaniam Selva Perumal · Mar 5, 2015 · Viewed 12.3k times · Source

I'm getting 'SQL1024N A database connection does not exist. SQLSTATE=08003' error, while executing 'db2 -x' command through execute command stage in Datastage 9.1(AIX Server). Can any one please help me out ?

Answer

Ashish Devassy picture Ashish Devassy · Mar 17, 2015

To connect to DB2 - you need a catalog entry on your Linux server ( or wherever the Datastage in installed)

You may need to check with the datastage administrator.

Use the below command on the server to see all the cataloged db2 databases

db2 list db directory

You may need to source the dsenv before you run this.

Related questions

Difference between Fact table and Dimension table?

When reading a book for business objects, I came across the term- fact table and dimension table. I am trying to understand what is the different between Dimension table and Fact table? I read couple of articles on the internet …

Read More
What is the difference between a database and a data warehouse?

What is the difference between a database and a data warehouse? Aren't they the same thing, or at least written in the same thing (ie. Oracle RDBMS)?

Read More
Database choice for large data volume?

I'm about to start a new project which should have a rather large database. The number of tables will not be large (<15), majority of data (99%) will be contained in one big table, which is almost insert/read only (no …

Read More