Database alias = TEST123
Database name = TEST
Local database directory = /u01/TEST/db
Database release level = d.00
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Could not connect to the database when tried with dbname
/=>db2 connect to TEST
SQL1013N The database alias name or database name "TEST" could not be found.
I am able to connect to the database with Alias name.
/=>db2 connect to TEST123
Database Connection Information
Database server = DB2/AIX64 9.7.3
SQL authorization ID = tstusr
Local database alias = TEST123
Wanted to know if we can connect to the database with dbname or I should use only Alias .
yes correct - use the alias
imagine multiple sample db on different systems - they are all cataloged with different alias..
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be