I have a db2 client on my local linux machine:
alok@hostname:~$ uname -a Linux hostname 3.2.0-53-generic #81-Ubuntu SMP Thu Aug 22 21:01:03 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux alok@hostname:~$ db2 (c) Copyright IBM Corporation 1993,2007 Command Line Processor for DB2 Client 10.5.0 You can issue database manager commands and SQL statements from the command prompt. For example: db2 => connect to sample db2 => bind sample.bnd For general help, type: ?. For command help, type: ? command, where command can be the first few keywords of a database manager command. For example: ? CATALOG DATABASE for help on the CATALOG DATABASE command ? CATALOG for help on all of the CATALOG commands. To exit db2 interactive mode, type QUIT at the command prompt. Outside interactive mode, all commands must be prefixed with 'db2'. To list the current command option settings, type LIST COMMAND OPTIONS. For more detailed help, refer to the Online Reference Manual. db2 => There is a db2 installation on another machine on the network:
[dbadm@dbserver ~]$ uname -a Linux dbserver 2.6.32-131.0.15.el6.x86_64 #1 SMP Tue May 10 15:42:40 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux [dbadm@dbserver ~]$ db2 (c) Copyright IBM Corporation 1993,2007 Command Line Processor for DB2 Client 10.1.2 You can issue database manager commands and SQL statements from the command prompt. For example: db2 => connect to sample db2 => bind sample.bnd For general help, type: ?. For command help, type: ? command, where command can be the first few keywords of a database manager command. For example: ? CATALOG DATABASE for help on the CATALOG DATABASE command ? CATALOG for help on all of the CATALOG commands. To exit db2 interactive mode, type QUIT at the command prompt. Outside interactive mode, all commands must be prefixed with 'db2'. To list the current command option settings, type LIST COMMAND OPTIONS. For more detailed help, refer to the Online Reference Manual. db2 => list database directory System Database Directory Number of entries in the directory = 5 Database 1 entry: Database alias = TEST Database name = TEST Local database directory = /home/dbadm Database release level = f.00 Comment = Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number = Database 2 entry: Database alias = TESTDB2 Database name = TESTDB2 Local database directory = /home/dbadm Database release level = f.00 Comment = Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number = Database 3 entry: Database alias = TEST2 Database name = TEST2 Local database directory = /home/dbadm Database release level = f.00 Comment = Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number = Database 4 entry: Database alias = TESTDB15 Database name = TESTDB15 Local database directory = /home/dbadm Database release level = f.00 Comment = Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number = Database 5 entry: Database alias = SAMPLE Database name = SAMPLE Local database directory = /home/dbadm Database release level = f.00 Comment = Directory entry type = Indirect Catalog database partition number = -1 Alternate server hostname = Alternate server port number = db2 => Now I am trying to connect to this instance remotely. The first step, I am told, is to catalog the server on the client.
alok@hostname:~$ db2 catalog tcpip node dbremote remote 192.168.5.6 server dbadm SQL1092N The requested command or operation failed because the user ID does not have the authority to perform the requested command or operation. User ID: "ALOK". (192.168.5.6 is the ip corresponding to the hostname dbserver )
So there is something else the catalog command expects, and I don't know what. What is it?
