Execute "db list db directory" remotely after "db2 attach"

[Patrick Finnegan]

I have come back to DB2 after a few years absance. I want to attach
to a remote instance from a Windows DB2 client and then list the
databases on the remote Linux DB2 server.

db2 attach to "remotenode" user xxx using yyyy.

db2 list db directory.

I can attach and list the config of the remote instance using "db2 get
dbm config" but "db2 list db directory" just brings back the local
databases on my desktop. Is there a remote option to "db2 list db
directory"?

[Mark A]

Post by Patrick Finnegan
I have come back to DB2 after a few years absance. I want to attach
to a remote instance from a Windows DB2 client and then list the
databases on the remote Linux DB2 server.
db2 attach to "remotenode" user xxx using yyyy.
db2 list db directory.
I can attach and list the config of the remote instance using "db2 get
dbm config" but "db2 list db directory" just brings back the local
databases on my desktop. Is there a remote option to "db2 list db
directory"?

You need to telnet (ssh) to Linux server and then issue the command.

[Colin Booth]

Post by Patrick Finnegan
I have come back to DB2 after a few years absance. I want to attach
to a remote instance from a Windows DB2 client and then list the
databases on the remote Linux DB2 server.
db2 attach to "remotenode" user xxx using yyyy.
db2 list db directory.
I can attach and list the config of the remote instance using "db2 get
dbm config" but "db2 list db directory" just brings back the local
databases on my desktop. Is there a remote option to "db2 list db
directory"?

To get things working nicely you need to get things cataloged properly

Ensure that the admin server is running on the remote server
On the local system issue list admin node diectory and ensure that the
remote admin node is cataloged and if not catalog it.

It looks like the remote instance is cataloged. If you have had to catalog
the admin node then you may have to change the instance to refer to the
admin node
You should then be able to use the Command Center to list and catalog the
remote databases and any other instances owned by the admin node.

Once this is done you have the option of using the DB2 command processor or
the gui


Colin

[Patrick Finnegan]

Post by Colin Booth

Post by Patrick Finnegan
I have come back to DB2 after a few years absance. I want to attach
to a remote instance from a Windows DB2 client and then list the
databases on the remote Linux DB2 server.
db2 attach to "remotenode" user xxx using yyyy.
db2 list db directory.
I can attach and list the config of the remote instance using "db2 get
dbm config" but "db2 list db directory" just brings back the local
databases on my desktop. Is there a remote option to "db2 list db
directory"?

To get things working nicely you need to get things cataloged properly
Ensure that the admin server is running on the remote server
On the local system issue list admin node diectory and ensure that the
remote admin node is cataloged and if not catalog it.
It looks like the remote instance is cataloged. If you have had to catalog
the admin node then you may have to change the instance to refer to the
admin node
You should then be able to use the Command Center to list and catalog the
remote databases and any other instances owned by the admin node.
Once this is done you have the option of using the DB2 command processor or
the gui
Colin

I knew there was a way of doing this. I don't think the admin server
is running on the db2 box. I logged on remotely and checked. I will
have a word with the in house DBA.

db2 list admin node directory
SQL1027N The node directory cannot be found.

Thanks Everyone.