SQL1013N The database alias name or database name "VED" could not be found.

[sivakumar_kilari3]

Hi,

I have installed 3 instances (db sids, VSM,VED,VEI) in one server.

OS : Windows 2003

DB: DB6 9.7 FP3

When I executing the following command getting error.

C:\Documents and Settings\vedadm>db2 connect to VED

SQL1013N The database alias name or database name "VED" could not be

found. SQLSTATE=42705

Its appearing only VSM.

C:\Documents and Settings\vedadm>db2 list db directory

System Database Directory

Number of entries in the directory = 1

Database 1 entry:

Database alias = VSM

Database name = VSM

Local database directory = D:\db2\VSM

Database release level = d.00

Comment = SAP database VSM

Directory entry type = Indirect

Catalog database partition number = 0

Alternate server hostname =

Alternate server port number =

Total 3 instances: VSM,VEI,VED

Database directory paths for 3 instances

VSM=D:\db2\VSM

VED=D:\db2\VED

VEI=D:\db2\VEI

Thanks

Siva

[Former Member]

Hi Siva,

I believe your other databases are created under separate db2 instance (i.e. db2vei and db2vee).

So if you log in with the user db2vei or db2ved, can you see the database VEI or VED via db2 list db directory command?

Regards,

Masako

[sivakumar_kilari3]

Hi Masako,

Thanks for your reply

Command line processor its appearing, but dos prompt level its appearing only VSM.

C:\Documents and Settings\db2ved>db2 list db directory

System Database Directory

Number of entries in the directory = 1

Database 1 entry:

Database alias = VSM

Database name = VSM

Local database directory = D:\db2\VSM

Database release level = d.00

Comment = SAP database VSM

Directory entry type = Indirect

Catalog database partition number = 0

Alternate server hostname =

Alternate server port number =

db2 => list db directory

System Database Directory

Number of entries in the directory = 1

Database 1 entry:

Database alias = VED

Database name = VED

Local database directory = D:\db2\VED

Database release level = d.00

Comment = SAP database VED

Directory entry type = Indirect

Catalog database partition number = 0

Alternate server hostname =

Alternate server port number =

Thanks

Siva

[Former Member]

Hi Siva,

Have you checked your DB2INSTANCE settings? (DB2INSTANCE is an environment variable.)

Please check the valud of DB2INSTANCE before you execute "db2 list db directory"".

(Example)

C:\Program Files\IBM\SQLLIB\BIN>set DB2INSTANCE

DB2INSTANCE=DB2

And how many instances do you have? Do you see 3 instances listed when executing db2ilist?

(Example)

C:\Documents and Settings\Administrator>db2ilist

DB2_01

How about db2 software? Did you install three copies of db2 software or just one? (You can check it via Add or Remove Programs in Control Panel.)

Regards,

Masako

[sivakumar_kilari3]

Hi Masako,

C:\Documents and Settings\Administrator.CMOSERVER>set DB2INSTANCE

DB2INSTANCE=DB2VSM

C:\Documents and Settings\Administrator.CMOSERVER>db2ilist

DB2VSM

3 instance is there in add and remove program mes.

C:\Documents and Settings\Administrator.CMOSERVER>db2 list node directory

SQL1037W The node directory is empty. SQLSTATE=01606

C:\Documents and Settings\Administrator.CMOSERVER>db2idrop VEI

SQL1394N The instance is not defined.

Thanks

Siva

[Former Member]

Hi Siva,

I believe that you have installed three copies of db2 software. And you have created one db2 instance in each DB2 copy. And each db2 instance has one database.

I believe you see "IBM DB2" if you click Start-> All programs. Do you have 3 instances under "IBM DB2"? And you should have db2 programs (like CLP or DB2 Command window) for each instance.

You need to invoke the appropriate CLP or DB2 Command Window for each instance. Then you will see the respective DB when you run "db2 list db directory".

Regards,

Masako

[sivakumar_kilari3]

If I login Each instance using DB2SID user, CLP or DB2 command window

there If execute db2 list db directory it will appear one instance only exmp: login instance.

Remaining instances its not appearing.

Thanks

Siva

[Former Member]

Hi Siva,

Since you're using 3 different DB2 software and you created 3 databases in 3 different db2 instances, you can only see one database at a time when you execute db2 list db directory.

If you want to switch DB2 copy, please refer to DB2 information center :

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.admin.dbobj.do...

Regards,

Masako

[sivakumar_kilari3]

Thank you, I understood now.

if i maintain multiple db copies Is there any problem?

In installation master it is asking every time RDBMS dvd. how to ignore this.

if I will install another instance again it will ask RDBMS so how to proceed? please tell me.

Thanks

Siva

[sivakumar_kilari3]

Thank you, I understood now.

if i maintain multiple db copies Is there any problem?

In installation master it is asking every time RDBMS dvd. how to avoid this.

if I will install another instance again it will ask RDBMS so how to avoid asking RDBMS dvd? please tell me.

Thanks

Siva