Hi Alex,
Now I have uncataloged node and database. Currently no entry in db
directory of local database. When I using... db2 connect to
it is giving database name could not be found. db2 get instance
giving local instance name in which I have database. So how can I
solve that. It is in win 2003 server.

Thanks.
On Thu 28/02/08 3:19 PM , "Alex Levy " sent:
Correction: you can check your DB2INSTANCE variable and your current
attachment state by running the GET INSTANCE and ATTACH commands.
-----Original Message-----
Sent: 28 February 2008 15:17
Hi Manasa
If these are the commands you issued, then that database is classed
as
REMOTE, even though it's on a local server.
If it were local to the instance whose db2profile you've run, then
it would
already be catalogued.
So you don't need to catalog it in under another node, unless that
database
is in another instance.
If it's in another instance, then you have to ATTACH explicitly to
that
instance to run a list applications.
You can check your current instance and its attachment state by
running the
GET INSTANCE and ATTACH commands.
The empty list application output you are seeing is from whatever
instance
is in your DB2INSTANCE environment variable.
Regards
Alex
-----Original Message-----
From: manasa
Sent: 28 February 2008 14:24
Hi Geetha,
It is a local database. I used the following command to catalog.
db2 catalog local node instance < instance name>
db2 catalog db at node
Thanks.
On Thu 28/02/08 6:29 PM , "geetha" sent:
Hi,
Is that database local or remote?? And what are you trying to
do,also give the command you have used to CATALOG the database.
Thanks,
Geetha
-----Original Message-----
From: manasa
[Sent: Thursday, February 28, 2008 6:11 PM
Hi DBA's,
I cataloged localy one database in windows server. Though no
one is connected with that database, but it is giving SQL1226 the
maximum
no of client cunnection are already started. SQLSTATE= 57030
When I using list application it is returning no data.
NODE directory entry :
Node name = NDE9DC27
Directory entry type = Local
Protocol = Local
Instance name = LOYADM

DB directory entry:
Database alias = SIEBELdb
Database name = SIEBELDB
Node Name = NDE9DC27
Directory entry type = Remote
Can you please help to fix that problem.

Disclaimer: This communication is for the exclusive use of the intended recipient(s) and shall not attach any liability on the originator or ITC Infotech India Ltd./its Holding company/ its Subsidiaries/ its Group Companies. If you are the addressee, the contents of this e-mail are intended for your use only and it shall not be forwarded to any third party, without first obtaining written authorization from the originator or ITC Infotech India Ltd./ its Holding company/its Subsidiaries/ its Group Companies. It may contain information which is confidential and legally privileged and the same shall not be used or dealt with by any third party in any manner whatsoever without the specific consent of ITC Infotech India Ltd./ its Holding company/ its Subsidiaries/ its Group Companies.


DB2 & UDB email list listserv db2-l LazyDBA home page