In IBM Data Studio, I can create a connection to a remote IBM DB2 LUW database named DBEMP and browse the schema and data.
Here is the steps to create the database connection:
- From IBM Data Studio, In Database Adminstration Explorer, select: New -> New Connection to Database.
- Select DB2 for Linux, UNIX, and Windows in the dialog.
In General properties:
Port Number: 50001
User Name: user1
But when I tried to connect to the remote database server (AIX v7) via telnet command:
Note: I login using root user.
And then I run this command:
/db2/V10.1/bin/db2 connect to DBEMP
I got this error:
SQL1013N The database alias name or database name "DBEMP" could not be found. SQLSTATE=42705
Then I also run this command:
/db2/V10.1/bin/db2 list database directory
The result list doesn't have database named "DBEMP".
So what happened anyway?
If there is no database name exist, why IBM Data Studio can connect to it?